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

Cisy 221/Bbit 232 Question Paper

Cisy 221/Bbit 232

Course:Database Management Systems

Institution: Kenya Methodist University question papers

Exam Year:2010

KENYA METHODIST UNIVERSITY

END OF 3''RD ''TRIMESTER 2012 (EVENING) EXAMINATIONS
FACULTY : COMPUTING AND INFORMATICS
DEPARTMENT : COMPUTER SCIENCE AND BUSINESS
INFORMATION
UNIT CODE : CISY 221/BBIT 232
UNIT TITLE : DATABASE MANAGEMENT SYSTEMS
TIME : 2 HOURS

Instructions:

Answer question one and other two questions.

Question One

Describe four areas where one can encounter database systems in today’s world.

(4 marks)

SQL is a data sub language; explain at least four basic SQL statements used.

(4 marks)

Explain domain and integrity constraints in structured query language.

(5 marks)

Briefly explain the properties of transaction that a DBMS must maintain.

(8 marks)

Why is recovery needed in DBMS

(2 marks)

Describe the problem of ensuring that the data in the database is accurate.

(4 marks)

The Relational Algebra has two fundamental operations, outline three operations found in unary and binary.

(3 marks)

Question Two

A Country Bus Company owns a number of buses. Each bus is allocated to a particular routes although some routes may have several buses. Each route passes through a number of towns. One or more drivers are allocated to each stage of a route. Some of the towns have a garage where buses are kept and each of the bus is identified by the registration number and carry different number 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.

Required:

List all the possible entities that can be gotten from the above bus company.

(3 marks)

List any three possible relationships that can be derived from the bus company.

(3 marks)

Draw the E-R diagram for the bus company.

(5 marks)

During schema retirement in database design, the redundancy causes problems. List and briefly explain four problems caused by redundancy.

(4 marks)

Question Three

In relational algebra there are unary and binary fundamental operations. In the binary operations perform a union and intersection on the following lists.

(6 marks)\

LIST A
Jamie 555 – 234 - 546
Lydia 555 – 978 - 160
Martin 555 – 610 - 948
Norah 555 – 420 - 614
Owen 555 – 087 - 391
Peter 555 – 237 - 765
Robert 555 – 859 - 716
Tobias 555 – 104 - 309

LIST B
Ingra 555 – 794 – 625
Katherine 555 – 254 - 921
Martin 555 – 610 - 948
Norah 555 – 420 - 614
Owen 555 – 087 - 391
Quincy 555 – 703 - 498
Robert 555 – 859 - 716
Silvia 555 – 423 – 765

Making a data structured relational is achieved by the process of normalization. Normalize the following data structure in its First Normal Form (1NF) to the (3NF).

(9 marks)

Student ID Name Advisor DPT DPT Name Course name Grade
123 Jones Rose CIS Comp Sys CISY 451 A
123 Jones Rose CIS Comp Sys CISY450 B
123 Jones Rose CIS Comp Sys CISY 551 B
321 Smith Chao CIS Comp Sys CISY 451 C
321 Smith Chao CIS Comp Sys CISY 450 B
999 Abel Peterson BBIT Buss IT BBIT 450 B

Question Four

From the table provided below use SQL statement "SELECT" and show the content of the columns named "Last Name" and "address" from the table "persons"

P – Id Last Name First Name Address City
1 Hansen Ola Timoteirn 10 Sandnes
2 Svendson Tova Borgun 23 Sandnes
3 Peterson Kari Storgt 20 Staranger

Express how the SQL statement for SELECT will appear.

(2 marks)

Show the results of the above statement after the above operations on the "persons" table.

(3 marks)

Adding a new record to the table use the SQL statement INSERT INTO with the following details. Show how the statement will be applied.

(2 marks)

Name: Johan Nilson

Address: Bakken 2

City: Stravanger

Show the results of the above statement after the above operation on the "persons" table.

(3 marks)

Delete the person P-Id 1 from the above table, show the SQL statement you will use for this operation.

(2 marks)

Show the results of the above statement after the above operation on the "persons" table.

(3 marks)

Cisy 221/Bbit 232 Question Paper

More Question Papers

Popular Exams