Cis 360 Database Problem

Ellen Kim

CIS 360/Tuesday-Thursday 12:00-1:15

25 September 2012

Assignment #1: E/R Diagramming

Part I: A bank has three types of accounts: checking, savings, and loan. The attributes for each type of accounts follow:

* CHECKING: Acct_No, Date_Opened, Balance, Service_charge

* SAVINGS: Acct_No, Date_Opened, Balance, Interest_rate

* LOAN: Acct_No, Date_Opened, Balance, Payment

Part II: Draw an E/R diagram for a real estate firm using the following description:

* The firm has a number of sales offices in several states. Attributes of sales office include office_no and location.

* Each sales office is assigned one or more employees. Attributes of employee include emp_id and emp_name. An employee must be assigned to only one sales office.

* For each sales office, there is always one employee assigned to manage that office. An employee may manage only the sales office to which she is assigned.

* The firm lists property for sale. Attributes of property include property_id and location.

* Each unit of property has one or more owners. Attributes of owners are owner_id and owner_name. An owner may own one or more units of property. An attribute of the relationship between property and owner is percent_owned.

Part III: You have been asked to complete an E/R diagram for a symphony orchestra. The information that you've been able to gather from several employee interviews reveal the following:

* CONCERT SEASON the season during which a series of concerts will be performed. Identifier is opening_date which includes month, day, and year.

* CONCERT a given performance of one or more compositions. Idenifier is concert_no. Another important attribute is concert_date, which consists of month, day, year and time.

* COMPOSITION compositions to be performed at each concert. Identifier is composition_id. Other attributes include composition_name, composer_name, movement_no and movement_name.

* CONDUCTOR person who...