CSE 344 Final: CSE 344 UW Final Exam Solution 12 Fall
Document Summary
1 e/r diagrams, constraints, conceptual design: (30 points) (a) (10 points) for each e/r diagram, indicate if the create table statement that follows the diagram is consistent with the diagram or not. If it is not consistent, make the necessary changes. Only make changes that are necessary. a2 a3 b c2 a1 c1. Create table a (a1 int primary key, a2 int, int, c1 int not null references c) p1 p2. Create table c (p1 int primary key, c1 int) Create table g (h1 int references h, k1 int references k, l1 int references l, g1 int, Create table o (o1 int, m1 int references m, Answer (corrections, if any, to the above create table statements): Create table a (a1 int primary key, a2 int, a3 int, int, c1 references c) Create table c (p1 int primary key references p, c1 int)
