Get premium membership and access revision papers, questions with answers as well as video lessons.
Principles Of Database Design Question Paper
Principles Of Database Design
Course:Diploma In Information Technology
Institution: Kca University question papers
Exam Year:2010
UNIVERSITY EXAMINATIONS: 2011/2012
STAGE II EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLOGY
DIT 205 PRINCIPLES OF DATABASE DESIGN
DATE: APRIL, 2012 TIME: 1½ HOURS
INSTRUCTIONS: Answer Any Three Questions
QUESTION ONE [20 Marks]
a) Explain any FOUR advantages of database approach [8 Marks]
b) Briefly explain the following database models
i. Relational model [3 Marks]
ii. Object oriented model [3 Marks]
iii. Network model [3 Marks]
iv. Hierarchical model [3 Marks]
QUESTION TWO [20 Marks]
a) In a customer banking system, a customer may open an account with any bank. The bank must
therefore have customers. Though there are different types of accounts offered by a bank, the
customer is allowed to open not more than one account in the same bank. In each of the account
opened, the customer must perform a number of transactions like depositing, withdrawing etc, but
the customer can only perform one transaction at a time.
Required:
2
Create a conceptual database model for this case. [10 Marks]
b) In a house rental system, there are various houses available for renting. A landlord may own one or
more houses for renting and a house can be owned by more than one landlord. One or more tenants
may rent a house. The tenant(s) must therefore pay rent on monthly basis. Each house is described
by attributes houseNo, housename and location. The landlord is described by attributes landlordNo,
Name and Address. The rent is described by the attributes paymentNo, Amount and DatePaid.The
tent can be described by TenantNo,Name.
Required:
Normalize these attributes from First up to third normal form [10 Marks]
QUESTION THREE [20 Marks]
a) There are some basic integrity problems that can result if transaction isolation in a database is not
enforced. Describe the three problems in this context. [9 Marks]
b) Describe any FOUR functions of a database management system(DBMS) [8 Marks]
c) Define the term physical database design [3 Marks]
QUESTION FOUR [20 Marks]
a) Using the table named student in database named Class shown below, write SQL DML statements
that will return the following:
i. Students whose FirstName begin with letter âFâ [4 Marks]
ii. Unique grades scored by the students [3 Marks]
b) Outline any FIVE properties of a relation in relational databases. [5Marks]
c) Describe any FOUR uses of a data dictionary. [8 Marks]
3
QUESTION FIVE [20 Marks]
a) Outline the following properties of a transaction: [8 Marks]
i. Atomicity.
ii. Isolation.
iii. Durability.
iv. Consistency.
b) The managers of a car showroom uses database to store data about car he sells. This is part of the
database.
Make Model Engine_Size Registration Price
Opel Vectra 1.8 KBP 888U Kshs 560000.00
Opel Zafira 2.0 KAH 543Y Kshs 760000.00
Volkswagen Golf 1.4 KBN 787X Kshs 540000.00
Volkswagen Jetta 1.2 KAJ 677G Kshs 450000.00
Volkswagen Jetta 1.6 KBB 456U Kshs 456000.00
Renault Megane 1.4 KAX 321T Kshs 678000.00
Renault Clio 1.2 KAB 333Y Kshs 560000.00
i. How many tuples are there in this part of the relation.[2 Marks]
ii. State the degree of this relation. [2 Marks]
iii. Give the attribute domain for this part of the relation for the attribute model. [2 Marks]
iv. State a possible primary key for this relation hence give two reasons for your choice. [6 Marks]
More Question Papers
Popular Exams
Return to Question Papers