Objective:

The main objective of this assignment is to create advanced RDBMS objects and use database storage effectively.

Background
You are required to choose a company of your choice that has with database application implemented in it. Interview with IT Manager or someone from IT department. Investigate the nature of database applications employed at the company. Also try to capture any business rules that are currently practiced. Based on your findings, analyze and document the scenario using object-oriented database design methodology.

Represent the scenario investigated using standard object-oriented design methodology with the help of a neat diagram, using standard notations. Please note that the study must involve a minimum of five objects using the concept of inheritance.

Demonstrate the use of creating objects for the scenario considered. Your answer must demonstrate creation of at least two objects and use REF.

Demonstrate how you can implement inheritance with the help of an example for the scenario considered above.

For any one of the business rule captured and documented, write a trigger code to implement this business rule. Support your answer with appropriate code and explanation.

Why does database storage structure contain many logical structures (Block, Extent, Segments, etc) to store data? Discuss how these structures make database storage efficient.

Viva, covering lectures 1 through 6 and assignment problems and class activities.

لو يكون الكلام عربي احسن يفهموه  الكل