Scribd
Upload
87 views3 pages

Course Outline

This document provides information about a course on fundamentals of database systems for second year information technology students. The course is a core 5 CP course that meets for 10 hours per week, including 2 hours of lecture, 3 hours of lab, and 5 hours of independent study. The course objectives are for students to understand basic database design principles using different models, differentiate databases from file systems, design different types of databases, create database components using SQL, and write database programs. The course outline covers topics like database systems, the relational model, conceptual database design using E-R modeling, logical and physical database design, and query languages. Students will be assessed through exams, and the course references several database system textbooks.

Uploaded by

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

Course Outline

This document provides information about a course on fundamentals of database systems for second year information technology students. The course is a core 5 CP course that meets for 10 hours per week, including 2 hours of lecture, 3 hours of lab, and 5 hours of independent study. The course objectives are for students to understand basic database design principles using different models, differentiate databases from file systems, design different types of databases, create database components using SQL, and write database programs. The course outline covers topics like database systems, the relational model, conceptual database design using E-R modeling, logical and physical database design, and query languages. Students will be assessed through exams, and the course references several database system textbooks.

Uploaded by

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

Information Technology Program

Program Information Technology


Course Code ITec2071
Course Title: Fundamentals of database Systems
Degree Program Information Technology
Module Name Database Systems
Module Number 07
CP Credits (CP) 5
Contact Hours Lecture Tutorial Lab/Practical Home Study Total
(per week) 2 0 3 5 10

Target Group: 2nd Year Information Technology Students


Year /Semester Year: II, Semester: I
Pre-requisites
Status of the Core
Course
Course This course covers basic concepts behind database systems. It presents
Description methodology for conceptual, logical, and physical database design for
relational systems and its language (Structured Query Language). The
course also examines distributed database management systems and object-
oriented database management systems
Course Objective Upon successful completion of the course, the student is expected to be
able to:
 Understand the basic principles of database design systems using
different database models
 Differentiate database from file system
 Design different types of databases
 Create database tables, views, and indices
 Write SQL queries and database programs
Course outline
Chapter 1: Introduction
• Database
• Data management approach
• Components of DBMS
• Functions of DBMS
• Database Development Lifecycle
• Roles in database design environment
(DBA, DBD user.)
• The ANSI-SPARC Architecture
• Database Languages (DDL, DML, DCL)
• Data models

Chapter 2: Relational Model


• Relational Constraints
• Relational Integrity
• Key constraints
• Referential constraints

Chapter 3: Conceptual Database Design – E-R


modeling
• Basic concepts of E-R model
• Structural constraints
• Cardinality constraints
• Participation constraints
• Problem with E-R models
• Enhanced E-R models
Chapter 4: Logical Database Design
• Normalization
• Functional dependencies

• Process of normalization (1NF, 2NF, 3NF)

Chapter 5: Physical Database Design


• Physical database design process
• Database design and implementation for
relational databases

Chapter 6: Query Languages


Relational Algebra
• Relational calculus
• Data security
• Client-server systems
• Distributed Database Systems
• Data warehousing and data Mining
Assessment As per University Legislative
Text Book
Reference
Elmasri, et al (2011). Fundamentals of Database
th
Systems, 6 ed, Pearson education
References
1 David M. Kroenke. (1998). Database
th
processing, 6 ed. Prentice Hall
2 Introduction to Database systems, C.J. DATE
3 Navathe, E (2000). Fundamentals of database
Systems. 3rd ed. Delhi, Pearson Education
4 Ramon A, etal. Shaum’s outlines,
fundamentals of relational databases
5 Silbershatz A. Korth H &Sundarshan (2006).
th
Database System concepts, 5 ed. Boston,
McGraw Hill
6 Thomas M. Connolly and Carolyn E.Begg
(2004). A step-by-step approach to building
nd
databases, 2 ed.Pearson Education Limited.

You might also like