Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Generalisation, Multiple Inheritance, Traditional Database Systems, Computational Characteristics, Development of Information Systems, Commercial Enterprises, Various Approaches, Web and Databases, Merits and Shortcomings, Spatial and Temporal Data are pints from Advanced Database Technologies course exam paper.
Typology: Exams
1 / 4
This page cannot be seen from the preview
Don't miss anything!
Exam Code(s) 3 BF Exam(s) (^) Third Year BSc in Business Information Systems Module Code(s) MS 322 Module(s) Advanced Database Technologies Paper No. Repeat Paper External Examiner(s) Dr. Danail Ivanov Internal Examiner(s) Dr. T. Acton Mr. Seamus Hill Instructions: (^) Answer any THREE questions. All questions carry equal marks. Duration 2 hrs Department(s) Accountancy & Finance Course Co-ordinator(s) Requirements : MCQ No
a) Object-oriented database management systems (OODBMS) integrate the benefits of traditional database systems with the modelling and computational characteristics of an object-oriented data model. Describe the following concepts in the context of OODBMSs: i. Generalisation. ii. Specialisations. iii. Multiple Inheritance. iv. Polymorphism. (20 Marks) b) Object-oriented database management systems (OODBMS) offer many benefits both to the development of Information Systems and also to the efficient running of commercial enterprises. Discuss this statement and give an assessment of the current level of adoption of object-oriented databases. (13 Marks) Q2. a) Discuss the various approaches of integrating the Web and Databases outlining the merits and shortcomings of each. Use diagrams where appropriate. (17 Marks) b) “Databases are being designed to cater for spatial and temporal data.” Prepare a report outlining i) What is spatial and temporal data ii) Examples of where they are used iii) Why they are becoming increasingly important to business iv) How databases can cater for spatial and temporal data
a) Data administration is the term applied to the task of managing organisational memory. Identify the main components relevant in managing the database environment and discuss what challenges organisations face in data management. You should consider issues such as performance monitoring and data integration in your answer. (18 Marks) b) There are two levels of data administration that can be identified in organisations: Project and System-Level. Describe in detail what function and responsibility each level provides to the organisation, and what roles are commonly associated with each level.
