Question: This is an INFORMATIONN SYSTEM questions. Please use this chart to answer question 1-4 thanks! Consider the following relational schema created in Access. Assignment Contract

This is an INFORMATIONN SYSTEM questions.
Please use this chart to answer question 1-4 thanks! This is an INFORMATIONN SYSTEM questions. Please
This is an INFORMATIONN SYSTEM questions. Please
Consider the following relational schema created in Access. Assignment Contract ID Consultant ID Contract Contract ID Client Amount Contract Date Requires Expertise Contract ID Expertise Code 1818 Consultant Consultant ID Region ID Consultant First Nan Consultant Last Nam Expertise Expertise Code Expertise Description -181 Client Client ID Region ID Client First Name Client Last Name Has Expertise Consultant ID 9 Expertise Code Region y Region ID Region Name 6:42 PM Mon Apr 19 79% > o Notes 1. Which of the following statements is FALSE? A. There are eight tables in the database above. B. Primary key of the table Region is used twice as a foreign key in the database above. C. Table Consultant has four columns D. Table Contract has two foreign keys. E. Table Has_Expertise has two foreign keys 2. What is the primary key of the table Has_Expertise? A. Expertise Code B. Region ID C. Consultant ID D. Expertise Code and Consultant ID combined E. None of the above 3. How many foreign keys does the table Region have? A4 B. 3 C.2 D. 1 E.O 4. Which of these 3 tables: Consultant, Has_Expertise, Assignment, must have records entered into it first? A. Consultant B. Has_Expertise C. Assignment D. Either Has_Expertise or Assignment E. Any one of them. The order of entry is unimportant

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!