Question: Question 2 (1 mark) Which of the SQL schemas below gives the most accurate and space efficient translation of the following ER diagram: S R

Question 2 (1 mark) Which of the SQL schemas below gives the most accurate and space efficient translation of the following ER diagram: S R T H-0. b Assume that all attributes are of type integer. (a) create table S (a integer primary key, b integer, R integer not null references Tc)); create table (c integer primary key, d integer, R integer references S(a)); (b) create table S ( a integer primary key, b integer); create table T (c integer primary key, d integer, R integer references S(a)); create table S ( a integer primary key, b integer, R integer not null references TC)); create table T (c integer primary key, d integer); create table S ( a integer primary key, b integer); create table (c integer primary key, d integer, R integer references S(a); create table R (s integer not null references S(a), t integer references T(c), primary key (s, t)); None of the above is accurate and space efficient
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
