Course Title: Concepts of Database Systems

Course Code: CIS 322

Program: B.Sc. in Computer Science
Department: Computer Science
College: Computer and Information Sciences
Institution: Jouf University
Table of Contents
A. Course Identification .................................................................................................... 3
6. Mode of Instruction (mark all that apply) ............................................................................... 3
B. Course Objectives and Learning Outcomes ............................................................... 3
1. Course Description ................................................................................................................. 3
2. Course Main Objective............................................................................................................ 4
3. Course Learning Outcomes ..................................................................................................... 4
C. Course Content ............................................................................................................. 4
D. Teaching and Assessment ............................................................................................ 5
1. Alignment of Course Learning Outcomes with Teaching Strategies and Assessment
Methods ....................................................................................................................................... 5
2. Assessment Tasks for Students ............................................................................................... 6
E. Student Academic Counseling and Support .............................................................. 6
F. Learning Resources and Facilities............................................................................... 6
1.Learning Resources .................................................................................................................. 6
2. Facilities Required................................................................................................................... 6
G. Course Quality Evaluation .......................................................................................... 7
H. Specification Approval Data ....................................................................................... 7

2
A. Course Identification

1. Credit hours: 4
2. Course type
a. University College Department Others
b. Required Elective
3. Level/year at which this course is offered:
Level 8 / 3nd year
4. Pre-requisites for this course (if any):

Data Structures (CIS 205)

5. Co-requisites for this course (if any):

6. Mode of Instruction (mark all that apply)

No Mode of Instruction Contact Hours Percentage
1 Traditional classroom 33 50%
2 Blended
3 E-learning
4 Distance learning
5 Other 33 50%

7. Contact Hours (based on academic semester)

No Activity Contact Hours
1 Lecture 33
2 Laboratory/Studio 33
3 Tutorial
4 Others (specify)
Total 66

B. Course Objectives and Learning Outcomes

1. Course Description
The objective of this course is to introduce students to database basic concepts. Topics
include ER/EER Model, Relational Model. Mapping from ER/ERR model to Relational
Model, Functional Dependencies and Database Normalization. The Relational Algebra,
SQL.

3
2. Course Main Objective

• Define Database basic concepts

• Describe Data Models, Schemas, Instances, Three Schema Architecture
• Define the Relational Data Model, the Relational Database Schema.
• Mapping a conceptual Data Model (Er/EER) to relational schema.
• Demonstrate the use of SQL for Database creation and modification
• Design Queries in relational Algebra.
• Illustrate the definition of Functional Dependency.
• Review the Three first Normal Forms based on Partial and transitive
dependencies.
• Apply normalization techniques to DB.

3. Course Learning Outcomes

Aligned
CLOs
PLOs
1 Knowledge and Understanding
1.1 Recall the fundamental concepts of a database system. K1
2 Skills:
2.1 Analyze database requirements and determine the entities involved in the S1
system and their relationship to one another and develop the logical
design of the database using data modeling concepts such as entity-
relationship diagrams.
2.2 Implement and set integrity constraints using SQL. S2
3 Values:
3.1 Recognize the ethical computing concepts and practices to database V1
design and implementation. related to Database design

C. Course Content
Contact
No List of Topics
Hours
Introduction to Databases
Introduction
Characteristics of the Database Approach
Actors on the Scene
1 Workers behind the Scene 6
Advantages of Using the DBMS Approach
A Brief History of Database Applications
When Not to Use a DBMS
Database System Concepts and Architecture 6
Data Models, Schemas, and Instances
Three-Schema Architecture and Data Independence
2 Database Languages and Interfaces
The Database System Environment
Centralized and Client/Server Architectures for DBMSs
Classification of Database Management Systems
Data Modeling Using the Entity-Relationship (ER) Model 6
Using High-Level Conceptual Data Models for Database Design
A Sample Database Application
3 Entity Types, Entity Sets, Attributes, and Keys
Relationship Types, Relationship Sets, Roles, and Structural Constraints ,
Weak Entity Types
Data Modeling Using the Entity-Relationship (ER) Model 6
4 Refining the ER Design for the COMPANY Database

