Database Systems(Bbit 232 )(Cisy 221)( Dbit 221)( Dcis 200)3Rd Trimester 2016 Question Paper
Database Systems(Bbit 232 )(Cisy 221)( Dbit 221)( Dcis 200)3Rd Trimester 2016
Course:Bachelor Of Business Information Technology
Institution: Kenya Methodist University question papers
Exam Year:2016
DATABASE SYSTEMS(BBIT 232 )(CISY 221)( DBIT 221)( DCIS 200)3RD TRIMESTER 2016 FT
KENYA METHODIST UNIVERSITY
END OF 3'RD 'TRIMESTER 2016 (FT) EXAMINATION
SCHOOL : SCIENCE AND TECHNOLOGY
DEPARTMENT : COMPUTING AND INFORMATION SCIENCE
UNIT CODE : BBIT 232/CISY 221/DBIT 221/DCIS 200
UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS
INSTRUCTIONS
Answer question one and any other two
Question One
What are the FOUR areas where databases are found/used?
(4 Marks)
En list and explain FIVE characteristic of database.
(5 Marks)
What is the use of SELECT statement in DBMS? Give the syntax of SELECT statement and explain the various options
(4marks)
Identify and briefly explain SIX principles services provided by DBMS.
(6marks)
Explain the following key definition with examples.
(6 Marks)
Candidate Key
Primary key
Foreign key
Describe FIVE principle functions of a database administrator.(5 Mark)
Question Two
List and explain three types of cardinalities
(6marks)
Describe the three schema database architecture
(6marks)
List the various types of constraint in DB
(3marks)
Question Three
Describe the characters of a table in unnormalized form (UNF) and explain how the table is converted to INF.
(5 Marks)
Describe the main components of a DBMS.
(5 Marks)
Give the importance of entity integrity and referential integrity in database.
(5 Marks)
Question Four
Write SQL statements to perform the following tastes
Customer table
P.D LAST Name First Name Address City
1 Hanset Olap 345 Thika
2 Standson Tore 346 Nairobi
3 Pettarson Kare
Select customer table.
(1 Mark)
Retrieve last name and first name where city is Nairobi
(3 Marks)
To update address and city where PID = 3.
(3 Marks)
To insert a row with (4, Mike, John, 243, Embu).
(3 Marks)
What is a table in 3NF?
(1marks)
Distinguish between logical independence and physical independence.
(4marks)
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