Question
An HR department of a small office maintains data of all the employees. In addition to Employee's detail, his/her dependent and their cars' data is
An HR department of a small office maintains data of all the employees. In addition to Employee's detail, his/her dependent and their cars' data is also stored. After carefully observing the given ERD, write answer to the following questions. Note: The primary key for each table is intentionally not mentioned except for Employee.
[Q1: The primary key Employee ID is used as Foreign Key in which table(s)? Moreover, What this connection known as? Q2: A car can have only one owner; how this rule can be implemented? Q3:An Employee can own a car, suppose an employee Mr. Ahmed sells his car to another employee Mr. Babar; can we store this new ownership of car information while maintaining old ownership information, in this model, if not then suggest any changes Q4:Write SQL query to get list of all those cars, which were in ownership of any employee, and now they are in ownership of another employee.
answer these queston picture attached is erd reply ASAP ASSAP
0.. * Employee Manages Has 1..1 0..1 Car Employeeld {PK} FirstName 1..1 lastName Salary 1..1 Has 0..* Registration No Make Model MadelYear Dependent FirstName LastName RelationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started