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

Database Systems (Cisy 221) (Bbit 232) (Bsis 114) (Dbit 221) 1St Trimester 2014 Question Paper

Database Systems (Cisy 221) (Bbit 232) (Bsis 114) (Dbit 221) 1St Trimester 2014

Course:Bachelor Of Business Information Technology

Institution: Kenya Methodist University question papers

Exam Year:2014

DATABASE SYSTEMS (CISY 221) (BBIT 232) (BSIS 114) (DBIT 221) 1ST TRIMESTER 2014
KENYA METHODIST UNIVERSITY

END OF 1'ST 'TRIMESTER 2014 (EVENING) EXAMINATION

FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE AND BUSINESS
INFORMATION
UNIT CODE : CISY 221/BBIT 232/BSIS 114/DBIT 221
UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS

Instructions: Answer question one and any other two.

Question One

Explain the following terms:
Scheme.
(2mks)
Entity
(2mks)
Primary key
(2mks)
Attribute
(2mks)
Attribute value
(2mks)
State at least two disadvantage of the floor file data store. (3mks)
Name five components of a DBMS (data base management systems) (5mks)
What are the main advantages of a DBMS.
(5mks)
Briefly evaluate the possibility of a primary key as hang a null values.
(4mks)
Name and describe the characteristics of a retention.
(3mks)

Question Two

Define the term normalization as used in databases.
(4mks)
What problems do we expect to get from normalized relation in a database. Illustrate your answer with a sample retention.
(6mks)
Consider the following table from a company that deals in ice cream flavors
1 Tim 123 20/02 1 Pistaccio 2 10 10 Mlan
1 Tim 123 20/02 2 Vanilla 3 20 10 Mean
1 Tim 123 22/02 3 Strawberry 4 30 20 Scolt
1 Tim 456 21/03 4 Nazelnut 5 40 30 Tiger
1 Tim 456 24/03 5 Chocolate 6 20 22 Willny
2 John 789 20/03 4 Nazelnut 7 40 30 Tinner
2 John 789 09/04 7 Coconut 4 50 31
The attributes are defined as

Cwo –customer numbers

Crave – customer ……..

Onave – order name

Odate – order date

Prodno – product number

Prodname – product name

Pqty – product quality

Price per scop – price per scoop

Supno – supplier number

Sname – supplier name

You are required to normalize the relation to their third normal form. Use attributes only in your relation (10mks)

Question Three

Explain in details the data expected to be found in a data dictionary.
(4mks)
With the help of a diagram, outline one TUSISPARC model of the ….
(10mks)
Discuss the following types of integrities.
Domain relational integrity (DRI)
(3mks)
Referential integrity
(3mks)

Question Four

Define the term entity relationship modeling (ERM).
(4mks)
What advantages does the ERM provide in the modeling and design of the database.
(5mks)
KEMU offers a number of courses from various departments. A course cannot be offered by more than one department. A school may have a number of departments. Each course has a number of subjects. Some subjects belongs to a department and can teach a number of subjects. One subject may be taught by many lecturers when taught to many groups. A student can only do one course at a time. You are required to create an ER diagram for the above database showing all the relationships and the major attributes expected in each entity. Use the Chen – notation in your ER diagram.

Database Systems (Cisy 221) (Bbit 232) (Bsis 114) (Dbit 221) 1St Trimester 2014 Question Paper

More Question Papers

Popular Exams