Fundamentals of Database System

Republic of the Philippines
COTABATO FOUNDATION COLLEGE OF SCIENCE AND TECHNOLOGY

Barangay Doroluman, Arakan, Cotabato
Telefax No. (064) 577-1343
email address [email protected] website: www.cfcst.edu.ph
COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY
COURSE SYLLABUS (OBE)

First Semester 2020– 2021
Vision: CFCST: haven of intellectuals in 2023
Mission: CFCST shall endeavor to be a potent vehicle in uplifting the socio-economic status of its clientele and neighboring communities through the provision of custodial care services, access to
education and relevant training in science and technology.
Core Values: Culture-Sensitive; Adherent to Laws; Relevant and Responsive; Efficient and Effective; and Spiritually-oriented (CARES)
Course Name IT 211 FUNDAMENTALS OF DATABASE SYSTEM

Course Credit 3 units
This course is the first in a series of courses on designing and implementing database information systems.
Course Description
Contact Hours/week 5 hours ( 2 hours lecture, 3 hours Lab)

Prerequisite None
Program Educational Objectives.
1. Five years after graduation, the BSIT alumni will perform high level of technical expertise in the field of primary and secondary job roles.
Primary Job Roles
 Software engineer
 System Software Developer
 Research and Development Computing Professional
 Application Software Developer
 Computer Programmer
Secondary Job Roles

Form No. : FM -DPM- CFCST PRS—01
Issue Status 01
Revision No. 00
Date Effective : 30 September, 2017
Approved by : President

Telefax No. (064) 577-1343
 System Analyst
 Data Analyst
 Quality Assurance Specialist
 Software Support Specialist
2. After 5 years, the BSIT alumni will perform ethical conduct in the practice of computing professionalism.
Program Outcome Code Program Outcomes

PO1 Apply knowledge of computing, science, and mathematics appropriate to the discipline
PO2 Understand best practice and standards and their applications
PO3 Analyze complex problems, and identify and define the computing requirements appropriate to its solution
PO4 Identify and analyze user needs and take them into account in the selection, creation evaluation and administration of computer-based systems
PO5 Design, implement, and evaluate computer-based systems, processes , components or programs to meet desire needs and requirements under various constraints
PO6 Integrate IT-based solution into the user environment effectively
PO7 Apply knowledge through the use of current techniques, skills, tools and practices necessary for the IT profession
PO8 Function effectively as a member or leader of a development team recognizing the different roles within a team to accomplish a common goal
PO9 Assist in the creation of an effective IT project plan
PO10 Communicate effectively with the computing community and with society at large about complex computing activities through logical writing, presentations, and clear
instructions
PO11 Analyze the local and global impact of computing information technology on individuals, organizations, and society
PO12 Understand professional, ethical, legal, security and social issues and responsibilities in the utilization of information technology
PO13 Recognize the need for and engage in planning self-learning and improving performance as a foundation for continuing professional development
Course Outcome (Based on CMO for BS IT)

After completion of the course, the students should be able to: PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PO13
CO1 Gain an introductory background in indexing, concurrency control, and P P P P P P P P
Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
recovery
CO2 design effective database schemas for realistic applications P P P P P P P P
I – Introduce, P – Practice, D-Demonstrate
COURSE OUTLINE AND TIME FRAME (36 HOURS LECTURE, 54 HOURS LABORATORY)
Course Content/Subject Matter
Week 1
I. Orientation
II.
a. VGMO
b. Classroom policy
c. Requirement/s of the course
Week 1 UNIT I Introduction to Databases
1.1. Traditional file based systems and their limitations
Week 2 1.2. Database approach (DBMS) and its components

Week 3 1.3. Roles in the database environment
1.4. Advantages and disadvantages of database systems
Week 4 1.5. Distributed databases
Week 5 UNIT II The Relational Model
II.1. Definition of relational data structures, database relations, keys

Week 6 II.2. Representation of relational database schemas
Week 7 II.3. Relational Algebra

Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
Week 8 II.4. Relational integrity (entities and relationships)
Week 9 II.5. Views
MIDTERM EXAM
Week 10 UNIT III Structured Query Language
3.1. Introduction, objectives, terminology
Week 11 3.2. Data manipulation
Week 12 3.2.1. Querying, sorting, grouping of data
Week 13 3.2.2. Using logical and list operators

