Scribd
Upload
49 views3 pages

Employee Id Name Address Hire - Date Getexperience Getid Displayempdetail Insert - Employee Delete - Employee

The document provides instructions to implement object-relational diagrams by creating tables from object classes and inserting data. It includes 5 sections where students are asked to: 1) Implement an employee object diagram and test it in PL/SQL. 2) Create tables from an asset management diagram and insert data. 3) Create more tables from an object diagram and insert data. 4) Model employee data for a travel agency using inheritance and insert data. 5) Create tables from a student-subject-supervisor diagram and insert data.

Uploaded by

rahul
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
49 views3 pages

Employee Id Name Address Hire - Date Getexperience Getid Displayempdetail Insert - Employee Delete - Employee

The document provides instructions to implement object-relational diagrams by creating tables from object classes and inserting data. It includes 5 sections where students are asked to: 1) Implement an employee object diagram and test it in PL/SQL. 2) Create tables from an asset management diagram and insert data. 3) Create more tables from an object diagram and insert data. 4) Model employee data for a travel agency using inheritance and insert data. 5) Create tables from a student-subject-supervisor diagram and insert data.

Uploaded by

rahul
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Lab Cycle III (Object-Relational Database)

Screen shots are mandatory

1. Implement the following object diagram and test the implementation in a PL/SQL block.

EMPLOYEE

Id

Name

Address

Hire_date

getExperience( )
getId( )
displayEmpDetail()
insert_employee
delete_employee

2. Implement the following object oriented diagram relating to assets in a computer laboratory. Execute
insert statements for entering data into the tables so created.

3. Implement the following object oriented diagram relating to assets in a computer laboratory. Execute
insert statements for entering data into the tables so created.

1
4. Giant Travel is a well-known travel agency that operates guided tours. With offices around the world,
they maintain accurate and detailed employee data. The employee data are kept in an object
Employee_T and can be divided into two child objects: Guide_T and Admin_T. An employee can be
categorized as a guide or an administration staff, but he or she can also be both. This is important
because in the peak season, an administration worker might be needed to guide the tours and vice
versa. The objects and the attributes are shown below.

Implement the following object oriented diagram relating to assets in a computer laboratory. Execute
insert statements for entering data into the tables so created.

2
5. The following figure shows the relationship among objects Supervisor_T, Student_T, and Subject_T in
a university. A student can take many subjects, and a subject can be taken by many students. For every
subject a student takes, there is a mark given. In another relationship, a student can be supervised by
only one supervisor, but a supervisor can supervise many students. Assume that objects have been
created and the tables from these objects are shown.

Implement the following object oriented diagram relating to assets in a computer laboratory. Execute
insert statement for entering data into the tables so created.

You might also like