Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Internal Auditing Pocket Guide

Authors: J. P. Russell

1st Edition

0873895606, 978-0873895606

More Books

Students also viewed these Accounting questions

Question

Write a Python program to check an input number is prime or not.

Answered: 1 week ago