Al-Ahliyya Amman University ‫جامعة عمان الأهلية‬

Faculty of Information Technology

Course Syllabus

General Information:
Faculty Information Technology Department Computer Science

Academic Year 2024-2025 Semester First

Course Information:
Course Title Fundamentals of Database Course Code A0312401
(A0311202) Introduction to (A0312402) Fundamentals of
Pre-requisite Co-requisite
Programming Database Lab
Credit Hours Designation
3 Req.
(Theory, Practical) (Req. or Elec.)
Section 1: 12:00-13:00 Sun, Tue, Th
Course Day/Time Section 2: 09:00-10:00 Sun, Tue, Th Course Day/Time Section 1, 2, 3 1205
Section 3: 10:30- 12:00 Mon, Wen
Web Address Web Address

Instructor/Coordinator Information:
Section 2 and Section 3:
Instructor Name Instructor Name [Link]@[Link]
Dr. Roqia Shorman
02:00-3:00: Sun, Tue.
Office No. 1305 Office Hours
09:00-10:30: Mon. Wed.

Course Description:
This course introduces the basics of database systems, Data Modeling using ER and EER; Database Mapping,
Database Integrity Constraints; Relational Model: Relational algebra, Relational Calculus; Normalization. At
the end of this course, a student will be able to understand and apply the fundamental concepts required for
the use and design of database systems. Topics include basic concepts and terminology of the database
approach, data modeling (the entity relationship model, relational data model), database design theory (entity
relationship
to relational mappings, normalization using functional dependencies).
References:
Textbook(s): Author, A. A. (Year published). Book title (Edition). City, State: Publisher.
El Masri and Navathe (2016). Fundamentals of Database Systems (7th Edition). Boston, USA: Addison Wesley.

‫نموذج تجريبي‬

1-7
 Al-Ahliyya Amman University ‫جامعة عمان الأهلية‬

Faculty of Information Technology

Other Required Material(s):

1. Thomas Connolly and Carolyn Begg

(2014). DatabaseSystems: A Practical Approach to
Design, Implementation, and Management (Sixth Edition). Boston, USA: Addison Wesley.
2. Silberschatz, H. Korth and S. Sudarshan (2010). Database System Concepts (Sixth Edition). Mc Graw Hill.
Online Resources:
[Link]/cssupport
[Link]/connbegg
[Link]

Course Objectives (CO):

Upon successful completion of this course students will be able to:
1 Explain the role of database users and features of database systems, and architecture of database systems.
2 Explain the main issues related to the design and use of structured data.
Construct conceptual (E/R & EER, Mapping and Normalization) and logical data models applying database
3
design principles.
4 Evaluate data redundancy levels and their impact on database integrity and maintainability.
5 Implement a database using DBMS.
Add new rows if needed…

Course Learning Outcomes:

Upon successful completion of this course students will be able to:

CLO 1 Comprehend the Concepts and Theories of Database

CLO 2 Able to Design database and Implement the SQL Query

CLO 3 Function Effectively as a Team Member or Leader in Project Creation

Program Learning Outcomes:

PLO # 1
Apply computer science theory and software development fundamentals to produce
computing-based solutions.
Design, implement, and evaluate a computing-based solution to meet a given set of
PLO # 3
computing requirements in the context of the program’s discipline.
PLO # 6
Function effectively as a member or leader of a team engaged in activities appropriate to the
program’s discipline.

‫نموذج تجريبي‬

2-7
 Al-Ahliyya Amman University ‫جامعة عمان الأهلية‬

Faculty of Information Technology

Level Descriptions of PLOs and CLOs

Level Descriptions
PLO # CLO # Knowledge Skills Competencies
1.1, 1.2 1 √
3.1, 3.2, 3.3 2 √
6.1, 6.2 3 √

Topics and Timeline of the Course:

