Traditional Database Systems - Database System - Exam, Exams of Database Management Systems (DBMS)

Download Traditional Database Systems - Database System - Exam and more Exams Database Management Systems (DBMS) in PDF only on Docsity! Ollscoil na hÉireann, Gaillimh GX_____ National University of Ireland, Galway Semester I Examinations 2008 / 2009 Exam Code(s) 3BF1 Exam(s) Third Year BSc in Business Information Systems Module Code(s) MS316 Module(s) Database Systems and Languages II Paper No. 1 Repeat Paper External Examiner(s) Prof. H. van der Heijden Internal Examiner(s) Prof. J. Collins Mr. M. Scott Instructions: Answer any THREE questions. All questions carry equal marks. Duration 2 hours No. of Pages 3 Department(s) Accountancy and Finance Course Co-ordinator(s) Mr Murray Scott 2 Q1. 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) Objects identity (OID) and attributes. (ii) Methods and messages. (iii) Classes, protocols, and 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. The World Wide Web has become tightly integrated with database systems. The merger of Web and database technologies is highly advantageous with regard to the development of robust, reliable, and profitable business Web sites, capable of providing customised services and products to customers. Describe current approaches and challenges to integrating databases and the World Wide Web. (33 marks) Q3. (a) A data warehouse is a type of contemporary database system designed to fulfil decision-support needs. The data warehouse requires extensions to conventional database technology and also a range of application tools for on-line analytical processing (OLAP) and data mining. Discuss the above statement describing OLAP systems, architecture, relational OLAP (ROLAP), and multidimensional OLAP (MOLAP). Use diagrams, where appropriate to support your answer. (18 Marks)