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

Database Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit221) (Dcis106) 1St Trimester 2016 Question Paper

Database Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit221) (Dcis106) 1St Trimester 2016

Course:Bachelor Of Business Information Technology

Institution: Kenya Methodist University question papers

Exam Year:2016

Database Systems (BBIT 232) (CISY 221) (COMP 340) (BSIS 115) (DBIT221) (DCIS106) 1st trimester 2016
KENYA METHODIST UNIVERSITY

END OF 1'ST 'TRIMESTER 2016 (EVENING) EXAMINATION

SCHOOL : SCIENCE AND TECHNOLOGY
DEPARTMENT : COMPUTING & INFORMATION SCIENCE
UNIT CODE : 'BBIT 232/CISY221/ COMP 340/ BSIS 115/
DBIT221/DCIS106
UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS

Instructions:

SECTION A:
COMPULSORY QUESTION '{30 '''''MARKS}
QUESTION 1

Expound on the following terms as used in database management.
(5Marks)
Database management System:
Database:
Database System:
Entity
ERD
A traditional File Processing system was the first computer-based approach of handling commercial or business applications. State any five problems that were associated with this approach. (5 Marks)
The commands COMMIT and ROLLBACK are used to help maintain database consistency during transaction management. Briefly discuss each
(2 Marks)
State the Three clauses of a basic structure of an SQL expression
(3 Marks)
Most DBMS have tools that ensure the DBA is able to perform their duties efficiently. List any FIVE duties which a DBA performs using DBMS tools.
(5 Marks)
Differentiate between the following terms as used in relational databases.
Tuple and attribute
Foreign key and Primary key
Partial and transitive dependencies
Marks)
Define normalization and state any THREE problems solved by normalization.
(4 Marks)

SECTION B: ANSWER ANY TWO QUESTIONS {15 MARKS EACH}.
QUESTION 2

State and explain three Components of an E-R model?
(3 Marks)
Nairobi contractors is a company that specializes in real estate development. They deal with customers who over the year come back and commission various jobs. Customers may be individuals or companies. For any job a number of workers may work on it and a worker may work on more than one job. On each job different types of building materials and machinery are used. Particular materials are all supplied by a different suppliers. All machinery used is owned by the company and each machinery can be used in multiple jobs
Outline all entities present in the scenario described above
(3 marks)
Draw a well decomposed Entity-Relationship diagram for the above scenario.
(6 Marks)

There are various types of relationship that can be used to associate entities. Explain any three with the aid of a diagram in each case
(3 Marks)

QUESTION 3

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
(2 Marks)
From
(1 Marks)
Where
(2 Marks)
Briefly describe the FOUR properties of a transaction.
(4 Marks)

QUESTION 4

In terms of a database sub-language, give a definition and describe the function of each of the following:
i) DDL (2 Marks)
ii) DCL (2 Marks)
iii) DML (2 Marks)

State TWO advantages of normalization.
(2 Marks)
Outline any two mechanisms of implementing database security
(3 Marks)
To the user, a distributed database should look exactly like a non-distributed database. To comply with this rule a DDBMS must achieve at least twelve objectives according to Codd’s 12 rules for relational databases. State any four of the rules.
(4 Marks)

Database Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit221) (Dcis106) 1St Trimester 2016 Question Paper

More Question Papers

Popular Exams