Assignments/
Week # Topic Quizzes/ Project/ Reference CO
Exams Due
Unit 1: Databases and Database Users
 Introduction
 An Example
 Characteristics of the Database Approach
Week 1 Power Point slides
 Database Users
Ch.1
 Advantages of using DBMS Approach 1
 A brief history of database applications

Unit 2: Database System Concepts and Architecture

Models
 Data Models, Schemas, and Instances Power Point slides
 ANSI-SPARC three level Architecture and Data 1
Independence Ch.2
Week 2  Database Languages and Interfaces
 The Database System Environment
 Centralized and Client/Server Architecture(C/S) of
DBMSs
 Classification of DBMSs

Unit 3 : Relational Model Concepts and Constraints

 Relational Model Concepts
 Relational Model Constraints and Relational
Week 3, Database Schemas Quiz#1 Ch.5 2, 3
4, 5  Update operations and Dealing with Constraint Violations
Strategies (Cascade, Restrict, Set to Null, No Action)
SQL DDL
 Create Table
 Drop Table
 Select
‫نموذج تجريبي‬

3-7
 Al-Ahliyya Amman University ‫جامعة عمان الأهلية‬

Faculty of Information Technology

Midterm Test
Unit 4: Data Modeling Using the Entity-Relationship Model
 Using High-Level Conceptual Data Models for
Database Design
Week 6,  An Example Database Application Ch.3 3
7, 8  Entity Types, Entity Sets, Attributes, and Keys Assignment
Relationship Types, Relationship Sets, Roles, and
Structural Constraints #1
 Weak Entity Types
 ER Diagrams, Naming Conventions, and Design
Issues
 Practical Examples to convert from relational schema to ER
Diagrams and vice versa
SQL DDL
 Alter table: Add column, Drop Column, Modify Column-
Length, Datatype, Constraint
 Add constraint, drop constraint

Unit 5: Relational Database Design by ER- to- Relational

Mapping
 Relational Database Design by ER- to-Relational 3, 4
Ch. 9
Week 9, 10 Mapping
Quiz#2
 Practical Examples to convert from relational schema
 to ER Diagrams and vice versa.

SQL DDL
 Insert into table
 Update
 Delete
 Rollback
 Commit
 SavePoint

Unit 6: Database Design

 Informal Design Guidelines for Relation Schemas
 Functional Dependencies Assignment
Week 11,  Normal Forms Based on Primary Keys Ch. 14
 General Definitions of Second and Third Normal #2 4
12
Forms
 Boyce Codd normal Form
SQL DDL
 Select from where
 Single-Row Functions
 Number functions
 Date functions
 Multi-Row Functions
 Joins

Unit 7: Case studies and practical applications

Week 13, Case Studies 5
 Developing Database applications from design to
14, 15 completion Discussions
 Discussion of projects

4-7
 Al-Ahliyya Amman University ‫جامعة عمان الأهلية‬

Faculty of Information Technology

Week 16 Final Exam

Assessment Methods: Outline the methodologies used to assess the students learning outcome

Methods Qty. Weight Description

Assignment 2 20 Class tasks and Home works
Exercises to be discussed at class which cover different concepts of
Quiz 2 10
RDBMS
Multiple choice questions, True/False, Short answers, Essay
Midterm Test 1 30
Questions
Multiple choice questions, True/False, Short answers, Essay
Final Exam 1 40
Questions
Total 100%

Mapping of Learning Outcomes with Assessment Methods:

Test/ Exam Assignments Quiz Case study
Midterm Final 1-2 1, 2 1
CLO 1, 2 1-3 2 2 3
3.1,3.2,3.2
PLO 1.1,1.2, 3.1, 3.2 1.1,1.2, 3.1, 3.2, 3.3 3.1, 3.2, 3.3 3.1, 3.2
6.1

Course Polices:

1. Class Attendance:
 The AAU recognizes that class attendance is an important element of students’ classroom success.
