Subject: Information Technology- Access Database

3.2 What is a data sublanguage?

3.4 Why is it important to learn SQL?

3.11 Write the required SQL statements to create the PET_2 table below. PET_2 (PetName, PetType, PetBreed, PetDOB, OwnerID)

3.12 Is PET or PET_2 a better design? Explain your rationale.

3.13 Write the SQL statements necessary to remove the PET_OWNER table from the database. Assume that the referential integrity constraint is to be removed. Do not run these commands in an actual database!

3.14 Write the SQL statements necessary to remove the PET_OWNER table from the database. Assume that the PET table also needs to be removed. Do not run these commands in an actual database!

3.15 Write an SQL statement to display all columns of all rows of PET. Do not use the asterisk (*) notation.

3.16 Write an SQL statement to display all columns of all rows of PET. Use the asterisk (*) notation.

3.17 Write an SQL statement to display the breed and type of all pets.

3.18 Write an SQL statement to display the breed, type, and DOB of all pets having the type Dog.

3.19 Write an SQL statement to display the PetBreed column of PET.

3.20 Write an SQL statement to display the PetBreed column of PET. Do not show duplicates.