CS338 Lecture 1: CS338F16-Exercise5

• School: University of Waterloo
• Department: Computer Science
• Course: CS338
• Professor: Michael Liu

Document Summary

These exercises are collected and graded but they are essential in learning the material and preparing for exams. Solutions will be posted later and some of questions will be discussed in class: below is an er diagram for a database that may be used to keep track of transport ships and their locations for maritime authorities. Map this schema into a relational schema, and specify all primary keys and foreign keys. 1: consider the following information about a university database: Professors have an ssn, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name, a starting date, an ending date, and a budget. Graduate students have an ssn, a name, an age, and a degree program (e. g. , m. s. or ph. d. ). Each project is managed by one professor (known as the project"s principal investigator). Each project is worked on by one or more professors (known as the project"s co-investigators).