CS338 Lecture Notes - Lecture 1: Relational Algebra
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.