|
|
BSc
(Hons)-IT354
- Database Design and Management
 |
 |
This
unit consists of Database Sytems 1 & 2
Database
Systems 1
AIMS
To
develop further the skills needed to design a database.
To provide
an understanding of the theoretical foundations of databases in the business
environment.
To identify
various data structures and models and to examine critically current
implementations of database management systems.
To consider
those aspects of analysis and design particular to database
systems development.
LEARNING
OUTCOMES
On
successful completion of this unit, students should be able to:
Design
and build a relational database for a small business application from given
user requirements.
Use
suitable query languages to interrogate a relational database.
Demonstrate
a knowledge of the theoretical underpinning of the relational model.
Discuss the
relative advantages and disadvantages of other database paradigms.
SYLLABUS
OUTLINE
The
topics covered in this unit will include:
Databases
Concepts and Architectures- a brief description of hierarchical and network
database models.
The
Relational Data Model- domains, tuples, attributes and relations, database
schemas, relational algebra.
Information
Retrieval and Query Languages- further SQL, relational calculus, QUEL, QBE.
Relational
Database Systems Development- multi-valued and join dependencies, fourth and
fifth normal form.
Overview
of Database Design Process- requirements collection, conceptual schema
design, data model mapping, physical database design.
ASSESSMENT PATTERN
100% by Examination. It will be of 2 hours in duration and students should attempt 3 out of4 questions.
INDICATIVE
READING
Elmasri
R and Navathe SB, (), Fundamentals of Database Systems 2e,
Benjamin-Cummings.
Connolly
T, Begg C, and Strachan A, (1996), Database Systems, Addision-Wesley
NOTES
The
topics will be introduced in lectures and developed through directed reading,
exercises and, where appropriate, practical use of database systems.
Database
Systems 2
AIMS
To
understand how a DBMS processes and executes queries and to be able to
optimise such queries.
To
examine yet further critically implementations of database management
systems.
To
be able to control multiple transactions and to be able to recover from
transaction failures.
To
identify the functions and procedures necessary for the management and
control of database systems.
LEARNING
OUTCOMES
On
successful completion of this unit, students should be able to:
Optimise
a database for commercial operation.
Discuss
data independence, quality control and recovery procedures.
SYLLABUS
OUTLINE
The
topics covered in this unit will include:
Database
System Implementation Techniques-query processing and optimisation;
Current
Trends in Database Systems- distributed database systems; object-oriented
database systems; emerging database applications.
ASSESSMENT
PATTERN
1.
Examination (100%)-The examination will be of 2 hours in duration and students
should attempt 3 out of 4 questions.
INDICATIVE
READING
Elmasri
R and Navathe SB, (), Fundamentals of Database Systems 2e, Benjamin/Cummings
Kroha
P, (), Obiects and Databases, McGraw-Hill
Connolly
I, Begg C, and Strachan A, (), Database Systems, Addison-Wesley
NOTES
The topics will be introduced in lectures and developed through directed reading, exercises and, where appropriate, practical use of database systems.
 |
|
|
