Onur Çakmak 1444850
Production and Service Information Systems, Spring 2011
Assignment 2

Question 1)
Franchise{ Franchise tax ID, Name ,Address ,Contact Phone Number ,Name of Contact}
Contract {Contract ID , Franchisee tax ID ,Start Date, End Date, Monthly Payment, }
Franchise tax ID is a foreign key to Franchise;
Restaurant {Restaurant ID , Contract ID ,Address ,Date Opened ,Date of Last Inspection ,Seating Capacity }
Restaurant
Contract
Franchise
Contract ID is a foreign key to Restaurant
E-R Diagram 1 M 1 M

Question 2)
Staff of tutors {Employee ID ,Hourly Rate ,F. Name ,L. Name ,Middle Name ,Address ,Phone Number ,Mobile Phone Number ,E-Mail Address}
Students { Student ID ,Date of Birth ,Graduation Date ,Hourly Rate ,F. Name ,L. Name ,Middle Name ,Address ,Phone Number ,Mobile Phone Number ,E-Mail Address}
Sessions {Session ID , Start Time ,End Time ,Employee ID ,Student ID , }
Employee ID is a foreign key to Staff of tutors
Student ID is a foreign key to Students
E-R Diagram
Sessions
Students
Staff of tutors 1 M

1 M

Question 3)
Instrument { Serial Number ID ,Type of Instrument ,Age ,Manufacturer ,Model Name,Date Manufactured ,Notes }
Children {Children ID ,F. Name ,L. Name ,Middle Name ,Date of Birth ,Gender ,Address ,Phone Number }
Loans { Loan ID, Start Time ,End Time ,Serial Number ID, Children ID}
Employee ID is a foreign key to Staff of tutors
Student ID is a foreign key to Students

E-R Diagram
Loans
Children
Instrument
1 M

1 M

Question 4)
Customer{Customer ID ,F. Name ,L. Name , Phone Number ,Address}
Instrument {Instrument ID , Customer ID ,Maker ,Model ,Color ,Year Made ,Comments}
Customer ID is a foreign key to Customer
Repair Jobs { Repair Jobs ID ,Instrument ID ,Description of Work , Hours spent , Dollars charged , Date Dropped , Date started , Date Completed , Description of Work Done , Date Picked up}
Instrument ID is a foreign key to Instrument

E-R Diagram

Repair Jobs
Instrument
Customer 1 M 1 M