DBMS (Computer Information Systems)
Business Rules:
Each reservation belongs to a specific customer; customers may or may not have any reservations.
Each customer is a specific type; some customer types may not have any customers.
Each reservation is booked by a specific agent; each agent may or may not have booked any reservations.
Each agent works for a specific department; each department has at least one agent (employee).
Each reservation is for one or more rooms, all with the same rate type within the same reservation, but rates types may vary from reservation-to-reservation; some rooms may not have any reservations.
Based on the information provided above, complete the following:
1. FIRST NORMAL FORM (1NF) – 20 points:
a. Decompose the composite attributes into simple attributes.
b. Convert the table above to 1NF (eliminate repeating groups of data and select an appropriate PK).
c. Show the table structure format (table name with PK and all dependent attributes in parentheses).
d. Create a dependency diagram for the table above.
2. SECOND NORMAL FORM (2NF) – 20 points:
a. Show the table structure format for each table in 2NF.
b. Create the dependency diagrams for the resulting tables.
3. THIRD NORMAL FORM (3NF) – 25 points:
a. Convert to 3NF and show the table structure format for each table.
b. Create the dependency diagrams for the resulting tables.
4. ENTITY-RELATIONSHIP MODEL – 35 points:
a. Create a relational schema showing all 3NF tables (entities), their attributes, and the connectivity of the relationships. Each entity should be depicted as a rectangle with the name and the top and the attributes listed under the name. This may be done in Access.
b. Using Chen notation, create an ERD showing all of the 3NF tables above. You must show the entities, relationships, connectivity, participation, and cardinality (it is not necessary to show the attributes on the ERD).
This assignment is due by 11:59 PM on the due date. Microsoft Visio or other diagramming software is recommended to create the required diagrams. Please upload your assignment as a single document. This may be done by putting all diagrams into a single Word, Excel, or PDF file.
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp Order Paper Now