A person has NID, name, street, city, thana, district and age. A person may be an employee with special attributes as salary and qualification (highest degree). An employee may be government or private. For government employees, special attributes are ministry and designation. For non-government employees, special attributes are company name and position. 1. A national team is formed with the attributes of id, team leader, game, organizing country, and date. The attribute team leader is a reference type that refers to a person. You have to define NID as a reference. 2. Define types and inheritance 3. Create a table for each type with table inheritance using PostgreSQL and Oracle formats and insert two tuples in each table. 4. Define reference type for the national team and appoint Abdullah with NID 1234567890 as a team leader using system-generated reference. Insert two tuples in national team relation. 5. Write path expression query to Find NID and name of all employees with sal
Q. A person has NID, name, street, city, thana, district and age. A person may be an employee with special attributes as salary and qualification (highest degree). An employee may be government or private. For government employees, special attributes are ministry and designation. For non-government employees, special attributes are company name and position.
1. A national team is formed with the attributes of id, team leader, game, organizing country, and date. The attribute team leader is a reference type that refers to a person. You have to define NID as a reference.
2. Define types and inheritance
3. Create a table for each type with table inheritance using PostgreSQL and Oracle formats and insert two tuples in each table.
4. Define reference type for the national team and appoint Abdullah with NID 1234567890 as a team leader using system-generated reference. Insert two tuples in national team relation.
5. Write path expression query to Find NID and name of all employees with salary >50000.
6. Find name, street and city of the team leader with id = ‘T005’
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
