Get premium membership and access revision papers, questions with answers as well as video lessons.
Database System Principles Question Paper
Database System Principles
Course:Bachelor Of Science In Information Technology
Institution: Kca University question papers
Exam Year:2009
UNIVERSITY EXAMINATIONS: 2008/2009
FIRST YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 1207: DATABASE SYSTEM PRINCIPLES
DATE: AUGUST 2009 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE (30 MARKS)
a) Distinguish between the following types of relational keys;
i) Primary key (2Marks)
ii) Candidate key (2Marks)
iii) Super key (2Marks)
b) i) Discuss the limitations of using a database system to store organizational data (5Marks)
ii) Describe the ways in which information in a database can be manipulated (3Marks)
c) i) Highlight the importance of testing during database development (2Marks)
ii) Given the entities Book, Item, Member and Borrowing, identify potential entities for these
entities and construct a conceptual E-R diagram. Underline relation keys (8Marks)
d) Briefly describe the roles of the following people;
i) Database designer (2Marks)
ii) Database administrator (2Marks)
iii) Database user (2Marks)
QUESTION TWO (20 MARKS)
a) i) Define the term ‘SQL’ (2Marks)
ii) Distinguish between DML and DDL (4Marks)
iii) By use of an appropriate diagram, discuss the 3-level database architecture (6Marks)
2
b) Examine the following table and answer the following questions;
STUDENT
REGNO NAMES AGE ADDRESS
SC02-0111/07 Hilda Omondi 18 Box 7 Kisumu
SC02-0112/07 Rachel Kamau 21 Box 34 Nairobi
SC02-0113/07 Barrack Papai 19 Box 5768 Kakamega
i). Write an SQL data definition statement which when executed would result in the relation shown
above. Indicate any primary key(s), field types and sizes (4Marks)
ii) Write a DML statement to add the second tuple of the above relation (2Marks)
iii) Write a DML statement that lists all the names of students in an ascending order (2Marks)
QUESTION THREE (20 MARKS)
a) Explain the meaning of the following terms;
i) Entity (2Marks)
ii) Attribute (2Marks)
iii) Relationship (2Marks)
b) With appropriate illustration, describe any three types of data models (6Marks)
c) Design an entity relationship diagram depicting the following entity sets. Include and
underline any primary or foreign keys;
STUDENT (name, date of birth, address, telephone number)
COURSE (name, capacity, fees, duration)
REGISTRATION (date) (8Marks)
QUESTION FOUR (20 MARKS)
a) i) Describe the basic components of database management system (8Marks)
ii) Identify any two DBMS applications you know (2Marks)
b) State the difference between the following concepts;
i) Database and database management system (2Marks)
ii) Database schema and database instance (2Marks)
c) i) Define the term ‘data security’ as used in database systems (2Marks)
3
ii) Discuss the ways in which security can be implemented in a database (4Marks)
QUESTION FIVE (20 MARKS)
a) i) Explain the term ‘foreign key’ as used in the relational database and discuss its
importance in relational database design (3Marks)
ii) Define the following terms as applied in the relational model
- Referential Integrity (2Marks)
- Cascade update (2Marks)
- Cascade delete (2Marks)
b) i) Identify the anomalies that might be experienced due to bad database design (3Marks)
ii) Define the term ‘normalization’ (2Marks)
iii) Identify three benefits of having a distributed database system (6Marks)
More Question Papers
Popular Exams
Return to Question Papers