(5 points) Create the following table named VISITS in the LOST schema. Be certain that the...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
How much is the EPS growth for droneshield company (ASX: DRO) and how to calculate it?
-
1. What are common shares and preferred shares, and what are the key differences between the two? 2. What factors should investors consider when evaluating a company's shares for potential...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
What is data science, how does it differ from traditional statistics, explain data science process, including the key steps involve in it.
-
The man pulls on the rope with a force F. Determine the moment that this force exerts about the base of the pole at O. Solve the problem two ways, i.e., by using a position vector from O to A, then O...
-
The one-to-one function fis defined below. f(x)=x-5 1 Find f (x), where f is the inverse of f.
-
Search the Internet including social media to obtain information on flying and passengers' airline preferences. Develop three double-barreled questions related to flying and passengers' airline...
-
The questions in this exercise are based on the Benetton Group, a company headquartered in Italy and known in the United States primarily for one of its brands of fashion apparelUnited Colors of...
-
Takeaways for Case study analysis of Transferring Knowledge Between Projects at NASA JPL
-
Margie Company needs your help to record and summarize its accounting transactions for 2021 and to prepare its financial statements for that year. Margie Company provided you with the following...
-
What is the goods trade balance? (Numeric calculations required - Show your work) . What is the current account balance?(Numeric calculations required - Show your work) Does the financial account...
-
A \(2200 \mathrm{~kg}\) truck has put its front bumper against the rear bumper of a \(2400 \mathrm{~kg}\) SUV to give it a push. With the engine at full power and good tires on good pavement, the...
-
A velocity vector \(40^{\circ}\) above the positive \(x\)-axis has a \(y\)-component of \(10 \mathrm{~m} / \mathrm{s}\). What is the value of its \(x\)-component?
-
Normally, jet engines push air out the back of the engine, resulting in forward thrust, but commercial aircraft often have thrust reversers that can change the direction of the ejected air, sending...
-
A falcon is hovering above the ground, then suddenly pulls in its wings and begins to fall toward the ground. Air resistance is not negligible. Identify the forces on the falcon.
-
The earth's radius is \(6.37 \times 10^{6} \mathrm{~m}\); it rotates once every 24 hours. a. What is the earth's angular speed? b. Viewed from a point above the north pole, is the angular velocity...
-
A ball is thrown upward in the air, and its height above the ground after t seconds is H(t) = 89t 4.905 meters. a) Find the time t when the ball will be traveling upward at 22.25 meters per second....
-
Which one of the following anhydrous chloride is not obtained on direct heating of its hydrated chloride? (A) BaCl2 (B) CaClz (C) MgCl2 (D) SrCl2
-
What is a database?
-
Describe the purpose of the PROJECT command in relational algebra.
-
The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...
-
N = 230, n = 15, k = 200 Compute the mean and standard deviation of the hypergeometric random variable X.
-
N = 60, n = 8, k = 25 Compute the mean and standard deviation of the hypergeometric random variable X.
-
One study showed that in a certain year, airline fatalities occur at the rate of 0.011 deaths per 100 million miles. Find the probability that, during the next 100 million miles of flight, there will...
Study smarter with the SolutionInn App