Question: 2. Consider a 'Owner-Pet' database with three tables - Owner, Pet and Owner-Pet shown as a below in Fig 3. Pk and FK Constraints are

 2. Consider a 'Owner-Pet' database with three tables - Owner, Pet

2. Consider a 'Owner-Pet' database with three tables - Owner, Pet and Owner-Pet shown as a below in Fig 3. Pk and FK Constraints are also shown. PET PK OWNER PK OWNERID OWNER NAME OWNER GENDER OWNER PET PK ID FK1 OWNER ID FK2 PET ID PET ID PET NAME PET TYPE Fig 3 Assume any data for the three tables and answer the below 1. Write SQL syntax for creating the three [3] tables giving necessary constraints (owner_id is auto_increment] 6 marks II. Write SQL syntax to alter the 'Owner' table whereby the owner_id starts with 1000 1 mark II. Write an SQL statement to insert any one record in table -'owner' table with your details. 1 mark IV. Write an SQL statement to alter the table Pet and Add a column 'pet_gender Change the type of the column 'pet_gender' from varchar(10) to Char(1) Remove the column 'pet_gender' 3 marks V. Write an SQL statement Add auto increment constraint to pet_id in the 'pet' table 1 mark VI. Write an SQL statement to remove any record from the pet table 1 mark VII. Write an SQL to rename the column 'Id' to 'Owner_pet_id' in the owner_pet table 1 mark (14 Marks)

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 Databases Questions!