MITS 5502 VIT Wk 7 Autozone Motor Shop Database Design to Store Information Discussion

2. Database Design – Due in week 7

You will be designing an efficient and useful database design to store the information needed for the proposed system.

A well-structure database:

1. List all the entities with their attributes including the datatype to store the information for the given system. The nonduplicate entities gets converted into table with attributes as fields within the given database.

2. Identify the attribute(s) that will serve as a primary/foreign key for each table. Attributes chosen as primary key should be unique, unchanging and never defined as NULL/empty.

Copyright © 2020 VIT, All Rights Reserved. 4

MITS5502 Project

3. Create relationships between the given tables. Each defined entity has a relationship with every other one (one-to-one, one-to-many, many-to-many, mandatory etc.)

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: