CS348 Study Guide - X.400, Subset, Arnold Tongue

• School: University of Waterloo
• Department: Computer Science
• Course: CS348
• Professor: Ahmed A Ataullah

Document Summary

For the scenario described herein, write sql ddl statements (create table etc. ) to create the data model and constraints that best capture the situation. Vin int not null foreign key references car(vin), License int not null foreign key references person(license), Create assertion ten_cars_max check ( not exists (select license from own group by license having count(*)>10) ) Create assertion one_owner_max check ( not exists (select vin from own group by vin having count(*)>1) ) Let r be arelational schema with attributes {x, q, z, l, t, u} and let f be the set of functional dependencies f = {x q, x z, zl t, zl u, q t}: what is the attribute closure of xl. X q, x is in closure, q is not so add q. X z, x is in closure, z is not so add z. Zl t, zl is in closure, t is not so add t.