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