Design a conceptual database on one of given three scenarios

Assignment Help Database Management System

Reference no: EM131591743

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.

Reference no: EM131591743

Questions Cloud

Compute the number of units remaining : Compute both the cost of goods available for sale and the number of units available for sale. Compute the number of units remaining in the ending inventory

Business with other cultures : 1) Describe these cultures: South/Southeast Asia, Middle-East, and Latin America.

Write a class called square that is child class of rectangle : Write a class called Square that is a child class of Rectangle. A square is a rectangle with equal sides. It should inherit the perimeter() and area() methods.

Explain the expected outcomes of the project : Describe the proposed solution (or intervention) for the problem and the way(s) in which it is consistent with current evidence.

Design a conceptual database on one of given three scenarios : Design a conceptual database on one of the three scenarios above. Example of five SQL scripts to illustrate your business rules.

Solving for rates-what annual rate of return is earned : Solving for Rates What annual rate of return is earned on a $3,400 investment when it grows to $7,300 in nine years?

Classify cash and cash equivalents : The financial statements of Marks and Spencer plc (M&S) are available at the book's companion website or can be accessed.

What effect of the speaker referring directly to reader : What is the effect of the speaker referring directly to the reader, listener Who do you think the speaker is speaking to

Minimum pay regulation in the united states : Discuss the main difference between the minimum pay regulation in the United States (Chapter 2) and one other country's practice discussed in Chapter 15.

User Account

All Pages