(5 points) Create the following table named VISITS in the LOST schema. Be certain that the...

  

Transcribed Image Text:

(5 points) Create the following table named VISITS in the LOST schema. Be certain that the create command enforces the composite primary key constraint and both foreign key constraints. Column Loc Num Tour ID Data Type Loc Num 1 3 1 10-digit integers Visit Duration integer 3-digit integers 5 5 20 Tour ID Visit Duration 30 90 15 Constraints (5 points) Add the following rows to the VISITS table created above. PK, FK from Location PK, FK from Tour TOUR PK Tour ID Tour Name Tour Length Tour Fee PK FK1 FK2 HOPK,FK2 OUTING Out ID QUALIFY PK,FK1 Tour ID Out Date Out StartLoc Out_EndLoc LOST Tours Data Model Out MaxCapacity Tour ID G_EmpNum G EmpNum Qualify Date REGISTER Out ID Client Num PK,FK1 PK HOPK,FK2 Reg Date Reg_Fee GUIDE G EmpNum G_FName G_LName G_Phone $ 士 PK CLIENT Client Num Client FName Client_LName Client AreaCode Client Phone (5 points) Create the following table named VISITS in the LOST schema. Be certain that the create command enforces the composite primary key constraint and both foreign key constraints. Column Loc Num Tour ID Data Type Loc Num 1 3 1 10-digit integers Visit Duration integer 3-digit integers 5 5 20 Tour ID Visit Duration 30 90 15 Constraints (5 points) Add the following rows to the VISITS table created above. PK, FK from Location PK, FK from Tour TOUR PK Tour ID Tour Name Tour Length Tour Fee PK FK1 FK2 HOPK,FK2 OUTING Out ID QUALIFY PK,FK1 Tour ID Out Date Out StartLoc Out_EndLoc LOST Tours Data Model Out MaxCapacity Tour ID G_EmpNum G EmpNum Qualify Date REGISTER Out ID Client Num PK,FK1 PK HOPK,FK2 Reg Date Reg_Fee GUIDE G EmpNum G_FName G_LName G_Phone $ 士 PK CLIENT Client Num Client FName Client_LName Client AreaCode Client Phone

Answer rating: 100% (QA)

The first image depicts an assignment question where you are asked to create a table named VISITS within a database schema called LOST The table shoul... View the full answer