ERD and Normalization- Database
I need help with the below Database Assignment.
DATABASE expert only approach.
AutoParts Warehouse
AutoParts Warehouse is a small auto parts supplier with locations in several Midwestern metro areas. The business is based on the idea of discount prices for auto parts that are always in stock or can be delivered within hours. The owners have decided to computerize their operations to allow them to better track their business and manage their inventories for just in time deliveries for sales. Data to be gathered for each customer sale includes invoice number, date, parts number, cost, retail price. Customer data is collected that includes basic contact information and vehicles owned, which includes vehicle make and model. For parts that have to be delivered to the store to fulfill a customer purchase, a transfer request is created. Data associated with these transfers include tracking number, invoice number, date, parts number, origination location (store or warehouse) number, destination store number.
Assignment 2
Task 1
Draw an ERD for AutoParts Warehouse indicating the types of relationships between the entities. (30%)
Task 2
For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys. (25%)
Task 3
Create fully normalized 3NF table designs for the system. (25%)
Task 4
Suggest ways AutoParts Warehouse can use codes to simplify output, input, and data formats. (20%)
11 years ago
15
- Homework week 5 PS
- Do you believe that it is appropriate that we have a single, global set of accounting standards as well as
- Comm. College Accounting II Class - Take Full Class $500.00
- 1/2[(10-G)+(-6+3G)]
- Math questions
- make a research about the causes and prevention of men erectile disfucction
- Ann ran 5-kilometer race in 25 minutes. Mark ran the 2-kilometer race in 75 minutes which runner ran at the...
- Define Anthropologist.
- Most three dimensional creations will require some sort of?
- Are federalists republicans or democrats