Section 01: Consider the following database schema where primary keys are underlined. Tablel (A, B, C, D, E), Table2(D,
Posted: Fri Jul 08, 2022 6:43 am
- Section 01 Consider The Following Database Schema Where Primary Keys Are Underlined Tablel A B C D E Table2 D 1 (75.62 KiB) Viewed 45 times
Section 01: Consider the following database schema where primary keys are underlined. Tablel (A, B, C, D, E), Table2(D, X, L, F) Table3(X, P, Q) Table4(M, D, X, P,W) (i) (ii) Draw the schema diagram showing foreign key constraints. [5 points] Write a SQL query to create Table1 considering datatype varchar(20) for all attributes. [5points]