CS338 Lecture Notes - Lecture 1: Sqlite, Foreign Key
30 Nov 2017
School
Department
Course
Professor
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. All the exercises are based on the company database whose schema and sample data are listed in the last two pages. Write sql expressions to answer the following questions. To verify your answers, you could download the given company. db from d2l. You only need to open it in sqlite. No execution is required you can then test your answers: create the following customer table. It records the customers for some external projects. That is, the customer pays the company do the project. Use your own judgment to determine the proper domain for each attribute. It is linked to the project table via the pno foreign key. If the project information is updated in the project table, the change should be reflected in the customer table.
