Use sample data to populate the fields for three records.
What will be an ideal response?
Note: The solutions for Tasks 3 and 4 have been combined. The first part of the solution shows the table design and keys that were created in Task 3. The second part of the solution shows the sample data.
ROUTE DATA (ROUTE NUMBER, ORIGIN, DESTINATION, DEPART TIME, ARRIVE TIME)
• Candidate keys: Route Number is the only candidate key. No other field will identify flights uniquely.
• Primary key: Route Number is the primary key.
• Foreign key: This record requires no foreign key.
• Secondary keys: Potential secondary keys include ORIGIN, DESTINATION, DEPART TIME, and ARRIVE TIME. Scenic Routes might want to access or display data on the basis of any of these fields, or a combination of them.Using this design, sample data for three ROUTE DATA records might look like this:
You might also like to view...
The _______ scanner component creates light to reflect off the document
Fill in the blank(s) with correct word
The word shown in bold is spelled correctly in the following sentence.The roofs were covered with snow.?
Answer the following statement true (T) or false (F)
Click item D in the figure above to see more suffix options.
Answer the following statement true (T) or false (F)
Which Amazon service can I use to define a virtual network that closely resembles a traditional data center?
A. Amazon VPC B. Amazon ServiceBus C. Amazon EMR D. Amazon RDS