Describe how your database will provide your client

Assignment Help Database Management System

Reference no: EM131590221

Assignment

ACME Motors recently opened a new dealership to sell locally here in San Diego in the Poway area. As part of their new setup they will not only sell, but also service and repair ACME vehicles. They are in need of a parts inventory, maintenance and sales system to support their service bay operations.

Unfortunately, they have looked at buying COTS existing packages from ImaginaSoft but found the cost and time to deploy un-acceptable given their impending new launch of the new much sought after ACME Electric Hybrid convertible sports car among other new model lines. They are looking for a crack team of software professionals to come in there and get a small but reliable system up and running to support operations immediately, and then evolve the system as time goes by.

· Design a conceptual database on one of the three scenarios above.

· ER Diagrams in Crow's foot notation using Visio or graphic modeling software of your choice which include entities and their relationships.

· At least 5 business rules

· An introduction that outlines your proposal of at least 250 words

· A conclusion paragraph of at least 250 words

· Tables created with reasonable representative data values

· Example of five SQL scripts to illustrate your business rules.

· Describe how YOUR Database will provide your client with the advantages of better data quality, end-user productivity, data sharing, data security, data access and increased decision making.

Requirements of final written Project Report:

· Each individual will complete and submit a report based on ONE of the three scenarios

· Paper will be APA style format; double-spaced, using times new roman 12-point font with 1-inch margins all around.

· The entire paper should be no more than 7 pages including title page, and references. No abstract is required. I expect close to five pages of content which includes tables and diagrams.

· The paper should contain only substantive, relevant information.

· Use at least 3 citations/references

· Citations must clearly specify for the reader what is written material and where it may be found using APA style. Do not use footnotes.

Reference no: EM131590221

Questions Cloud

Analyze the competitive environment of a health services : Analyze the competitive environment of a health services organization and identify a course of action that will allow for strategic marketing success.

Knowledge of different specialties : In any place you choose, it would be great to have a general knowledge of different specialties to give you a boost of confidence.

Discuss quality healthcare delivery and research techniques : Chose one (1) example of how healthcare data is incorporated into statistics and research. Next, hypothesize two (2) ways that today's healthcare informatics.

Calculate net cash provided by operating activities : Christchurch Motors Pty Ltd completed its first year of operations on 30 June 2015. Calculate net cash provided by operating activities using the direct method

Describe how your database will provide your client : Describe how YOUR Database will provide your client with advantages of better data quality, end-user productivity, data security and increased decision making.

Journalize the transactions : Bair products Inc, a wholesaler of office products, was organized on January 30 of the current year, Journalize the transactions

Periodic quizzes and other assessments are beneficial : Which of the following is the most likely reason why the students have become distracted and have started talking

Describe the major physical developmental milestones : Describe the major physical developmental milestones from birth to death.

Journalize the entries to record the transactions : Journalize the entries to record the following transactions for Mountain Realty Inc. Refer to the Chart of Accounts for exact wording of account titles

User Account

All Pages