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.
More Question Papers
Exams With Marking Schemes
Popular Exams
Mid Term Exams
End Term 1 Exams
End Term 3 Exams
Opener Exams
Full Set Exams
Return to Question Papers