Use the Project database.

Copy code and output for each of the following.

Using the Properties table:

1. How many properties does the table contain? (use PropertiesListed as the alias)

2. How many properties are sold? (use PropertiesSold as the alias)

3. How many properties are available? (use PropertiesAvailable as the alias)

4. Select the first five records from properties.

5. Select all records from the subdivision table.

6. What is the apparent relation between SubDivisionID in the above two tables (Properties and Subdivision)?

Primary Key is in which table?

Foreign Key is in which table?

Should referential integrity be enforced (yes or no)?

7. Write a query to test to see if referential integrity was enforced.

Was referential integrity enforced?

List all of the homes that violate the referential integrity constraint.

8. Write a query to see if there are any inconsistent values in the Properties table for the county field.