Question: create table in Oracle live based on information given ...what should be type in Oracle to create new table for VISITORS QUESTION 1 Given the

 create table in Oracle live based on information given ...what should

be type in Oracle to create new table for VISITORS QUESTION 1

create table in Oracle live

based on information given ...what should be type in Oracle to create new table for VISITORS

QUESTION 1 Given the following 3NF relational schema regarding art exhibitions LOCATION (ICode, IName, IAddress) ARTIST(ald, aName, aCountry) EXHIBITION (eCode, eName) EXHIBITIONLOCDATE (eCode, ICode, eStartDate, eEndDate) ARTOBJECT (aolD, aoName, ao Type, alD) ARTEXHIBITED (eCode, ICode, aold, boothNo) INote: 1. Underlined attributes are primary/composite keys of the relations & italicized attributes are foreign keys. 2. 1 = location, a = artiste - exhibition 10 = artObject] +) Add a new table named VISITOR with at least 4 attributes to the art exhibitions database. State the primary key and suitable foreign key(s) that can logically link the new table to any of the existing tables. is to be submitted in Ulear before lab next week

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!