Scribd
Upload
15 views1 page

ER-Model and Normalization Exercise Guide

The document outlines the requirements for Exercise 1, which includes creating ER-Model diagrams for various use cases related to student placement tests, employee department assignments, movie attendance tracking, coffee bean retailing, and an IT conference. It also specifies the need to provide 1NF, 2NF, and 3NF based on a list of columns related to customer orders. Submissions must be in a Word document format with clear screenshots and adhere to a specific naming convention.

Uploaded by

gurjitca88
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views1 page

ER-Model and Normalization Exercise Guide

The document outlines the requirements for Exercise 1, which includes creating ER-Model diagrams for various use cases related to student placement tests, employee department assignments, movie attendance tracking, coffee bean retailing, and an IT conference. It also specifies the need to provide 1NF, 2NF, and 3NF based on a list of columns related to customer orders. Submissions must be in a Word document format with clear screenshots and adhere to a specific naming convention.

Uploaded by

gurjitca88
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Exercise 1

• The submission should be a Word document with clear screenshots of the query and the output.
The file naming convention should be YourName_HumberId_Exercise1.docx
o Failing to adhere to any instructions will result in negative marking.
• Complete all the questions and provide clear screenshots where applicable.

Create ER-Model diagram for the following use cases:

• A college needs to track placement test scores for all incoming students. Each student can take a
variety of tests, including English and math. Some students are required to take placement tests
because of previous coursework.

• Every employee in a company is assigned to one department. Every department can contain
many employees.

• A movie megaplex needs to collect and analyze movie attendance data. The company maintains
16 theaters in a single location. Each movie offered can be shown in one or more of the available
theaters and is typically scheduled for three to six showings in a day. The movies are rotated
through the theaters to ensure that each is shown in one of the stadium-seating theaters at least
once.

• An online retailer of coffee beans maintains a long list of unique coffee flavors. The company
purchases beans from several suppliers; however, each specific flavor of coffee is purchased
from only a single supplier. Many of the customers are repeat purchasers and typically order at
least five flavors of beans in each order.

• Data for an information technology conference needs to be collected. The conference has a
variety of sessions scheduled over a two-day period. All attendees must register for the sessions
they plan to attend. Some speakers are presenting only one session, whereas others are
handling multiple sessions. Each session has only one speaker.

Based on the below list of columns, provide 1NF, 2NF and 3NF:

- first name, last name, billing address, quantity, retail price, shipping address, order date, ship
date

You might also like