I am taking a database class and not doing well. I need to design a database and do a 2 page systems analysis. I can provide all information, but have no idea where to even start.
Computer OS: Windows 7
Programming Language: SQL & MS Access
hithanks for using justAnswer.comsend all information
Here is all the info I have on this project:
This project requires you to perform a systems analysis and then design a system solution using database software. Ace Auto Dealers specializes in selling new vehicles from Subaru. The company advertises in local newspapers and is listed as an authorized dealer on the Subaru Web site and other major Web sites for auto buyers. The company benefits from a good local word- of- mouth reputation and name recognition and is a leading source of information for Subaru vehicles in the Portland, Oregon, area. When a prospective customer enters the showroom, he or she is greeted by an Ace sales representative. The sales representative manually fills out a form with information such as the prospective customer's name, address, telephone number, date of visit, and make and model of the vehicle in which the customer is interested. The representative also asks where the prospect heard about Ace- whether it was from a newspaper ad, the Web, or word of mouth- and this information is noted on the form also. If the customer decides to purchase an auto, the dealer fills out a bill of sale form.
Ace does not believe it has enough information about its customers. It cannot easily determine which prospects have made auto purchases, nor can it identify which customer touch points have produced the greatest number of sales leads or actual sales so it can focus advertising and marketing more on the channels that generate the most revenue. Are purchasers discovering Ace from newspaper ads, from word of mouth, or from the Web?
Prepare a two-page systems analysis report, in APA format, detailing Ace's problem and a system solution that can be implemented using PC database management software. Then use database software to develop a simple system solution. Your systems analysis report should include the following:
Based on the requirements you have identified:
You may choose to add more sophistication to your DBMS application, but you are not required to do so. While the more you do, the better your performance will be judged, it is better to do the basics right, than to develop a sophisticated DBMS application which does not work properly. In making your decision, please keep in mind the time available to complete the project, your relative experience with DBMS software, and your prior experience with Access' advanced capabilities. You are not required to go beyond the basic application framework.
hilet me check thesewhat is your due date
Friday- Feb 17
so you are going to help me?
Great thank you!
hisorry i didn't look by mistake do you need it nowalmost i completedif you need it, i will complete it and send to you
Need it by Saturday.
hiok i will complete it and send soon
why does the status say- Relist?
hino nothing not relisted
ok just checking- thank you for helping me
hiok see you soon
This question is listed as closed and relist? I am a little nerveous- are you still working on it?
hiyes i am working don't worry
Thank you so much. I know that whether I pass or fail this class depends on this.
hiok no problem i will send this
hihere is the answer link below http://wikisend.com/download/306992/Ace Dealer.doc]Ace Dealer.dochope this helps
Master of Computer Application plus 5+ year experience in Software development