Question: A person has id , name ( first name, middle name, last name ) , addresses ( present address, permanent address etc. ) more than

A person has id, name (first name, middle name, last name), addresses (present address, permanent address etc. ) more than one mobile numbers, income. A person may be employee, business man, farmer, unemployed, senior citizens or others. Employees may be government or private. Government employee has ministry and private employee has company. Each employee must have basic salary and educational qualification. A business man must have type of business. A farmer must have land size, location. An unemployed person must have previous employment status, qualification and age. A senior citizen shall have a seniority position and honorarium. Others have type and priority.
Task-1 Design and implement the following using relational model
Task-2 Design and implement the following using object-relational model
Task-3 Write insert statement to insert 3 Sample tuples in each relation
Task-4 Write insert statement to insert 3 Sample tuples in each relation object
Task-5 Compare the two models

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