Question
For each of the following problems, design an appropriate database, drawing an ER diagram and writing a database design outline.In each question below, assume that
For each of the following problems, design an appropriate database, drawing an ER diagram and writing a database design outline.In each question below, assume that any address information specified is in US format, consisting of fields for street address, city, twoletter state code, and zip code. Unless stated otherwise in an individual problem, assume that you do not have the master zip code table in your databases, so that city, state, and zip code may be treated as independent.
you work for a program that makes musical instruments available to underprivileged children. For each general type of instrument, you want to store a name (such as flute or trombone) and the minimum student age for which the type of instrument is suitable. Each particular instrument is identified by a property tag carrying a unique number. For each individual instrument, you want to store its type, manufacturer, model name, date manufactured, and notes. For each child, you want to store the first name, middle name/initial, last name, date of birth, gender, address information, and phone number. You also want to keep track of loans of instruments to children, each of which involves one instrument and one child. For each loan, you want to keep track of the date the loan started and (if applicable) the date the loan ended. Assume that you do have access to a master zip code table specifying the city and state for each zip code in the programs service area.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started