Institute of Computer Science KFUEIT
Sixteen Week Teaching Plan
Course Title & Course Code Database Systems / COSC-2103
Credit Hours 03
Pre-Requisite(s), if any
Department / Institute Computer Science
Faculty Information Technology
Program/semester/section BS-Computer Science
BOS Meeting # and Date 9th BOS Meeting, 08-Aug-2023
Week 1
Course Learning 1. Explain fundamental database concepts.
Outcome (CLO)
Contents / Sub Introduction:
Contents • Introduction to Data, Information
• Databases and Database Management System.
• Traditional File Based Systems,
• File Based Approach, Limitations of File Based Approach.
• Database Approach,
• Data Base Management System
• Components of DBMS
• Roles in DB Environment
• Advantages / Disadvantages of DBMS
Week 2
Course Learning 1. Explain fundamental database concepts.
Outcome (CLO) 2. Design conceptual, logical and physical database schemas using different data
models.
Contents / Sub Database Environment:
Contents • Three Level ANSI-SPARC Architecture
• External Level, Conceptual Level, Internal Level
• Schemas
• Mappings and Instances
• Data Independence
Week 3
Course Learning 1. Explain fundamental database concepts.
Outcome (CLO) 2. Design conceptual, logical and physical database schemas using different data
models.
Contents / Sub The Relational Model Part 1:
Contents • Brief History of the Relational Model
• Relational Data Structure – Relation, Attribute, Domain, Tuple, Degree,
Cardinality
• Relational Database
• Mathematical Relations
• Database Relations
• Relational Schema
Institute of Computer Science KFUEIT
• Relational Database Schema
• Properties of Relations
Week 4
Course Learning 1. Explain fundamental database concepts.
Outcome (CLO) 2. Design conceptual, logical and physical database schemas using different data
models.
Contents / Sub The Relational Model Part 2:
Contents • Relational Keys –
• Super Key, Candidate Key, Primary Key, Foreign Key
• Summary of Relational Database Schemas
• Integrity Constraints –
• Nulls
• Entity Integrity
• Referential Integrity
• General Constraints
Week 5
Course Learning 1. Explain fundamental database concepts.
Outcome (CLO) 2. Design conceptual, logical and physical database schemas using different data
models.
Contents / Sub Relational Algebra
Contents • Relational Algebra
• Unary Operations – Selection, Projection
• Set Operations – Union
• Set Operations – Set Differences,
• Intersection,
• Cartesian Product
• Join Operations
• Theta Join, Equijoin, Natural Join, Outer join, Semi join, Division Operation
Week 6
Course Learning 1. Explain fundamental database concepts.
Outcome (CLO) 2. Design conceptual, logical and physical database schemas using different data
models.
Contents / Sub SQL: Data Manipulation
Contents • Introduction to SQL
• Writing SQL Commands
• Data Manipulation
• Simple Queries
• Sorting Results (Order BY Clause)
• SQL Aggregate Functions
Week 7
Course Learning 4. Using Structured Query Language (SQL) for database definition and manipulation in
Outcome (CLO) any DBMS.
Contents / Sub SQL: Data Manipulation continued
Contents • Grouping Results (Group BY Clause)
• Subqueries
• ANY and ALL
Institute of Computer Science KFUEIT
• Multitable queries
• EXISTS and NOT EXISTS
• Combining Result Tables (Union, Intersect, EXCEPT)
Week 8
Course Learning 1. Explain fundamental database concepts.
Outcome (CLO) 2. Design conceptual, logical and physical database schemas using different data
models.
3. Identify functional dependencies and resolve database anomalies by normalizing
database tables.
Contents / Sub • Course Review, Quiz
Contents
Week 9
Course Learning 4. Using Structured Query Language (SQL) for database definition and manipulation
Outcome (CLO) in any DBMS.
Contents / Sub SQL: Data Definition
Contents • ISO SQL Data Types
• Creating a Database
• Creating a Table (CREATE TABLE)
• Changing a Table (ALTER TABLE)
• Removing a Table (DROP TABLE)
• Creating an Index (CREATE INDEX)
• Removing an Index (DROP INDEX)
Week 10
Course Learning 4. Using Structured Query Language (SQL) for database definition and manipulation
Outcome (CLO) in any DBMS.
Contents / Sub Views:
Contents • Introduction
• Creating a View (CREATE VIEW)
• Removing a View (DROP VIEW)
• Stored Procedures
• Triggers
Week 11
Course Learning 2. Design conceptual, logical and physical database schemas using different data
Outcome (CLO) models.
3. Identify functional dependencies and resolve database anomalies by normalizing
database tables.
Contents / Sub Normalization:
Contents • Introduction to Normalization,
• The Purpose of Normalization
• Normalization Supports Database Design
• Data Redundancy and Update Anomalies
• Insertion Anomalies
• Deletion Anomalies
• Modification Anomalies
Institute of Computer Science KFUEIT
• Functional Dependencies – Characteristics
• Identifying Functional Dependencies
Week 12
Course Learning 2. Design conceptual, logical and physical database schemas using different data
Outcome (CLO) models.
3. Identify functional dependencies and resolve database anomalies by normalizing
database tables.
Contents / Sub Process of Normalization:
Contents • First Normal Form
• Second Normal Form
Third Normal Form
Week 13
Course Learning 2. Design conceptual, logical and physical database schemas using different data
Outcome (CLO) models.
3. Identify functional dependencies and resolve database anomalies by normalizing
database tables.
Contents / Sub Entity-Relationship Modeling:
Contents • Entity Types
• Relationship Types
• Degree of Relationship Type
• Recursive Relationship
• Attributes
• Simple and Composite Attributes
• Single valued and Multivalued Attributes
• Derived Attributes
• Strong and Weak Entity Types
Week 14
Course Learning 2. Design conceptual, logical and physical database schemas using different data
Outcome (CLO) models.
Contents / Sub Entity-Relationship Diagram:
Contents • Entity Relation Diagram
• Tool for E-R Diagram
• Structural Constraints
• Relationships
• One to One
• One to Many
• Many to Many
Week 15
Course Learning 2. Design conceptual, logical and physical database schemas using different data
Outcome (CLO) models.
3. Identify functional dependencies and resolve database anomalies by normalizing
database tables.
Contents / Sub Concurrency & Locking:
Contents • Concurrency, what is Concurrency
• Concurrency Control
• Need for Concurrency Control
Institute of Computer Science KFUEIT
• Concurrency Control Techniques
• Locking Methods
Week 16
Course Learning 1. Explain fundamental database concepts.
Outcome (CLO) 2. Design conceptual, logical and physical database schemas using different data
models.
3. Identify functional dependencies and resolve database anomalies by normalizing
database tables.
4. Using Structured Query Language (SQL) for database definition and manipulation
in any DBMS.
Contents / Sub Revision and Final Discussion about the course
Contents
Curriculum Contents: Introduction to Problem Solving, Introduction to Programming, Role of Compiler
and Linker, Introduction to Algorithms, Basic Data Types and Variables, Input/Output Constructs, Arithmetic,
Comparison and Logical Operators, Conditional Statements and Execution Flow for Conditional Statements,
Repetitive Statements and Execution Flow for Repetitive Statements, Array and Their Memory Organization,
Multi-Dimensional Arrays, Introduction to Modular Programming, Function Definition and Calling,
Recursion, String and String Operations, Structures.
