Database concepts

1. How many records does the file contain? Click here to enter text. How many fields are there per record?

Click here to enter text.

2. What problem would you encounter if you wanted to produce a listing by city?

Click here to enter text.

3. What data redundancies do you detect?

Click here to enter text.

4. If PROJECT_CODE 25-2D is canceled and removed from the table, what unintended consequence will occur?

Click here to enter text.

5. List all the names of the entities in this database and their associated attributes. Click here to enter text.

6. For each table in Figure 2, identify its keys and explain the reason for your identification in the spaces provided below. If a table does not have a particular key, write “None” and explain.

EMPLOYEE TABLE

Primary key: Click here to enter text.

Foreign key: Click here to enter text.

STORE TABLE

Primary key: Click here to enter text.

Foreign key: Click here to enter text. Composite key: Click here to enter text.

REGION TABLE

Primary key: Click here to enter text.

Foreign key: Click here to enter text. Composite key: Click here to enter text.

8. Do the tables exhibit referential integrity? Answer yes or no in the chart below, and then explain your answer. Write “N/A” (Not Applicable) if the table does not have a foreign key.