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

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

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. OWNER_PET PK ID FK1| OWNER_ID FK2 PET ID OWNER PET PK OWNER PK PET ID OWNER NAME PET NAME OWNER GENDER 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 I. Write SQL syntax to alter the 'Owner' table whereby the owner_id starts with 1000 1 mark Write an SQL statement to insert any one record in table - 'owner' table with your details. II. 1 mark

Step by Step Solution

3.50 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The following SQL statements have been executed in MySQL 55 Solutions for the first Questi... View full answer

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 Computer Engineering Questions!