Data Modeling Practice examples1 - Data Modeling Practice...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Practice Problems Data Modeling Practice When Arrow appears, left click anywhere or press Page Down to
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Practice Creating ERD’s Problem s The following slides contain several problems. To obtain the best results, view the problem, create your solution. You can practice these examples without cardinality/modality and then repeat later adding them.
Background image of page 2
Dance Studio Example Consider a database for a dance studio. The following data items are needed: dancer’s identification number, dancer’s name, dancer’s address, dancer’s telephone number, class identification number, day that the class meets, and time that the class meets. Assume that each student must take at least one class and each class may have many students, but may not have any.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The Personnel Director Example You have been hired as a personnel director for a medium-sized company with offices in several cities. You require the usual personal data for each employee including birth date, hire date, home address. You also need to reach an employee at work, and must be able to retrieve the branch office address, branch office phone number, and branch office fax number. Each employee is
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/21/2011 for the course CGS 2545C CGS 2545c taught by Professor L during the Summer '10 term at University of Central Florida.

Page1 / 8

Data Modeling Practice examples1 - Data Modeling Practice...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online