Database design 1

I’m stuck on a Writing question and need an explanation.

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.)