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
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