Get premium membership and access revision papers, questions with answers as well as video lessons.

Examination For The Degree Of Bachelor Of Science Information Technology Ics 2206 Database Systems Question Paper

Examination For The Degree Of Bachelor Of Science Information Technology Ics 2206 Database Systems

Course:Bachelor Of Science

Institution: Dedan Kimathi University Of Technology question papers

Exam Year:2010

Page 1 of 3
KIMATHI UNIVERSITY COLLEGE OF TECHNOLOGY
University Examinations 2010/2011
SECOND YEAR SEMESTER I EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE INFORMATION TECHNOLOGY
ICS 2206 Database Systems
DATE: 12th August 2010 TIME: 11am – 1 pm
Instructions: Answer Question 1 and Any Other Two.
Question one (30mks)
a) Give any four common uses of a data base 2mks
b) Describe the five components of the DBMS and discuss how they relate to each other. 10mks
c) Explain each of the following terms
i. Data 1mk
ii. Database application programs 1mk
iii. Data model 2mks
iv. View 2mk
v. DDL 1mk
vi. DML 1mk
d) Discuss the function and importance of conceptual modeling 4mks
e) Differentiate between a relation and a relationship 2mks
f) Explain the two types of multiplicity constraints 4mks
Question two 20mks
a) Discuss the role of the following personnel in a DBMS environment
i. Database administrator 2mks
ii. Logical database designer 2mks
Page 2 of 3
b) Mention any two other personnel (roles) in a DBMS environment 1mk
c) Describe the role and the use of system definition in the database development life cycle. 4mks
d) Differentiate between Weak and strong entity types 2mks
e) Use an appropriate example to describe a unary relationship 3mks
f) Consider the following schema;
Student (regno, age, name, gender)
Parent (parent id, Name, contacts)
A Parent can have more than one student in the system. A student can only have one parent.
Required:
i) Draw an ER diagram to represent the database 1mk
ii) Explain how this schema should be implemented in an access data base including the relationships if any 5mks
Question Three (20MKS)
a) Describe at least three counter measures to employee in countering database security threats 6mks
b) Explain the factors to consider when choosing the appropriate counter measures to employ
6mks
c) Describe a fan trap in an ER diagram and how are they resolved 6mks
d) Briefly explain the term normalization 2mks
Question four (20mks)
a) Briefly explain the term threat 1mk
b) Briefly explain the term index and why it is important 3mks
c) Explain how you would create an index that has two attributes in
i. Ms Access data base 3mks
Page 3 of 3
ii. Using SQL statements 3mks
d) Explain the three levels of data abstraction and their importance in database design 9mks
e) Briefly explain the term meant by the degree of relationship 1mk
Question five (20mks)
a) Briefly explain the term a foreign key 1mk
b) Explain the following
i. Entity integrity rule 2mks
ii. Referential integrity rule 2mks
c) Consider the following un normalized data ;
Required:
i) Normalize the data in the table at least to the 3rd normal form (3nf) 3mks
ii) Draw an ER diagram of the resulting schemas after normalization 3mks
iii) Write the SQL statements that would create at least two of the tables from the resultant model 4mks
iv) Insert at least two records into one of the created tables using an SQL statement 2mks
v) Write an sql statement that would increase the cost of all the items by 20% 2mks
vi) Write an SQL statement that would count the number of items stored in the number of orders made 1mk
Order Table
Order number (pk)
Order date
Customer id
Customer name
Customer address
Item group id
Item group name
Specific item id
Item name
Cost per unit
Quantity of items ordered

Examination For The Degree Of Bachelor Of Science Information Technology Ics 2206 Database Systems Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams