Submitted by: Submitted by ellenkim718
Views: 360
Words: 436
Pages: 2
Category: Business and Industry
Date Submitted: 01/13/2013 05:27 PM
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...