Bahir Dar Institute of Technology

Faculty of Electrical & Computer Engineering

Database Management Systems [CoEg2122] Course Guide Book
Academic Year 2019/2020
1. General Information
Course Title Database Management Systems
Course Code CoEg2122 Instructors
Pre-requisite Fundamentals of Programming Name Haimnaot T./Tigistu B.
Course type Compulsory Office no Room-2
CP/ Cr.hr 5CP Email [email protected]
Contact hours Lecture Tutorial Lab H. Study Consultation hr. Thursday 9:00-11:00
2 0 3 5 Lab Instructors /Assistants
Program/Department Year Section Name Haimnaot T./Tigistu B.
Target Group
Regular/Computer Engineering 2nd A&B Office no Room-2

2. Course Description
This course introduces the student Database Management System (DBMS), different data models, relational
algebra concept, SQL queries, Relational Database design theory and Transaction management and query
optimization in DBMS. This course also introduces the Object-Oriented databases and Database architecture.
This course equips students with fundamental knowledge and basic technical competence in the field of
DBMS.
Course objective/ Course Outcomes /learning outcome:
At the end of this course the students will be able to:

▪ Understand database concepts, applications, data models, schemas and instances.

▪ Implement the relational database design and data modelling using entity-relationship (ER) model.
▪ Demonstrate the use of constraints and relational algebra operations.
▪ Use of SQL in querying the database
▪ Demonstrate Normalization process.
▪ Learn the new emerging Technologies and Applications in database.
▪ Create a Good Database Design
▪ Handle Relational Databases.

1
3. Course outline with teaching methodology, week and reference
Week Course Contents Teaching Methodology Reference
Week 1,2,3 Chapter 1: Introduction to Database Systems Textbook 3-28
1.1 Database System and File System Reference 1&2
Lecture & Laboratory
1.2 Characteristics of the Database Approach
1.3 Actors on the Scene
Week 4,5 Chapter 2: Database System Concepts and Architecture Textbook 31-54
2.1 Data Models, Schemas, and Instances Reference 1&2
2.2 Three-Schema Architecture and Data Independence
Lecture & Laboratory
2.3 Database Languages and Interfaces
2.4 The Database System Environment
2.5 Classification of Database Management Systems
Week 6,7 Chapter 3: Data Modeling using Entity Relationship Model Textbook 59-94
3.1 Using High-Level Conceptual Data Models for Database Design Reference 1&2
3.2 Entity Types, Entity Sets, Attributes, and Keys
Lecture & Laboratory
3.3 Relationship Types, Relationship Sets, Roles
and Structural Constraints
3.4 ER Diagrams, Naming Conventions, and Design Issues
Week 8 Mid Exam
Week 9 Chapter 4: Enhanced Entity-Relationship and Object modeling Textbook107-
4.1 Subclasses, Superclasses, and Inheritance 135
Reference 1&2
4.2 Specialization and Generalization
Lecture & Laboratory
4.3 Constraints and Characteristics of Specialization
and Generalization Hierarchies
Week10,11 Chapter 5: Database Design Textbook459-
5.1 Functional Dependency 495
Lecture & Laboratory
5.2 Normalization Reference 1&2

Week 12 Chapter 6: Basic Relational Algebra and Calculus Lecture & Laboratory Textbook239-
6.1 Introduction 279
6.2 Relational algebra Reference 1&2
6.2.1Operations in relational algebra
6.3 Relational Calculus
6.3.1Tuple relational calculus
6.3.2 Domain relational calculus
Week 13 Chapter 7: Record Storage and Primary File Organization Lecture & Laboratory
7.1 Operations on Files Textbook541-
7.2 Files of Unordered Records (Heap Files) 592
7.3 Files of Ordered Records (Sorted Files) Reference 1&2
7.4 Hashing Techniques
Week Chapter 8: Index Structure for Files Textbook601-
8.1 Types of Single-Level Ordered Indexes 646
14,15 Lecture & Laboratory
8.2 Multilevel Indexes Reference 1&2
8.3 Dynamic Multilevel Indexes Using B-Trees & B+-Trees
8.4 Indexes on Multiple Keys
16 Final Exam

2
4. Laboratory /Work shop/ session content and required material
Time (in week) Laboratory Topic Material or tools
Week 1 Introducing Microsoft SQL server 2017 environment and SQL Server 2017
creating, modifying and deleting databases
Week 2 Creating, Modifying, Deleting Tables SQL Server 2017
Week 3 Inserting Data SQL Server 2017
Week 4 Retrieving and Filtering Data SQL Server 2017
Week 5 Formatting Result Test SQL Server 2017
Week 6 Grouping and summarizing Data SQL Server 2017
Week 7 Implementing Data Integrity Constraints SQL Server 2017
Week 8 Joining Multiple Tables SQL Server 2017
Week 9 Updating, Deleting and Truncating Data SQL Server 2017
Week 10 Database Connectivity with Front End Tools SQL Server 2017, Java
Week 11 Sub queries SQL Server 2017
Week 12 Creating Views and Creating Index SQL Server 2017

5. Assessment type, weight and duration (Minimum 6 including Mid-exam and Final-exam)
Assessment type Mark allotted Duration
Assignment 1 12% Before Mid
Mid exam 25%
Project 1 11% After Mid
Project 2 12% After Mid
Final Exam 40%
Total 100%

6. Course Policy
All students are expected to abide by the code of conduct of students (article 166 and 166.1.1, of the Senate
Legislation of Bahir Dar University May 20, 2005) throughout this course. Academic dishonesty, including
cheating, fabrication, and plagiarism will not be tolerated and will be reported to concerned bodies for action.

Class attendance and participation: You are expected to attend class regularly. I will take attendance on
regular days during the semester to ensure that students are coming to class, and if you miss class repeatedly,
your grade will be affected as it has value. If you miss more than 85% lecture and tutorial and 100% for
laboratory class attendance you will not sit for final exam.

3
7. Text and Reference Book
A. Text Book
1. ELMASRI, R., & NAVATHE, S. (2016): Fundamentals of database systems 7th edition. Boston,
Pearson/Addison Wesley
B. Reference Materials
1. Carlos Coronel and Steven Morris Database Systems (2019): Design, Implementation, and Management,
13th Edition, Cengage Learning, Inc.
2. Abraham Silberschatz, Henry F. Korth, S. Sudarshan (2020): Database system concepts 7th edition,
McGraw-Hill, New York

Authorization
a. Prepared instructor’s/s’ Name: Haimanot Tizazu /Tigistu B.

Signature: ____________________________________ Date: _____________

b. Verified chair holder’s Name: Andargachew Gobena

Signature: ____________________________________ Date: _____________