Section 01: Consider the following database schema where primary keys are underlined. Tablel (A, B, C, D, E), Table2(D,
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Section 01: Consider the following database schema where primary keys are underlined. Tablel (A, B, C, D, E), Table2(D,
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]