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

Database Management Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit 221) (Dcis106)1St Trimester 2017 Question Paper

Database Management Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit 221) (Dcis106)1St Trimester 2017 

Course:Bachelor Of Business Information Technology

Institution: Kenya Methodist University question papers

Exam Year:2017



DATABASE MANAGEMENT SYSTEMS (BBIT 232) (CISY 221) (COMP 340) (BSIS 115) (DBIT 221) (DCIS106)1ST TRIMESTER 2017
KENYA METHODIST UNIVERSITY

END OF 1'ST 'TRIMESTER 2017 (PT) EXAMINATION

SCHOOL : SCIENCE AND TECHNOLOGY
DEPARTMENT : COMPUTER SCIENCE
UNIT CODE : BBIT 232/221/CISY 221/COMP 340/BSIS 115/DCIS 106
UNIT TITLE : DATABASE MANAGEMENT SYSTEMS
TIME : 2 HOURS


Instructions:

Answer question One and any Other two questions.
SECTION A (30 Marks)

Question One

In terms of a database sub-language, give a definition and describe the function of each of the following:
DDL
DCL
DML
(6 Marks)
Briefly explain the first three forms of normalization.
(6 Marks)
You have just been recruited as a database administrator of a financial institution. Discuss any five tasks you will carrying out.
(5 Marks)
The commands COMMIT and ROLLBACK are used to help maintain database consistency during transaction management. Briefly discuss each
(4 Marks)
Explain the 6 uses of databases in a business environment.
(6 Marks)
State the three clauses of a basic structure of an SQL expression.
(3 Marks)


Question Two

Mary has designed the following table using a database application
Tbl customers: Table
Customer ID Last name First name Phone Email
1 Kelly Jill


Write SQL statement to help her carry out the following tasks. (12 Marks)
Add the following record
Customer number 2
Customer first name smith
Customer last name john
Customer phone number 455-1098
Customer email: johnsmith@xyz.com
Change customer name 1 phone number to 2423423
Delete customer number 2
Display the total number of customers in the table
One key function of a DBMS is to provide security for the data held within it. Identify three ways in which a DBMS is able to achieve security.(3 Marks)


Question Three

State and explain the major three causes of Database Failures.
(6 Marks)
Define the following parts of this SQL statement
"SELECT studentnumberFROM Results WHERE mark >=50%"

Select
From
Where
(5 Marks)
Briefly describe the FOUR properties of a transaction.
(4 Marks)


Question Four

Draw an ER diagram which indicates the entities for the narrative below. Identify and label significant relationships between pairs of entities.
(8 Marks)
The kwiktite corporation operates many factories. Each factory is located in a region. Each region can be "home" to many of Kwiktites factories. Each factory employs many employees, but each of these employees is employed by only one factory. The employees have dependents who are known to the factory

What is the transaction? Explain the different transaction states with the help of a detailed diagram.
(6 Marks)
What is an attribute?
(1 Mark)






More Question Papers


Popular Exams


Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams



Return to Question Papers