Yarmouk University

Faculty of Computer Science and

Information Technology
Document Approval Date Document Code
Course Syllabus
AP01-PR05

Faculty of Info. Technology & Comp. Sciences

:Official Stamp
Department: Information Systems

Course Identification
Course Name: Database Systems Course Code and Number: CIS 260
Number of Credit Hours: 3 Semester: Fall 2023/2024
Course Status: Compulsory Teaching Language: English
Pre-requisite: CIS 101 , CS 210 Course Coordinator:

General Information
Teaching Method ✘ Face-to-Face Online Blended
The main objective of this course is to provide students with the basic
knowledge of database systems, their types, how to create and deal
with them, and their theoretical and mathematical foundations. It
covers a range of topics including: Databases and Database Users,
Database System Concepts and Architecture, Conceptual Data
Course Description Modelling Using the Entity-Relationship Model, Enhanced Entity –
Relationship (EER) and Object Modelling, Relational Data Model and
Relational Constraints, Relational Database Design by ER and EER-to-
Relational Mapping, Functional Dependencies and Normalization, SQL-
The Relational Database Standard, Relational Algebra. The practical
part for this course is covered in the lab course (CIS 260L).
1. Define and understand the main concepts and terms of the
database systems.
2. Design a conceptual database schema using the ER conceptual
data models.
Course Objectives
3. Design a logical (relational) database schema using Relational data
models.
4. Construct and manipulate the relational database using basic
Basic SQL commands.
Course Learning Outcomes CLO1: Define and understand the main concepts and terms of
(CLOs) database systems and the database analysis and design. (8%) [PLO 2].
CLO2: Show how to design a conceptual database schema using the
ER conceptual data model. (25%) [PLO 7].
CLO3: . (35%) [PLO 2 and PLO 7].
A. Introduce the main concepts and terms of the relational data

Page 1 of 7
 Yarmouk University

Faculty of Computer Science and

Information Technology
Document Approval Date Document Code
Course Syllabus
AP01-PR05

model.
B. Show how to map and Design a logical (relational) database
schema using the rules and constraints of the Relational data
model and
C. Show how to enhance the quality of the relational database
schema using the normalization process
CLO4: (32%) [PLO 7].
A. Explain the data definition commands of SQL and show how to
construct a database using this database language.
B. Explain the data manipulation commands of SQL and show
how use these commands in updating the database and
retrieving the data.
2. Design, implement, and evaluate a computing-based solution to
meet a given set of computing requirements in the context of
Addressed Program Learning Computer Information Systems.
Outcomes (PLO)
7. Design, implement, and use of data management, analysis and
retrieval solutions.

Mapping Course Learning Outcomes CLOs to Program Learning Outcomes PLOs

PLO1 PLO2 PLO3 PLO4 PLO5 PLO6 PLO7
CLO1 8%
CLO2 25%
CLO3 10% 25%
CLO4 32%

Page 2 of 7
 Yarmouk University

Faculty of Computer Science and

Information Technology
Document Approval Date Document Code
Course Syllabus
AP01-PR05

