Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, lAddress) ARTIST(alD, aName, aCountry)...

Transcribed Image Text:

Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, lAddress) ARTIST(alD, aName, aCountry) EXHIBITION (eCode, eName) EXHIBITIONLOCDATE (eCode, ICode, eStartDate, eEndDate) ARTOBJECT (aolD, aoName, aoType, alD) ARTEXHIBITED (eCode, ICode, gold, boothNo) [Note Underlined attributes are primary/composite keys of the relations & talicized attributes are foreign keys 2.1 location, a artist, e-exhibition, ao artObject] 1) CREATE TABLE: (NOTE: Keep copy of code in notepad as well for c&p later on) • LOCATION • ARTIST EXHIBITION EXHIBITIONLOCATE •ARTOBJECT • ARTEXHIBITED 2) DROPTABLE: . LOCATION . ARTIST EXHIBITION EXHIBITIONLOCIATE • ARTOBJECT ARTEXHIBITED 3) ALTER ANY TABLE ADD • MODIFY DROP 4) ADD PRIMARY KEY CONSTRAINT . LOCATION . ARTIST • EXHIBITIONLOCIATE EXHIBITION ARTOBJECT • ARTEXHIBITED 5) ADD FOREIGN KEY CONSTRAINT (where applicable): Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, lAddress) ARTIST(alD, aName, aCountry) EXHIBITION (eCode, eName) EXHIBITIONLOCDATE (eCode, ICode, eStartDate, eEndDate) ARTOBJECT (aolD, aoName, aoType, alD) ARTEXHIBITED (eCode, ICode, gold, boothNo) [Note Underlined attributes are primary/composite keys of the relations & talicized attributes are foreign keys 2.1 location, a artist, e-exhibition, ao artObject] 1) CREATE TABLE: (NOTE: Keep copy of code in notepad as well for c&p later on) • LOCATION • ARTIST EXHIBITION EXHIBITIONLOCATE •ARTOBJECT • ARTEXHIBITED 2) DROPTABLE: . LOCATION . ARTIST EXHIBITION EXHIBITIONLOCIATE • ARTOBJECT ARTEXHIBITED 3) ALTER ANY TABLE ADD • MODIFY DROP 4) ADD PRIMARY KEY CONSTRAINT . LOCATION . ARTIST • EXHIBITIONLOCIATE EXHIBITION ARTOBJECT • ARTEXHIBITED 5) ADD FOREIGN KEY CONSTRAINT (where applicable):

Answer rating: 100% (QA)

SQL statements for creating tables dropping tables altering tables adding primar... View the full answer