Question 1:
Illustrate out the term Class and Object which is employed in the Object Oriented concept.
Question 2:
Discuss and illustrate the following object-oriented concepts and exemplify your answer with one database illustration for each concept:
i) Abstraction
ii) Encapsulation
iii) Inheritance
iv) Polymorphism.
Question 3:
ODBMSs have been developed due to the inadequacies of existing database technology.
i) Provide three (3) of the inadequacies manifested in relational databases.
ii) Provide two (2) of the models of an advanced database application and discuss and describe four (4) features why these application’s requirements can’t be met by an existing relational model.
Question 4:
Discuss and illustrate three (3) strengths of ODBMSs.
Question 5:
There are three (3) basic components in data warehouse system namely, the acquisition component, the storage component and access component. There’re dissimilar steps involved in Acquisition component. One of the steps involves the preparation of data set for the inclusion in the new environment which comprises the following processes: cleansing, standardizing, formatting, matching and reconciling, purging, merging and establishing referential integrity. Describe the meaning of each of process in details.