IS 342 - Enterprise Database Management (Quad Cities Campus)

Assignment 3 ER Modeling

Due 5 April, 2010

Instructions:

Create ER diagrams for the following scenarios.

1.  Sally is in charges of a large bookstore chain.  

    She wants to maintain information about publishers of text books, the books they 
    publish, and the authors of those books.  

    Publishers can publish many books.  Books are published by only one publisher.  
    Books may have more than one author and and an author may have authored more 
   than one book.  If more than one author collaborated on a text, we want to keep track 
    of the order that their names should be listed when giving credit for authorship.
    
    Attributes that define a publisher are publisher id, name,
    POC (point of contact), street address, city, state, zip code, country,
    and telephone.  

    Attributes that define a book are ISBN (uniquely defines
    a book), title, sub title, year published, genre.  Attributes of an author
    are author id, first name, last name, and country.


2.  Steve operates a cinema chain and has given you the following information:

    "I have many cinemas.  Each cinema can have multiple theaters.  Movies are
     shown throughout the day starting at 11 A.M. and finishing at 1 A.M.  Each
     movie is given a two-hour time slot.  We usually do not show a movie in
     more than one theater at a time, but we do shift movies among theaters because
     seating capacity varies.  I am interested in knowing how many people,
     classified by adults and children, attended each showing of a movie.
     I vary ticket prices by movie and time slot.  For instance, Lassie Get Lost
     at 11 A.M. is 50 cents for everyone but is 75 cents  for adults and  50 cents
     for children at 11 P.M."
     
     Attributes of a cinema are cinema id, name, street address, city, and phone 
     number.

     Attributes of a theater are theater number (1, 2, 3, 4, etc), seating capacity, 
     and sound system.  Attributes of a movie are movie id and title.

3.   A real estate investment company owns several strip malls.  It leases the  
     stores in those strip malls to retailers. Each store has a monthly revenue 
     (sales) that varies from month to month.  Every month, each store has both 
     scheduled maintenance costs and unscheduled maintenance costs that the 
     investment company wants to track.  The way the investment company calculates 
     the fee the retailers pay for their lease is based on a rental charge that is 
     set for each store plus a negotiated percentage of the monthly sales for 
     the shop.  This negotiated percentage is different for each lease agreement.  
     In addition, if a retailer (lessee) leases more than one store the investment 
     company gives them a discount on all of their leases.  The discount is based 
     on the number of stores the lessee leases.  We need to additionally track the 
     date a lease started, ended, and the name the lessee gave the store during the 
     lease. 
     
     Attributes of a strip mall are mall id, name, street address, city, state.
     Some attributes of a store are store number and square footage.

     Attributes of a lessee are id, company name, POC (point of contact ) first name,
     POC last name, street address, city, state, and phone.

NOTE:   Not all attributes you will need to show on the diagrams are explicitly 
       listed.
  

What to turn in:

ER diagrams for each scenario. 

Please use the ER-Assistant modeling tool for creating your diagrams.  (For consistency in grading)

Hint:  Use ER-Assistant's built in tools to check your diagrams for errors. (Don't lose points you don't have to)  

NOTE:   All pages of your assignment must be stapled together