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

Database Systems (Bbit 232) (Cisy 221) 1St Trimester 2015 Question Paper

Database Systems (Bbit 232) (Cisy 221) 1St Trimester 2015

Course:Bachelor Of Business Information Technology

Institution: Kenya Methodist University question papers

Exam Year:2015

Database Systems (BBIT 232) (CISY 221) 1ST TRIMESTER 2015
KENYA METHODIST UNIVERSITY

END OF 1'st 'TRIMESTER 2015 (FT) EXAMINATION

FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE
UNIT CODE : BBIT 232/CISY 221
UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS

INSTRUCTIONS:

Answer questions 1 and any other two questions.

Question One

Define the following terms as used in database systems.
(3 marks)
Database
Entity
Attribute
By defining an integrity constraint distinguish between entity integrity and referential integrity as used in between management systems.
(3 marks)
Outline five disadvantages of traditional filing system.
(5 marks)
With examples identify three common types of entity relationships
(6 marks)
Outline four anomalies that data normalization seeks to correct
(4 marks)
Outline the function of the following basic SQL statements.
(5 marks)
CREATE
SELECT
INSERT
DELETE
UPDATE
Explain four properties of a transaction that a DBMS must maintain.
(4 marks)

Question Two

Define a transaction as used in database management.
(2 marks)
Using a diagram explain the transaction transition states.
(6 marks)
Outline five techniques that can be used to reduce or eliminate deadlocks on a highly concurrent system.
(5 marks)
The ANSI standards committees have specified transaction behavior on a database according to the ACID principle. Describe the ACID principle and how it relates to database transactions.
(4 marks)
Using illustrations explain three symbols used in ERDS.
(4 marks)

Question Three

State the logical steps followed when constructing a database system.
(5 marks)
Consider the following sales order form and use it to answer the questions that follow:
Sales Order
Fiction Company
202 N. Main
Manhattan, KS 66502
Customer Number: 1001 Sales Order No: 405
Customer Name : ABC Company Sales Order Date: 2/1/2000
Customer Address :100 pointsClerk Number: 210
Manhattan, KS 66502Clerk Name: Martin Lawrence
Item ordered Description Quantity Unit Price Total
800 Widgit small 40 60.00 2,400.00
Tingimajigger 20 20.00 400.00
Thingibob 10 100.00 1,000.00
Order Total 3,800

Explain the purpose of normalizing data.
(4 marks)
Distinguish between 2nd and 3rd normal forms.
(2 marks)
Normalize the data in the sales order form above the 3rd NF
(9 marks)

Question Four (20 Marks)

Explain the advantage of using databases.
(8 marks)
Discuss each of the three general levels of architecture for DBMSs (9 marks)
External
Conceptual
Internal
Outline three databases.
(3 marks)

Question Five (20 marks)

A Country Bus Company owns a number of busses. Each bus is allocated to a particular route, although some routes may have several busses. Each route passes through a number of towns. One or more drivers are allocated to each stage of a route, which corresponds to a journey through some or all of the towns on a route. Some of the towns have a garage where busses are kept and each of the busses are identified by the registration number and can carry different numbers of passengers, since the vehicles vary in size and can be single or double-decked. Each route is identified by a route number and information is available on the average number of passengers carried per day for each route. Drivers have an employee number, name, address and sometimes a telephone number.

Identify six entities from the above information.
(6 marks)
Identify possible attributes for each entity identified in above.
(6 marks)
By identifying the possible relationships draw the ERD.
(8 marks)

Database Systems (Bbit 232) (Cisy 221) 1St Trimester 2015 Question Paper

More Question Papers

Popular Exams