Scribd
Upload
69 views3 pages

Advanced Database System 2018

The document outlines a course unit for Advanced Database Systems at The East African University, detailing a case study for designing a relational database for a medium-sized company. It includes various questions covering topics such as limitations of traditional file systems, client-server architecture, and roles in a database environment. Students are required to analyze data requirements, normalize attributes, and create logical data models as part of their assessment.

Uploaded by

teddyaseto2000
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
69 views3 pages

Advanced Database System 2018

The document outlines a course unit for Advanced Database Systems at The East African University, detailing a case study for designing a relational database for a medium-sized company. It includes various questions covering topics such as limitations of traditional file systems, client-server architecture, and roles in a database environment. Students are required to analyze data requirements, normalize attributes, and create logical data models as part of their assessment.

Uploaded by

teddyaseto2000
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

THE EAST AFRICAN UNIVERSITY

SCHOOL OF COMPUTER SCIENCE AND IT

UNIVERSITY COURSE UNIT


COURSE UNIT: ADVANCED DATABASE SYSTEM
COURSE CODE: CIT 3203
DATE: APRIL 2018 TIME: 2HRS
INSTRUCTIONS: QUESTION ONE IS COMPULSORY AND
ATTEMPT ANY OTHER TWO QUESTIONS
: DO NOT WRITE ON THE QUESTION PAPER

QUESTION ONE (Case Study) 30 Marks:


A relational database is to be designed for a medium sized Company dealing with industrial
applications of computers. The Company delivers various products to its customers ranging from
a single application program through to complete installation of hardware with customized
software. The Company employs various experts, consultants and supporting staff. All personnel
are employed on long‐ term basis, i.e. there is no short‐term or temporary staff. Although the
Company is somehow structured for administrative purposes (that is, it is divided into
departments headed by department managers) all projects are carried out in an inter‐disciplinary
way. For each project a project team is selected, grouping employees from different departments,
and a Project Manager (also an employee of the Company) is appointed who is entirely and
exclusively responsible for the control of the project, quite independently of the Company's
hierarchy. The following is a brief statement of some facts and policies adopted by the Company.
 Each employee works in some department.
 An employee may possess a number of skills
 Every manager (including the MD) is an employee
 A department may participate in none/one/many projects.
 At least one department participates in a project.
 An employee may be engaged in none/one/many projects
 Project teams consist of at least one member
For the above business requirements you are expected to create the following.
1. Analyze the data required.
2. Normalize the attributes.
3. Create the logical data model (ER diagrams).

QUESTION TWO
a) Explain 4 limitations of the traditional file based system. (8 marks)
b) Differentiate between Query Processing and Query Optimization. (4 marks)
c) State and explain the functions of a distributed DBMS.
(8 marks)

QUESTION THREE
a) With use of diagrams explain client-server architecture. (6 marks)
b) State and explain 3 database languages. (6 marks)
c) Name and explain the three main levels of data models. (6 marks)
d) Give any two advantages of distributed DBMSs. (2 marks)
QUESTION FOUR
a) Define The following: (8 marks)
i. Object Oriented Data Model
ii. Object Oriented Database
iii. Object Oriented DBMS
iv. Object referencing

b) What is data mining? (2 marks)


c) Explain tasks involved in data mining. (10 marks)

QUESTION FIVE
a) Explain the roles of the following persons in a database environment: (10 marks)
i. Data Administrator.

ii. Database Administrator.

iii. Database Designer.

iv. Application Programmer.

v. End Users.

b) Describe the objectives of three-level database architecture. (10 marks)

You might also like