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

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)

Database Systems(Bbit 232 )(Cisy 221)( Dbit 221)( Dcis 200)3Rd Trimester 2016 Question Paper

More Question Papers

Popular Exams