Assessment Methods
Assessment Type Date and Time Assessment Method )%( Mark CLOs
Midterm Exam TBA Exam 30 CLO1, CLO2, CLO3
Activity (1) Week 1-2 Review Questions 0 CLO1
Activity (2) Week-4 Homework-1 2 CLO 2
Activity (3) Week-5 Quiz-1 4 CLO 2
Activities*
Activity (4) Week-8 HomeWork-2 2 CLO3
Activity (5) Week-9 Quiz-2 4 CLO 3
Activity (7) Week-12 Quiz-3 4 CLO 4
Final Exam Exam 50 CLO2, CLO3, CLO4
 Attendance counts for 4% of the total grade
*The instructor must choose at least three activities from the following: quizzes, assignments, projects, videos, discussions, etc.

Course Contents, Schedule, and Instruction Methods

Week Course Content **Instruction Method
UNIT 01: Introduction to Database Systems
 Basic Definitions and Types of Databases,
Database Applications, and database system
 DBMS Functionality Face-to-face class
 Example of a Database (UNIVERSITY) Lecture, Discussion, Active
Week 1-2
 Main Characteristics of the Database Approach learning, and Integrating
 Advantages of Using the Database Approach Technology
 Database Users
 Data Models, Schemas, Instances, and States
 Database Languages, Utilities and Tools
Week 3 - 5 UNIT 02: Conceptual Data Modeling Using The Face-to-face class
Entity-Relationship (ER) Modeling Language Lecture, Discussion, Active
 ER Model Concepts and notation learning, and Integrating
- Entities and Attributes Technology
- Entity Types, Value Sets, and Key Attributes
- Relationships and Relationship Types
- Weak Entity Types
- Roles and Attributes in Relationship Types
 Example Database Application (COMPANY)
 ER Diagram for COMPANY Schema
 Alternative ER Notations for Constraints

Page 3 of 7
 Yarmouk University

Faculty of Computer Science and

Information Technology
Document Approval Date Document Code
Course Syllabus
AP01-PR05

Course Contents, Schedule, and Instruction Methods

Week Course Content **Instruction Method
 Subentities and Superentities: concepts and
modeling notation.
Week 6 - 9 UNIT 03 Part-1: Logical Data Modeling Using The Face-to-face class
Relational Data Model Lecture, Discussion, Active
 Logical Database Design learning, and Integrating
Technology
 Relational Data Model Concepts
- The Relational Model
- The Relation Concept
- Primary Key
- Relation Schema and Database Schema
- Attributes and Values
- Relation and Database State
 Relational Integrity Constraints
 Database Operations
UNIT 03 Part-2: Logical Data Modeling Using The
Relational Data Model
 Mapping ER Database Schema to a Relational
Database Schema
 Mapping of Regular Entity Types
 Mapping of Weak Entity Types
 Mapping of Binary 1:1 Relationship Types
 Mapping of Binary 1:N Relationship Types.
 Mapping of Binary M:N Relationship Types.
 Mapping of Multivalued attributes.
 Mapping of N-ary Relationship Types.
 Mapping Specialization Subentities
UNIT 03 Part-3: Functional Dependencies and
Normalization of Relational Databases
 Informal Design Guidelines for Relational
Databases
- Semantics of the Relation Attributes
- Redundant Information in Tuples and Update
Anomalies
 Functional Dependencies (FDs)
- Definition of FD
- Inference Rules for FDs
 Normal Forms Based on Primary Keys
- Normalization of Relations
- Practical Use of Normal Forms

Page 4 of 7
 Yarmouk University

Faculty of Computer Science and

Information Technology
Document Approval Date Document Code
Course Syllabus
AP01-PR05

Course Contents, Schedule, and Instruction Methods

Week Course Content **Instruction Method
- Definitions of Keys and Attributes
Participating in Keys
- First Normal Form
- Second Normal Form
- Third Normal Form
UNIT 04 Part-1: Database Programming Using SQL:
Data Definition and Update Commands
 Introduction
 CREATE TABLE Command in SQL
 Domains and Data Types in SQL
 Specifying Constraints in SQL
- Key and Entity constraints
- Domain Constraints
- Foreign Key Constraints
 Update Commands in SQL: INSERT, DELETE, Face-to-face class
Week 10 - 14 and UPDATE Lecture, Discussion, Active
learning, and Integrating
Technology
UNIT 04 Part-2: Database Programming Using SQL:
Retrieval Query Commands
 Introduction
 SQL Basic Query Structure: Queries from One
Table
 Queries from Multiple Tables
- Join Queries
- Set Queries
 Arithmetic and Aggregate Functions in SQL

Week 16 Final Exam Week

**Instruction method is as follows:
 Face-to-Face course: Face-to-face class
 Online course: Interactive synchronous or asynchronous
 Blended course: Face-to-face or Online (synchronous or asynchronous)

Main Textbook and References

Fundamentals of Database Systems, 7th ed., Ramez Elmasri, and Shamkant B.
Main Textbook
Navathe., Addison – Wesley.
Other References

Page 5 of 7
 Yarmouk University

Faculty of Computer Science and

Information Technology
Document Approval Date Document Code
Course Syllabus
AP01-PR05

Policies and Instructions

***

It is compulsory for students to attend at least 85% of the whole time

allocated to the course. More than four (4) unjustified absences from the
Attendance
lecture OR more than two (2) unjustified absences from the lab will make
you ineligible to attend the final exam.
Students are informed about the date of their quizzes. No makeup exam
will be offered for those who do not attend a quiz.
Activities
Students are expected to solve their assignments and submit them on due
time.
Late Submission Late submission may not be accepted.
Exams are closed books. Students who did not attend the first/second
Exams exam due to exceptional situations (for e.g., medical emergency) will be
given a makeup exam.
All forms of academic dishonesty will result in 35 grade for the course and
notification of the Dean of Student Affairs and the University Disciplinary
Coping from others in Board. Academic dishonesty includes (but is not limited to) copying
the exams or another answers or work done by others and use of notes or other aids during
activities quizzes and exams.
Student caught cheating will be awarded a 0 in the exam and may be
subject to university disciplinary actions.
***For more information, please see the student handbook.

Assessment

Assessment Method Expected Due Date Weight

Midterm Exam TBA (all sections) 30%

Class Attendance 4%
3 quizzes during the
Quizzes 12 %
semester as given above
2 assignments during the
Assignment 4%
semester as given above
Final Exam TBA (all sections) 50 %

Page 6 of 7
 Yarmouk University

Faculty of Computer Science and

Information Technology
Document Approval Date Document Code
Course Syllabus
AP01-PR05

Topics Covered

Topic Chapter(s) in Contact

Textbook Hours

UNIT 01: Introduction to Database Systems 1, 2 5

Review Questions 1

UNIT 02: Conceptual Data Modelling Using The Entity-

3, 4 8
Relationship (ER) Modeling Language

Review Questions, Homework – 1, and Quiz-1 1

Midterm Exam (tentative) 1

UNIT 03 Part-1: Logical Data Modelling Using The Relational

5 5
Data Model: Introducing the Model

UNIT 03 Part-2: Logical Data Modelling Using The Relational

9 5
Data Model: Mapping

UNIT 03 Part-3: Functional Dependencies and Normalization

14 4
of Relational Databases

Review Questions, Homework – 2, and Quiz-2 1

UNIT 04 Part-1: Database Programming Using SQL: Create

8 5
and Update

Review, Homework-3, and Quiz-3 1

UNIT 04 Part-3: Database Programming Using SQL:

6, 7 6
Retrieval Queries

Final Exam TBA 2

TOTAL 45 hrs

Page 7 of 7