1. Create a conceptual ER diagram given a set of functional requirements Case Study 1 Consider an INSTRUMENTS database in which a band instructor keeps track of students who are renting instruments. The data requirements are summarized as follows: • Students are identified by a unique student number, name (which is their first, middle, and last name), address, city, state, and zip code. • Each instrument is identified by a unique inventory number, instrument name, if it includes a case or not, and daily rental cost. • Each current rental is defined by a transaction that includes the student, the instrument rented, the rental date, the due date, the number of days rented (which is calculated, rather than stored), and the cost of the rental (which is calculated, rather than stored). • When an instrument is returned, the database will store the condition of the instrument (a rating from 1- 10), the student who returned the instrument, and the date it was returned in a separate table.
1. Create a conceptual ER diagram given a set of functional requirements
Case Study 1
Consider an INSTRUMENTS
instruments. The data requirements are summarized as follows:
• Students are identified by a unique student number, name (which is their first, middle, and last name),
address, city, state, and zip code.
• Each instrument is identified by a unique inventory number, instrument name, if it includes a case or
not, and daily rental cost.
• Each current rental is defined by a transaction that includes the student, the instrument rented, the rental
date, the due date, the number of days rented (which is calculated, rather than stored), and the cost of the
rental (which is calculated, rather than stored).
• When an instrument is returned, the database will store the condition of the instrument (a rating from 1-
10), the student who returned the instrument, and the date it was returned in a separate table.
Step by step
Solved in 2 steps with 1 images
