The Final Exam Review
Document Summary
Part 2: database conceptual design, erd, chen notation ( case study, midterm ) Part 3: logical design, assignment number one, erd given and create table needed ( case study, assignment number1, midterm . ) Part 4: sql queries, assignment number 2, not goanna be sophisticated. Client -> client id, name, postal code, region, risk level of the region. Insured items -> item id, title, current cost. We have four dimensions and one measure. Dimension, policy is already bcnf because it has 2 field. Any table with 2 field is always in. Dimension, item, is in bcnf as well since there is no functional dependency. Pcode -> region | region -> risk, region is non-prime attribute in client. Make a table: region | risk, region will be primary and risk dependent. Since in client pcode and region are non-prime then we make.
