Scribd
Upload
6 views2 pages

Database Systems II Course Outline

The course Database Systems II (BAIS3062) at Addis Ababa University focuses on designing, developing, and testing small database systems using commercial DBMS, building on concepts from the previous course BAIS 3061. Key topics include SQL Data Manipulation and Definition Languages, database technology issues, and related areas such as distributed databases and data warehousing. Students will engage in practical case studies and team projects, with evaluations based on tests, assignments, and a final exam.

Uploaded by

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

Database Systems II Course Outline

The course Database Systems II (BAIS3062) at Addis Ababa University focuses on designing, developing, and testing small database systems using commercial DBMS, building on concepts from the previous course BAIS 3061. Key topics include SQL Data Manipulation and Definition Languages, database technology issues, and related areas such as distributed databases and data warehousing. Students will engage in practical case studies and team projects, with evaluations based on tests, assignments, and a final exam.

Uploaded by

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

ADDIS ABABA UNIVERSITY

SCHOOL OF COMMERCE
DEPARTMENT OF BUSINESS ADMINISTRATION AND INFORMATION SYSTEMS
COURSE OUTLINE

A. Course Name: Database Systems II


B. Course Code: BAIS3062
C. Credit Hours: 3
D. Contact Hours:

E. Course Description:
This is a continuation of the course BAIS 3061. In this course, students are required to design,
develop, and test a small database system based on the principles and techniques which were
covered in the course (BAIS 3061) using a commercial DBMS. Continuous follow-up on the
progress of the students on this Case Study shall be made seriously.

SQL Data Definition and Data Manipulation Languages are covered in some detail and shall be
simultaneously used in the creation and subsequent application of the database objects of the
Case Study. DML shall be treated before DDL for reasons of simplicity and convenience only.
Issues on Database Technology (transaction management, concurrency control, reliability,
recovery, and security) are discussed. Selected topics from related areas: Distributed databases,
Data warehousing, OLAP and Data Mining are briefly discussed.

F. Course Objectives:
Upon successful completion of this course the student should be able to:
 Independently Design, develop, and put to use a small database system.
 Be an active participant in a team which undertakes a task to design, develop, and
implement a large database system.
 Understand the responsibilities of the people having roles in a Database Environment.
 Prepare job descriptions for the people having roles in a Database Environment.
 Use a Database System at an appreciable level of expertise
 Recommend an appropriate DBMS for use by an organization.
G. Course Content:
1. Revision of selected topics from the course: BAIS 3061
 ER and EER Modeling
 Normalization process and its significance to Relational Databases
 Undertake a Case Study on design, development, and use of a Database
System

1|Page
2. SQL Data Manipulation Language
 The SELECT statement
 INSERT, UPDATE, and DELETE statements
 GROUP BY
 Aggregate functions
 Operators – arithmetic, comparison, logical, UNION, Concatenation, EXISTS
 UPDATE
 DELETE
3. SQL Data Definition Language
 Creating the Database
 Creating Tables
 Constraints: primary key, foreign key, uniqueness, CHECK
 Other objects in the database: indexes, views
4. Active Databases
 Stored Procedures
 Triggers
5. Issues on Database technology
 Transaction management
 Concurrency control
 Security
6. Additional topics and Related areas of study
 Distributed DBMS
 WWW and Databases
 Data Warehousing
 OLAP and Data Mining, ...
H. Course Evaluation:
1. Tests, Assignments and Project 50%
2. Final Exam 50%
I. References and texts list
1. Thomas Connolly and Carolyn Begg. Database Systems, a practical approach to
Design, Implementation, and Management.(Text)
2. Elmasri R. & Navathe S.B. Fundamentals of Database System Concepts
3. C.J. Date. An Introduction to Database Systems
4. Schaum’s Outline – Fundamentals of SQL Programming by A. Ramonn, A. Mata-Toleda,
Paulin K. Cushman
5. Mastering SQL Server 2000 by Mike Gunderlowy & Joseph L. Jorden

2|Page

You might also like