Institute of Computer Science KFUEIT
Sixteen Week Teaching Plan
Course Title & Course Code Database Systems-Lab / COSC-2203
Credit Hours 01
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 • Databases
Contents • What is SQL Server
• T-SQL & PL-SQL
• Brief History of SQL
• Installation of SQL Server
• SQL Server Instances
• Introduction to SQL Server Graphical User Interface (GUI)
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 • How to create Database and Data Tables
Contents • Primary key and Foreign key
• Datatypes in SQL
• Components of SQL
• SQL is a RDBMS
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 • Data Definition Language
Contents • Creating Database using query
• Create, Alter, Drop table using Query
• Sql Constraints on Columns & Tables
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 • Table Level Constraint
Contents • Data Manipulation Language
• DML Queries
• Select Query
Institute of Computer Science KFUEIT
• Calculated Fields
• Use of As & Where
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 • Search with comparison Operators
Contents • Use of Between/Not Between
• Use of IN / NOTIN
• Use of LIKE/NOTLIKE
• Use of IS NULL/IS NOT NULL
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 • AND & OR Operator
Contents • Auto increment field in SQL Server
• ORDER BY Clause
• Single Column
• Multiple Column
• SQL Aggregate Functions
o COUNT
o SUM
o AVG
o Max
o Min
Week 7
Course Learning 4. Using Structured Query Language (SQL) for database definition and manipulation in
Outcome (CLO) any DBMS.
Contents / Sub • String Concatenation
Contents • GROUP BY Clause
• HAVING Clause
• Difference b/w HAVING & WHERE
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.
4. Using Structured Query Language (SQL) for database definition and manipulation
in any DBMS.
Contents / Sub • Course Review, Quiz
Contents
Week 9
Course Learning 2. Design conceptual, logical and physical database schemas using different data
Outcome (CLO) models.
4. Using Structured Query Language (SQL) for database definition and manipulation
in any DBMS.
Institute of Computer Science KFUEIT
Contents / Sub • Sub Queries
Contents • Types of Sub queries
Week 10
Course Learning 2. Design conceptual, logical and physical database schemas using different data
Outcome (CLO) models.
4. Using Structured Query Language (SQL) for database definition and manipulation
in any DBMS.
Contents / Sub • Querying Multiple Table
Contents • Table Aliases
• Joins
• Inner Join
• Adding Additional Clauses
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
Contents • SELECT INTO Statement
• Union
• Intersect
• Except Query
• Database Updates
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 • Roll back or Commit transaction
Contents • Stored Procedures
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 • Views
Contents • Indexes
Week 14
Course Learning 2. Design conceptual, logical and physical database schemas using different data
Outcome (CLO) models.
Contents / Sub • Back up a Database
Contents • Restore a Database
• Database Triggers
Week 15
Institute of Computer Science KFUEIT
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 • Database Triggers
Contents • Project Discussion
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: Databases, SQL Server, T-SQL & PL-SQL, History of SQL, SQL Server Instances,
Introduction to SQL Server Graphical User Interface (GUI), Data Definition Language(DDL), Creating
Database using query, Create, Alter, Drop table using Query, Sql Constraints on Columns & Tables, Table
Level Constraint, Data Manipulation Language(DML), DML Queries, Select Query, Calculated Fields, Use of
As & Where, Search with comparison Operators, Use of Between/Not Between, Use of IN / NOTIN, Use of
LIKE/NOTLIKE, Use of IS NULL/IS NOT NULL, AND & OR Operator, Auto increment field in SQL Server,
ORDER BY Clause, Single Column, Multiple Column, SQL Aggregate Functions, Sub Queries, Types of Sub
queries, Querying Multiple Tables, Table Aliases, Joins, Inner Join, Adding Additional Clauses, SELECT
INTO Statement, Union, Intersect, Except Query, Roll back or Commit transaction, Stored Procedures, Views,
Indexes, Back up a Database, Restore a Database, Database Triggers.
