=========================preview======================
(COMP231)comp231_pp2006.pdf
Back to COMP231 Login to download
======================================================

HONG KONG UNIVERSITY OF SCIENCE & TECHNOLOGY
COMP231: Database Management Systems
Spring Semester, 2006
Final Examination
May 27, 2006 4:30 C 7:30 p.m.

Name: ___________________ Student Number: ______________________

Email: ___________________ Lab Section Number:____________________

















Questions
Marks
Scores

1
10


2
16


3
12


4
16


5
14


6
16


7
16


Total
100








Instructions:



1. This examination paper consists of 20 pages and 7 questions

2. Please write your name, student ID and Email on this page.

3. For each subsequent page, please write your student ID at the top of the page in the space provided.

4. Please answer all the questions within the space provided on the examination paper. You may use the back of the pages for your rough work and afterwards drawn a diagonal line through it to show that it is not part of your answer.

5. Please read each question very carefully and answer the question clearly and to the point. Make sure that your answers are neatly written, readable and legible.

6. Leave all pages stapled together.

7. The examination period will last for 3 hours.
8. Stop writing immediately when the time is up.

Question 1 General Database Knowledge. (10 marks)

(a) (3 marks) Explain the benefits of having logical data independence and physical data independence in the context of Database Management Systems (DBMSs). You may refer to the following diagram whenever necessary.


























(b) (3 marks) Discuss the three special roles of a Database Administrator (DBA) which are different from casual users in managing a DBMS.
























(c) (2 marks) Assume a student develops a system using JAVA J2SE5.0 and he/she wants to connect the system with a remote Oracle DBMS using JDBC. Given the following information about the students Oracle account:



Oracle Login: comp231stu999
Password: apple
URL of Oracle DBMS:
jdbc:oracle:thin:@dbsvr2.cs.ust.hk:1521:comp231

Assume the database driver is already loaded, write ONE java statement to make a connection to the Oracle DBMS.
















(d) (2 marks) Give one benefit and one limitation of BCNF when compared to 3NF in database normalization.


















Question 2 Database Design (16 marks)

(a) (4 marks) Give one real-life example with brief explanation of the following concepts used in Entity Relationship Diagrams (ERDs). You are required to use a simple ERD to illustrate your examples.


(i) (2 marks) Recursive relationship.
















(ii) (2 marks) Ternary relations