3.2.3. Single row numeric and string functions
Week 14 3.2.4. Group functions

3.2.5. Joins
Week 15 3.2.6. Sub-queries

3.2.7. Inserting, deleting and updating data.
Week 16 3.3. Data definition
3.3.1. Creating, altering and dropping database objects: tables, views, indexes, synonyms, constraints, users
Week 17 3.4. Creating Procedures and Functions
Week 18 3.5. Creating Database Triggers
FINAL TERM EXAM

Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
Pen and Paper Assessment

Authentic Assessment (Laboratory and Field Work) using Scoring Criteria developed by the whole class
Written Outputs (to be assessed using the Scoring Criteria developed by the whole class)
Quizzes/Assignments
Desired Learning Course Content/ Textbooks/ Teaching and Learning Activities Assessment Task Resource Time Table
Outcomes(DLO) Subject matter References (TLAs) (ATs) Materials
Theory Practice Assessment
Based Based Schedule
Upon successful Course Content/Subject Matter CFCST student Week 1
completion of this Manual PowerPoint Presentation CFCST
course, students will be I.Orientation CFCST student
able to: A.VGMO Operation Teacher-Centered Strategy (Lecture) handbook,
B.Classroom policy Manual operation
a. be oriented about C.Requirement/s of the course manual
the school’s VMGO
b. be informed about
classroom policies
and requirements of
the course.

Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
CO1 UNIT I Introduction to Fundamentals of Online modality using Learning Quiz Laboratory Internet Week 1
a. Explained different Databases Database management system activity Laptop
roles in the database I.1. Traditional file based Systems, Third Offline pdf Assignment LCD
environment systems and their limitations Edition PowerPoint Presentation projector
By:Ramez Teacher-Centered Strategy (Lecture Desktop PC
b. Discussed the Elmasri and Video conferencing software
DBMS components Shamkant B.
Navathe (2000)
c. Apply sample idea
to enhance Fundamentals of
traditional file base Database
system Systems seventh
edition
By: Ramez
Elmasri and
Shamkant B.
Navathe (2016)
CO2 1.2. Database approach (DBMS) ISBN-13: 978-0- Online modality using Learning Quiz Laboratory Internet Week 2
a. Understood the and its components 13-397077-7 management system activity Laptop
different roles 1.3. Roles in the database Offline pdf Assignment LCD
in database environment Fundamentals of PowerPoint Presentation projector
environment Database Teacher-Centered Strategy (Lecture Desktop PC
b. Discussed Systems Fourth Video conferencing software
different roles Edition
in database By: Ramez
admin Elmasri and
c. create sample Shamkant B. N
roles to avathe (2004)
manage Publisher:
database Pearson
CO1 1.4. Advantages and Education, Inc. Online modality using Learning Quiz Laboratory Internet Week 3
a. Explained the disadvantages of database ISBN 0-321- management system activity Laptop
advantage and systems 12226-7 Offline pdf Assignment LCD
disadvantage of PowerPoint Presentation projector
Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
database system Teacher-Centered Strategy (Lecture Desktop PC

b. Discussed the FREE “DB2 on Video conferencing software
significance of the Campus” books
database system in at
the company
c. Apply database www.ibm.com/d
design to optimized b2/books
data redundancies • Database
in the database Fundamentals
CO2 • Getting started Online modality using Learning Quiz Laboratory Internet Week 4
a. Understood 1.5. Distributed databases with DB2 management system activity Laptop
distributed database Express-C Offline pdf Assignment LCD
system • Getting started PowerPoint Presentation projector
b. Discussed the with IBM Data Teacher-Centered Strategy (Lecture Desktop PC
purpose of the Studio for DB2 Video conferencing software
distributed system • Getting started
in the company with DB2
c. Apply distributed application
system to stored development
data
CO2 UNIT II The Relational Model • SQL Online modality using Learning Quiz Laboratory Internet Week 5
a. Explained Fundamentals I management system activity Laptop
Relational Database 2.1. Definition of relational data • DB2 Essential Offline pdf Assignment LCD
structure structures, database Training I PowerPoint Presentation projector
relations, keys • DB2 Essential Teacher-Centered Strategy (Lecture Desktop PC
b. Demonstrate entity Training II Video conferencing software
relationship • DB2 Essential
diagram Training III
• Data Studio
c. Discussed database Essential
relational model Training I
•
CO2 Online modality using Learning Quiz Laboratory Internet Week 6
Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
a. Demonstrate management system activity Laptop

relational database 2.2. Representation of relational www.db2univer Offline pdf Assignment LCD
schema database schemas sity.com/courses PowerPoint Presentation projector
b. Explained /mod/forum/vie Teacher-Centered Strategy (Lecture Desktop PC
relational database w.php?id=7021 Video conferencing software
schemas
c. Discussed the •
function of
database relational www.ibm.com/d
CO1 b2/express Online modality using Learning Quiz Laboratory Internet Week 7
a. Understood management system activity Laptop
relational algebra 2.3. Relational Algebra • Offline pdf Assignment LCD
b. Explained the PowerPoint Presentation projector
concept of www.ibm.com/s Teacher-Centered Strategy (Lecture Desktop PC
database relational oftware/data/edu Video conferencing software
algebra cation/certificati
c. Apply database on.html
relational algebra
in simple database
system
a. Understood the management system activity Laptop
relational 2.4. relational integrity (entities Offline pdf Assignment LCD
integrity in the and relationships) PowerPoint Presentation projector
database Teacher-Centered Strategy (Lecture Desktop PC
b. Discussed entity Video conferencing software
relationship
diagrams
c. Create database
relationship
diagram
a. create database management system activity Laptop
views Offline pdf Assignment LCD
Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
b. discussed the PowerPoint Presentation projector

function of 2.5. Views Teacher-Centered Strategy (Lecture Desktop PC
database views Video conferencing software
c. Explained the
function of
database views
MIDTERM EXAMINATION e.g. e.g. December Test paper, Week ___

(Coverage: Unit I to II) Multiple- Laboratory 2020 TOS, 1 hour
Choice / Hands-on assessment
Questions exam, rubrics or
(TOS must performanc criteria
be e-based
provided) exams
(rubrics/cri
teria must
be
provided)
CO2 UNIT III Structured Query Fundamental Online modality using Learning Quiz Laboratory Internet Week 10
a.
Design Language s of management system activity Laptop
database for 3.1. Introduction, objectives, Database Offline pdf Assignment LCD
web terminology Systems, PowerPoint Presentation projector
application Third Teacher-Centered Strategy (Lecture Desktop PC
b. Discussed the Edition Video conferencing software
structured query By:Ramez
language Elmasri and
Explained the Shamkant B.
function of query Navathe
language (2000)
CO1, CO2 3.2. Data manipulation Online modality using Learning Quiz Laboratory Internet Week 11
a. Apply data Fundamental management system activity Laptop
manipulation s of Offline pdf Assignment LCD
Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
in sample Database PowerPoint Presentation projector

database Systems Teacher-Centered Strategy (Lecture Desktop PC
b. Explained the seventh Video conferencing software
concept of data edition
manipulation By: Ramez
c. Discussed the Elmasri and
data Shamkant B.
manipulation Navathe
language (2016)
CO1, CO2 3.2.1. Querying, sorting, ISBN-13: Online modality using Learning Quiz Laboratory Internet Week 12
a. Apply database grouping of data 978-0-13- management system activity Laptop
querying 397077-7 Offline pdf Assignment LCD
b. Discussed PowerPoint Presentation projector
database sorting Fundamental Teacher-Centered Strategy (Lecture Desktop PC
c. Explained database s of Video conferencing software
querying and Database
sorting Systems
CO1 3.2.2. Using logical and list Fourth Online modality using Learning Quiz Laboratory Internet Week 13
operators Edition management system activity Laptop
a. Understood the 3.2.3. Single row numeric and By: Ramez Offline pdf Assignment LCD
logical and list string functions Elmasri and PowerPoint Presentation projector
operators Shamkant B. Teacher-Centered Strategy (Lecture Desktop PC
b. Explained N avathe Video conferencing software
single row (2004)
numeric and Publisher:
string function Pearson
c. Apply logical Education,
list operators Inc.
ISBN 0-321-
CO2, 12226-7 Online modality using Learning Quiz Laboratory Internet Week 14
a. Explained the 3.2.4. Group functions management system activity Laptop
database group Offline pdf Assignment LCD
functions 3.2.5. Joins FREE “DB2 PowerPoint Presentation projector
b. Discussed on Campus” Teacher-Centered Strategy (Lecture Desktop PC
Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
database joins books at Video conferencing software

c. Apply database www.ibm.c
join om/db2/book
s
CO1, CO2 3.2.6. Sub-queries • Database Online modality using Learning Quiz Laboratory Internet Week 15
a. Explained 3.2.7. Inserting, deleting and Fundamental management system activity Laptop
database sub- updating data s Offline pdf Assignment LCD
queries • Getting PowerPoint Presentation projector
function started with Teacher-Centered Strategy (Lecture Desktop PC
b. Apply DB2 Video conferencing software
inserting, Express-C
deleting and • Getting
updating data started with
in the sample IBM Data
database Studio for
c. Discussed sub- DB2
queries • Getting
CO1, CO2 3.3. Data definition started with Online modality using Learning Quiz Laboratory Internet Week 16
a. Understood the 3.3.1. Creating, altering and DB2 management system activity Laptop
data definition dropping database objects: application Offline pdf Assignment LCD
language tables, views, indexes, development PowerPoint Presentation projector
b. Apply DDL and synonyms, constraints, users Teacher-Centered Strategy (Lecture Desktop PC
DML to the sample Video conferencing software
database • SQL
c. Discussed DDL Fundamental
sI
• DB2
Essential
CO1, CO2 3.4. Creating Procedures and Training I Online modality using Learning Quiz Laboratory Internet Week 17
a. Understood the Functions • DB2 management system activity Laptop
concept of Essential Offline pdf Assignment LCD
creating Training II PowerPoint Presentation projector
procedures and • DB2 Teacher-Centered Strategy (Lecture Desktop PC
functions Essential Video conferencing software
Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
b. Discussed Training III

creating • Data Studio
procedure Essential
function Training I
CO1, CO2 3.5. Creating Database Triggers Online modality using Learning Quiz Laboratory Internet Week 18
a. Apply database • management system activity Laptop
triggers in Offline pdf Assignment LCD
sample www.db2uni PowerPoint Presentation projector
database versity.com/ Teacher-Centered Strategy (Lecture Desktop PC
b. Explained courses/mod/ Video conferencing software
database forum/view.
triggers php?id=7021
c. Discussed
database •
triggers
function www.ibm.co
m/db2/expre
ss
www.ibm.co
m/software/d
ata/education
/certification
.html
FINAL TERM EXAMINATION e.g. e.g. April 2021 Test paper, Week ___
(Content: Chapters X, XI, XII, XIII, XIV, XV, XVI, XVII) Multiple Laboratory TOS, 1 hour
Choice / Hands-on assessment
Questions exam, rubrics or
(TOS must performanc criteria
be e-based
provided) exams
Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
(rubrics/cri
teria must
be
provided)
Suggested Readings and References Fundamentals of Database Systems, Third Edition

By:Ramez Elmasri and Shamkant B. Navathe (2000)
Fundamentals of Database Systems seventh edition

By: Ramez Elmasri and Shamkant B. Navathe (2016)
ISBN-13: 978-0-13-397077-7
Fundamentals of Database Systems Fourth Edition

By: Ramez Elmasri and Shamkant B. N avathe (2004)
Publisher: Pearson Education, Inc.
ISBN 0-321-12226-7
FREE “DB2 on Campus” books at

www.ibm.com/db2/books
• Database Fundamentals
• Getting started with DB2 Express-C
• Getting started with IBM Data Studio for DB2
• Getting started with DB2 application development
• SQL Fundamentals I
• DB2 Essential Training I
• DB2 Essential Training II
• DB2 Essential Training III
• Data Studio Essential Training I

Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
 www.db2university.com/courses/mod/forum/view.php?id=7021
 www.ibm.com/db2/express
 www.ibm.com/software/data/education/certification.html
Course Requirements 1. Topic Reporting utilizing traditional and recent educational technologies
2. Research work and assignment
3. On-Time submission of written works / exercises / reports.
4. CHEATING during examination; COPYING & PLAGIARISM of submitted materials are never allowed.
5. The instructor reserves the right to either accept or deny outputs that are submitted later than the due date.
Grading System Following the Quality Policy Manual of the College of ICT, the grading system below shall be used:
LECTURE (40%)
Quizzes –30%
Class Recitation/Participation/Attendance - 10%
LABORATORY – 30%
Mid-Term/Final Term Exam – 30%
Total = 100%
Final Rating = (Final Term Grade x 2) plus Mid-Term Grade divided by 3 or FR = FT (2) + MT
3
Classroom Policies Online class using learning management system platforms:

1. Assignments must be submitted on or before the assigned deadline, late submission will have a corresponding deduction on the graded
assignment
2. Quizzes and exam will be taken only once by the individual student, it will automatically lock when the specified date and time limit is reach.
The student may take special quizzes and exam provided that the student has justifiable and valid reason.
3. The online class in open for student’s individual class discussion/ consultation and clarification during week days, Monday to Friday 8:00am to
5:00pm.
Offline class using Exe LMS platform, e-copies:
1. Modules will be given to individual students through the use of USB drive provided by the individual student. A URL link will be provided by

Issue Status 01
Revision No. 00

Telefax No. (064) 577-1343
the instructor for the student to access and download the said learning materials.
2. The student must submit assignments, quizzes, exams and reports on time that being set by the instructor.
Submitted by: Concurred by: Noted by: Recommending Approval: Approved:
RODERICK S. TINGZON MARIA VANISA A. AKMAD ENGR. ROY M. PAMA, MIT BAINORIE A. MANTAWIL, EdD HARRIS M. SINOLINDING,
Ph.D.
Course Instructor College Librarian Dean, College of ICT Director for Instruction Vice Pres. for Academic Affairs

Issue Status 01
Revision No. 00

Fundamentals of Database System

Uploaded by

Copyright:

Available Formats

Fundamentals of Database System

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Fundamentals of Database System

Uploaded by

Copyright:

Available Formats

Republic of the Philippines

COTABATO FOUNDATION COLLEGE OF SCIENCE AND TECHNOLOGY

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

COURSE SYLLABUS (OBE)

Course Name IT 211 FUNDAMENTALS OF DATABASE SYSTEM

Contact Hours/week 5 hours ( 2 hours lecture, 3 hours Lab)

Program Educational Objectives.

Secondary Job Roles

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

Program Outcome Code Program Outcomes

Course Outcome (Based on CMO for BS IT)

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

I – Introduce, P – Practice, D-Demonstrate

Week 2 1.2. Database approach (DBMS) and its components

Week 4 1.5. Distributed databases

Week 5 UNIT II The Relational Model

II.1. Definition of relational data structures, database relations, keys

Week 7 II.3. Relational Algebra

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

Week 8 II.4. Relational integrity (entities and relationships)

Week 9 II.5. Views

Week 12 3.2.1. Querying, sorting, grouping of data

Week 13 3.2.2. Using logical and list operators

Week 14 3.2.4. Group functions

Week 15 3.2.6. Sub-queries

Week 17 3.4. Creating Procedures and Functions

Week 18 3.5. Creating Database Triggers

FINAL TERM EXAM

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

Pen and Paper Assessment

Form No. : FM -DPM- CFCST PRS—01

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

database system Teacher-Centered Strategy (Lecture Desktop PC

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

a. Demonstrate management system activity Laptop

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

b. discussed the PowerPoint Presentation projector

MIDTERM EXAMINATION e.g. e.g. December Test paper, Week ___

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

in sample Database PowerPoint Presentation projector

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

database joins books at Video conferencing software

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

b. Discussed Training III

COLLEGE OF INFORMATION AND COMMUNICATION TECHNOLOGY

Suggested Readings and References Fundamentals of Database Systems, Third Edition