For following Relational Model, write SQL DDL commands for questions asked. i) ii) * FID fType

For following Relational Model, write SQL DDL commands for questions asked.

 

Transcribed Image Text:

← i) ii) * FID • fType fName iii) fRelease Date. fLength *fLanguage * fRating FILM PK (FID) ( iv) ← SS_FILM NUMBER (10) VARCHAR2 (100 CHAR) VARCHAR2 (40 CHAR) DATE NUMBER (4,2) VARCHAR2 (30 CHAR) VARCHAR2 (10) e PF PF SS FILM ACTOR * contractPay advancePay fID alD NUMBER (10,2) NUMBER (10,2) NUMBER (10) NUMBER (10) FILM_ACTOR_PK (fID, alD) FILM ACTOR_FILM_FK (FID) FILM_ACTOR_ACTOR_FK (aID) PalD SS_ACTOR NUMBER (10) VARCHAR2 (30) VARCHAR2 (30) CHAR (1) fName *fLname *aGender ACTOR_PK (aID) SS_ACTOR TALENT NUMBER (10) PF alD NUMBER (10) PF TID To create primary ke of SS_ACTOR_TALENT table. < ( ACTOR_TALENT_PK (tID, alD) ACTOR TALENT_ACTOR_FK (aID) ACTOR TALENT TALENT_FK (tID) PtID *tName SS TALENT tDescription TALENT PK (tID) www To add a constraint to enforce that column fID in SS_FILM table has minimum 6 digits ← NUMBER (10) VARCHAR2 (50) VARCHAR2 (100) To allow "F" or "M" or" U" as only possible value for aGender column of SS_ACTOR table< To create foreign keys for SS_FILM_ACTOR table ← i) ii) * FID • fType fName iii) fRelease Date. fLength *fLanguage * fRating FILM PK (FID) ( iv) ← SS_FILM NUMBER (10) VARCHAR2 (100 CHAR) VARCHAR2 (40 CHAR) DATE NUMBER (4,2) VARCHAR2 (30 CHAR) VARCHAR2 (10) e PF PF SS FILM ACTOR * contractPay advancePay fID alD NUMBER (10,2) NUMBER (10,2) NUMBER (10) NUMBER (10) FILM_ACTOR_PK (fID, alD) FILM ACTOR_FILM_FK (FID) FILM_ACTOR_ACTOR_FK (aID) PalD SS_ACTOR NUMBER (10) VARCHAR2 (30) VARCHAR2 (30) CHAR (1) fName *fLname *aGender ACTOR_PK (aID) SS_ACTOR TALENT NUMBER (10) PF alD NUMBER (10) PF TID To create primary ke of SS_ACTOR_TALENT table. < ( ACTOR_TALENT_PK (tID, alD) ACTOR TALENT_ACTOR_FK (aID) ACTOR TALENT TALENT_FK (tID) PtID *tName SS TALENT tDescription TALENT PK (tID) www To add a constraint to enforce that column fID in SS_FILM table has minimum 6 digits ← NUMBER (10) VARCHAR2 (50) VARCHAR2 (100) To allow "F" or "M" or" U" as only possible value for aGender column of SS_ACTOR table< To create foreign keys for SS_FILM_ACTOR table

Answer rating: 100% (QA)

Sure lets address each of the SQL DDL commands based on the requirements you provided i To create the primary key for the SSACTORTALENT table we would ... View the full answer