Course Information

INFO2415 Enterprise Database Systems

COURSE CODE:       INFO 2415

COURSE TITLE:      Enterprise Database Systems

CREDITS:                    4

LEVEL:                         2

PRE-REQUISITES: INFO1506

COURSE DESCRIPTION:

The course covers the design, implementation and management of Database Systems. Emphasis is placed on database design of real world business applications using Entity-Relationship modeling. SQL programming is covered in detail. Query Optimization concepts are introduced in the context of database performance tuning. Data Management concepts such as Transaction Management, Concurrency Control, Recovery, and Security are discussed. Several current database environments and applications including Distributed Databases and Web-enabled Databases are discussed.

COURSE RATIONALE:

Databases are incredibly prevalent; they are a crucial component of telecommunication systems, banking systems or any electronic device that maintains persistent information. Databases also provide reliability and efficiency which makes it an important tool which information technology science students must become familiar with.

CONTENT:

1. Introduction to Database Systems

  • Database / File-based systems; DBMS Functions; Components of a Relational database System; Introduction to Database Design

2. The Relational Data Model –Relational Data Objects, Data Integrity, and Relational Operators

3. Structured Query Language

  • Data Definition commands; Data Manipulation commands; Views; Privileges and Roles
  • Triggers and Stored Procedures

4. Database design

  • ER Modeling; Functional Dependency and NormalizationTransaction Management
  • Transaction processing concepts; Concurrency Control; Recovery; Security

5. Query Processing and Optimization (Performance Tuning)

6. Steps in Processing an SQL query; Cost-based Query Optimization

7. Databases and the Internet – Web technology and Databases; ODBC/JDBC; XML and databases

8. Distributed databases – Distributed database design; Fragmentation and Replication

9. Database Administration – Managerial functions; Technical functions

LEARNING OUTCOMES:

At the end of this course, students should be able to:

  • Identify the practical aspects of database design and be able to use data modeling tools. They will develop real and useful design skills.
  • Explain Structured Query Language (SQL) and use it to implement and manage databases. 
  • Explain how databases are affected by real-world transactions, including the characteristics of database transactions and how they affect database integrity and consistency. 
  • Design Distributed Database Systems and describe the performance, availability and integrity issues involved.
  • Describe the architecture of a database driven web site and how the middleware components facilitate dynamic web pages.
  • Explain the managerial and technical roles of a Database Administrator.

ASSESSMENT:

Method of Evaluation

Percentage of Grade

Restriction

Coursework

       3 Assignments (21%)

( case studies and design problems)

 

       1 1-hr written exam (10%)

 

       1 2-hr Practical exam (9%)

 

40 %

 

Final Examination

     One 2-hours written paper

     (Covers entire course – all           

       lectures, readings and  

       tutorials.)

 

60%

Fail Theory Regulation

Students must get a passing grade on final examination to pass the course.

TEACHING STRATEGIES:

The course is delivered using a combination of lectures; practical lab sessions and online activities delivered using the myElearning system such as forum discussions and online quizzes.

RESOURCES:

Rob, P. and C. M. Coronel. 2006. Database Systems: Design, Implementation & Management.  Boston : Course Technology.

COURSE CALENDAR:

TIME PERIOD

TOPIC

WEEK 1

Introduction to Databases; Lab 1 – Introduction to Oracle and SQL

WEEK 2

The Relational Model; Lab 2 – Data Definition

WEEK 3

Database Design – ER Modeling; Lab 3 – Queries involving two tables

WEEK 3

Assignment 1

WEEK 4

Database Design – ER Modeling; Lab 4 – Views

WEEK 5

Database Design – Normalization; Assignment 2

WEEK 6

Theory Exam

WEEK 6

Databases and XML; Lab 5 – XML

WEEK 7

Transaction Management

WEEK 8

Assignment 3

WEEK 8-9

Query Processing Assignment

WEEK 10

Databases and the Internet

WEEK 10

Practical Exam

 

WEEK 11

Distributed databases

WEEK 12

Database Administration

WEEK 13

Revision