CS338 Lecture Notes - Lecture 1: Relational Algebra

135 views2 pages

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. Consider the following database scheme for supplier and parts database: Supplier(s#, sname, city) // store supplier number, name and location. Part(p#, pname, colour, weight, city) // store part number, name, color, weight and available location. Sp(s#, p#, qty) // store supplier number, part(s) that he supplies and quantity available. To help you understand a bit more about these tables, we include some sample data on the back. That is, who are located in london and provide parts in. London: find suppliers who are located in toronto and provides blue screws in montreal, find suppliers who provide the same part in multiple cities, find parts that are exclusive, that is, offered by only one supplier.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents