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 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
Get step-by-step solutions from verified subject matter experts