Students are expected to attend all classes, laboratories, and/or required fieldwork. Because excessive
absences prevent students from receiving full course benefit, and disrupt orderly course progress.

5-7
Al-Ahliyya Amman University ‫جامعة عمان الأهلية‬

Faculty of Information Technology

 Any student who misses MORE THAN 15% of the class sessions of any course during a semester will be
illegible to sit for the final exam and will receive a grade of “F” in the course.
 In the case (b) above, if a student submits an official documented evidence of inpatient medical care
authenticated by the Medical Services Department or an accepted excuse by the Dean of his/her faculty,
he/she will be considered as withdrawn from the course, and a "W" will be shown in the transcript for this
course.
 If you miss class, it is your responsibility to find out about any announcements or assignments you may
have missed.
2. Tardy: Students are not allowed to come late to classes. If a student is ten (10) minutes or more late he/she will
be reported absent.
3. Exams:
 Failure in attending a course exam other than the final exam will result in zero mark unless the student
provides an official acceptable excuse to the instructor who approves a makeup exam.
 Failure in attending the final exam will result in zero mark unless the student presents an official acceptable
excuse to the Dean of his/her faculty who approves an incomplete exam, normally scheduled to be
conducted during the first two weeks of the successive semester.
 A student who is late more than 15 minutes will not be permitted to sit the exam (midterm exams).
 A student who is late more than 30 minutes will not be permitted to sit to final exam, and no student will
be permitted to leave the exam center before the elapse of 30 minutes.
 No makeup exam will be given unless all of the following three steps are performed: (1) The student
notifies the course instructor about the reasons for missing the exam at least 24 hours after the set exam
date, (2) The instructor permits the makeup exam at another date and lists the papers (medical or otherwise)
required for the makeup, and (3) The student submits the required papers.
4. Assignments & Projects: Assignments and projects should be submitted to the instructor on the due date. Zero
mark will be given for late submissions unless the student has an acceptable excuse approved by the instructor of
the course.
5. Plagiarism: The term “plagiarism” includes, but is not limited to:
 An attempt of an individual to claim the work of another as the product of his/her own thoughts, regardless
of whether that work has been published.
 Quoting improperly or paraphrasing text or other written materials without proper citation on an exam,
term paper, homework, or other written material submitted to an Instructor as one's own work.
 Handing in a paper to an Instructor that was purchased from a term paper service or downloaded from the
Internet and presenting another person's academic work as one's own.
6. Cheating: The term “cheating,” includes but is not limited to:
 Copying homework assignments from another student.
 Working together with another individual on a take-home test or homework when specifically prohibited
from doing so by the instructor.

‫نموذج تجريبي‬

6-7
Al-Ahliyya Amman University ‫جامعة عمان الأهلية‬

Faculty of Information Technology

 Looking at and/or copying text, notes or another person's paper during an examination when not permitted
to do so.
 Giving of work information to another student to be copied and/or used as his/her own.
 Giving someone answers to exam questions either when the exam is being given or after having taken an
exam.
 Informing another student of specific questions that appear or have appeared on an exam in the same
academic semester.
 Giving or selling a term paper, report, project or other restricted written materials to another student.
7. Penalty for Cheating: The minimum penalty for cheating is an automatic Zero for the test or assignment leading
to a possible “F” for the course. The exam invigilator will produce a report on the case to the examination
committee chairman. The report will be kept in the student file. The student may remain seated in the exam center,
but in case that causes a disturbance to other students, the student will be expelled out of the exam center if
approved by the examination committee chairman. A second offense will result in the immediate suspension of
the student for the remainder of the current semester. A copy of the decision will be kept in the student file.
8. Mobile Phones: All mobile phones and/or other communication devices should be turned off before entering the
classroom.

Responsible Staff Signature:

Course Instructor/
Prof. Qasem Kharma Date 14/10/2024 Signature
Coordinator
Head of Department Date Signature

‫نموذج تجريبي‬

7-7