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:



Computer Science & Information Technology

You might also like to view...

The _______ scanner component creates light to reflect off the document

Fill in the blank(s) with correct word

Computer Science & Information Technology

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)

Computer Science & Information Technology

Click item D in the figure above to see more suffix options.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

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

Computer Science & Information Technology