Computer Science > EXAM > CSI 2132B - Databases I 2020 (All)

CSI 2132B - Databases I 2020

Document Content and Description Below

Course: CSI 2132B - Databases I Academic year: 2019/2020 Semester: Winter Instructor: Olubisi Runsewe ______________________________________________________________________________ Please read th ... e 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. Part I 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 stored.  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 [Show More]

Last updated: 3 years ago

Preview 1 out of 7 pages

Buy Now

Instant download

We Accept: