How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask jatechexpert Your Own Question

jatechexpert
jatechexpert, Computer Software Engineer
Category: Programming
Satisfied Customers: 1415
Experience:  Master of Computer Application plus 5+ year experience in Software development
Type Your Programming Question Here...
jatechexpert is online now
A new question is answered every 9 seconds

I am taking a database class and not doing well. I need to

Resolved Question:

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.
Submitted: 2 years ago.
Category: Programming
Expert:  jatechexpert replied 2 years ago.
hi

thanks for using justAnswer.com
send all information
Customer: replied 2 years ago.
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:

 

  • o Description of the problem and its organizational and business impact.
  • o Proposed solution, solution objectives, and solution feasibility.
  • o Costs and benefits of the solution you have selected. The company has a PC with Internet access and the full suite of Microsoft Office desktop productivity tools.
  • o Information requirements to be addressed by the solution.
  • o People, organization, and technology issues to be addressed by the solution, including any proposed changes in business processes.

 

Based on the requirements you have identified:

 

  • o Prepare an entity relationship diagram which models your proposed design.
  • o Write the SQL statements to create the database tables, relationships and populate each table with at least 10 records per table, where applicable.
  • o Use Microsoft Access to create a database called Ace-Auto-Dealers.accdb using your SQL scripts.
  • o Finally, use the database system you have created to generate data input forms, queries and reports that would be of most interest to management. The system is to support only the processing requirements described for the existing manual system. You should have:
  • o A minimum of 3 data input forms depending upon your database design
  • o The following queries are required:
  • § Which touch point generates the most sales leads? Least sales leads?
  • § Which touch point generates the most purchases? Least purchases?
  • § Which sales representative sells the most vehicles?
  • § What is the best selling make of model?
  • o The following reports are required:
  • § Customer profile
  • § Leads by touch point including customer information
  • § Sales by touch point including customer and vehicle information

 

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.

Expert:  jatechexpert replied 2 years ago.
hi

let me check these
what is your due date
Customer: replied 2 years ago.
Friday- Feb 17
Expert:  jatechexpert replied 2 years ago.
hi
ok
Customer: replied 2 years ago.
so you are going to help me?
Expert:  jatechexpert replied 2 years ago.
hi
yes
Customer: replied 2 years ago.
Great thank you!
Expert:  jatechexpert replied 2 years ago.
hi

ok

Expert:  jatechexpert replied 2 years ago.
hi

sorry i didn't look by mistake
do you need it now

almost i completed
if you need it, i will complete it and send to you
Customer: replied 2 years ago.
Need it by Saturday.
Expert:  jatechexpert replied 2 years ago.
hi

ok i will complete it and send soon
Customer: replied 2 years ago.
why does the status say- Relist?
Expert:  jatechexpert replied 2 years ago.
hi

no nothing not relisted
Customer: replied 2 years ago.

ok just checking- thank you for helping me

 

Expert:  jatechexpert replied 2 years ago.
hi

ok see you soon
Customer: replied 2 years ago.
This question is listed as closed and relist? I am a little nerveous- are you still working on it?
Expert:  jatechexpert replied 2 years ago.
hi
yes i am working don't worry
Customer: replied 2 years ago.
Thank you so much. I know that whether I pass or fail this class depends on this.
Expert:  jatechexpert replied 2 years ago.
hi

ok no problem
i will send this
Expert:  jatechexpert replied 2 years ago.
hi

here is the answer link below

http://wikisend.com/download/306992/Ace Dealer.doc]Ace Dealer.doc


hope this helps
jatechexpert, Computer Software Engineer
Category: Programming
Satisfied Customers: 1415
Experience: Master of Computer Application plus 5+ year experience in Software development
jatechexpert and other Programming Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5603
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/unvadim/2010-11-15_210218_avatar.jpg unvadim's Avatar

    unvadim

    Computer Software Engineer

    Satisfied Customers:

    1158
    Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    950
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    864
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/RA/rajivsharma086/2012-6-6_17128_displaypic.64x64.jpg Raj's Avatar

    Raj

    Computer Engg.

    Satisfied Customers:

    860
    BE CS, 4+ Experience in Programming and Database (ERP)
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    590
    11 yrs of programming (PHP, WordPress, XSL, SQL, JavaScript)