COMP 3380 Lecture Notes - Lecture 7: Candidate Key, First Normal Form, Functional Dependency

• School: University of Manitoba
• Department: Computer Science
• Course: COMP 3380
• Professor: Adam G.Pazdor

Document Summary

Instructors: dr. carson k. leung & adam pazdor. 04-07ex-1: consider two relations r (a, c) and s (b, c, d) with the following instances: What is the resulting relation t of a natural join on r and s (i. e. , t = r s): consider a relation r (a, b, c, d) has the following instance: 6: consider the following two relations: a relation r (a, b) containing nr unique tuples, and a relation s (a, b) containing ns unique tuples. Let nt represent the number of tuples in t = r s. [ ] nr=10, ns=15 and nt = 5: consider the following customer database, customers (cid, cname, age, gender, visits (cid, pizzeria, eats (cid, pizza, serves (pizzeria, pizza, price) Write a sql expression for each the above queries. -- end of optional exercise for units 04-07 --- Sample solution to optional exercise for units 04-07.