4
ER Diagrams, Naming Conventions, and Design Issues
Example of Other Notation: UML Class Diagrams
Relationship Types of Degree Higher than Two
The Relational Data Model and Relational Database constraints 6
Relational Model Concepts
5 Relational Model Constraints and Relational Database Schemas
Update Operations, Transactions, and Dealing with Constraint Violations
The Relational Data Model and Relational Database constraints 6
Translating ERD into Schema
6 Translating Schema into ERD
Case study
Basic SQL 6
SQL Data Definition and Data Types
Specifying Constraints in SQL
7 Basic Retrieval Queries in SQL
INSERT, DELETE, and UPDATE Statements in SQL
Additional Features of SQL
More SQL: Complex Queries, Triggers, Views, and Schema Modification 6
More Complex SQL Retrieval Queries
8 Specifying Constraints as Assertions and Actions as Triggers
Views (Virtual Tables) in SQL
Schema Change Statements in SQL
The Relational Algebra 6
Unary Relational Operations: SELECT and PROJECT
9 Relational Algebra Operations from Set Theory

The Relational Algebra 6

Binary Relational Operations: JOIN and DIVISION
10 Additional Relational Operations
Examples of Queries in Relational Algebra
Functional Dependencies and Normalization for Relational Databases 8
Informal Design Guidelines for Relation Schemas
Functional Dependencies
11 Normal Forms Based on Primary Keys
General Definitions of Second and Third Normal Forms
Boyce-Codd Normal Form
Total 66

D. Teaching and Assessment

1. Alignment of Course Learning Outcomes with Teaching Strategies and Assessment
Methods
Code Course Learning Outcomes Teaching Strategies Assessment Methods
1 Knowledge and Understanding
1.1 Recall the fundamental concepts of a ● Lectures ● Exams
database system. ● Handouts ● Homework
● Quizzes
2 Skills:
2.1 Analyze database requirements and ● Lectures ● Exams
determine the entities involved in the ● Lab activity ● Homework
system and their relationship to one ● Class discussion ● Lab exam
another.
2.2 ● Lectures ● Exams
Implement and set integrity constraints
● Lab activity ● Homework
using SQL.
● Lab exam
3 Values:
3.1 Recognize the ethical computing ● Lectures ● Rubric-based
concepts and practices to database ● Class discussions project report
● Group work

5
Code Course Learning Outcomes Teaching Strategies Assessment Methods
design and implementation. related to ● Graded class
Database design discussions

2. Assessment Tasks for Students

Percentage of Total
# Assessment task* Week Due Assessment Score
1 Homework 5 5%
2 Quiz 9 5%
3 Midterm-1 Exam 7 15%
4 Midterm-2 Exam 10 15%
5 Project 11 10%
6 Lab 11 10%
7 Final Exam 12 40%
*Assessment task (i.e., written test, oral test, oral presentation, group project, essay, etc.)

E. Student Academic Counseling and Support

Arrangements for availability of faculty and teaching staff for individual student
consultations and academic advice :

6 office hours in each week.

F. Learning Resources and Facilities

1.Learning Resources
Fundamentals of Database Systems, by Ramez Elmasri and Shamkant
Required Textbooks B. Navathe. Pearson; 7th Edition (2015). ISBN-10: 0133970779,
ISBN-13: 978-0133970777.
Essential References
Materials

Electronic Materials

Other Learning
Materials

2. Facilities Required
Item Resources
Accommodation
(Classrooms, laboratories, demonstration Classroom (32 seats)
rooms/labs, etc.)
Technology Resources A white board, overhead projector, computer and
(AV, data show, Smart Board, software, etc.) internet connection.
Other Resources

6
Item Resources
(Specify, e.g. if specific laboratory equipment
is required, list requirements or attach a list)

G. Course Quality Evaluation

Evaluation
Evaluators Evaluation Methods
Areas/Issues
Developing a course portfolio that
includes everything about the course in Instructor direct

Student Feedback on effectiveness of

Students direct
Teaching
Evaluation areas (e.g., Effectiveness of teaching and assessment, Extent of achievement of course learning
outcomes, Quality of learning resources, etc.)
Evaluators (Students, Faculty, Program Leaders, Peer Reviewer, Others (specify)
Assessment Methods (Direct, Indirect)

H. Specification Approval Data

Council / Committee CS Department committee
Reference No. 15th
Date 28/02/2022