A binary relationship with 1:1 cardinality
ratio, an employee can have one

1. Create necessary tables with constraint and necessary field

2. Insert values to tables

3. Show values

4. Find the id and the type of car assigned to employee ‘123’

5. Find the name of the employee and the make(type) of the car, if she/he drives car 987. Where 987 is the id of a particular car.

**car**and a car is used by one**employee**only. Do the following action as per your DBMS concepts1. Create necessary tables with constraint and necessary field

2. Insert values to tables

3. Show values

4. Find the id and the type of car assigned to employee ‘123’

5. Find the name of the employee and the make(type) of the car, if she/he drives car 987. Where 987 is the id of a particular car.