Course: CSI 2132B - Databases IAcademic year: 2019/2020Semester: WinterInstructor: Olubisi Runsewe______________________________________________________________________________Please read the following instructions carefully:This exam contains 3 different parts (Part I, Part II and Part III). In each part you have 4 questionsavailable. You must select and provide the answers to exactly two questio
Course: CSI 2132B - Databases I
Academic year: 2019/2020
Instructor: Olubisi Runsewe
Please read the following instructions carefully:
This exam contains 3 different parts (Part I, Part II and Part III). In each part you have 4 questions
available. You must select and provide the answers to exactly two questions in each part. If you
provide answers for more than two questions in any part of the exam, only the first two questions
answered will be considered. The total number of questions to be answered is 6, with 2 mandatory
questions in each part.
1. (10%) A worldwide package delivery company named WorldDelivery wants to store information
in a database. The database must be able to keep track of:
Customers who ship items and customers who receive items; some customers may do
both. The customer ID, name and address must be stored.
Each package must be identifiable and trackable, so the database must be able to store
the location of the package and its history of locations. The package weight must also be
Locations include trucks, planes, airports, and warehouses. For each location the
database should store the corresponding ID, city, country and address.
Draw an ER diagram for the database described