Describe DBLC (Database Life Cycle) and its phases.
Describe concurrency in a DBMS and how it is managed.
For the following tables write the required SQL statements:
- Write an SQL statement to create the PET table.
- Write an SQL statement to show the breed and type of all pets.
- Write an SQL statement to display the breed, type, and DOB of all pets having the type Dog.
- Write an SQL statement to show the pet owner's first name, last name, and pet name. Hint: you need to link PET_OWNER and PET tables.
Sample Solution