[go: up one dir, main page]
Scribd
Upload
24 views2 pages

Database Systems Course Plan and Outline

very important note for the students and for the instructor.

Uploaded by

adane
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
24 views2 pages

Database Systems Course Plan and Outline

very important note for the students and for the instructor.

Uploaded by

adane
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
You are on page 1/ 2

Database Systems Course Outline

Mekelle University
Ethiopian Institute of Technology – Mekelle
School of Electrical and Computer Engineering

Course Title: Database Systems Academic Year: 2019/20


Course Code: ECEG-4172 Semester: I
Pre-requisite: ECEG-3142 (OOP) ECTS: 5 (2+1+2)
Program: Regular Instructor: Bisratie T. (MSc)
Office: L14-104 (Arch Bldg) Office Hrs: Mon - Fri (8:30am-5:30pm)

Course Objectives

 To introduce the concepts of database systems and modeling techniques;


 To provide a profound ground for the analysis, design and implementation of database
systems;
 To discuss advanced types and issues related to storage and security;

Course Description

Fundamental Concepts of Database Systems, Conceptual designs, Relational database design,


Relational algebra, Structured Query Language (SQL), Data storage and query evaluation,
Security and Integration, Introduction to distributed and parallel databases.

EiT-M School of Electrical and Computer Engineering


Database Systems Course Outline

Course Plan and Content

Week Topic Content


1 1 Databases & Database User

2,3 2 Database System Concepts and Architecture


Lab #1
4,5 3 Data Modeling Using the Entity-Relationship (ER) Model
Test 1 (November 02)
6 4 The Enhanced Entity-Relationship (EER) Model
Lab #2
7,8 5 The Relational Data Model and Relational Database Constraints
Lab #3
9 6 Relational Database Design by ER and EER-to-Relational Mapping
Quiz 1
10 7 Formal Relational Query Languages
Test 2 (December 07)
11,12,13 8 Structured Query Languages (SQL)
Quiz 2 & Lab #4
14 9 Storage and File Structure (Optional)

15 10 Query Processing (Optional)

Methods of Assessment

 Formative Assessments:
Quiz, Lab-test, Tests, and Projects 50%
 Summative Assessment
Final Examination 50%
Reference
1. Elmasri, Navathe: Fundamentals of Database Systems
2. Silbershatz, Korth, Sudarshan: Database System Concepts
3. Raghu Ramakrishnan, Johannes Gehrke: Database Management Systems
4. H.C. Mollina, J.D. Ullman, J.Widom: Database System The Complete Book
5. Pervasive Software Inc., Database Design Guide

EiT-M School of Electrical and Computer Engineering

You might also like