College of Arts and Sciences

# CHED Suggested Syllabus

# Outcomes Based Education (OBE)
Computer Science Department
#Bachelor of Science in Computer Science
#Associate in Computer Science

Course Number CSC 123

Course Title Database Management System
Course Credits 3 unit
Database Management System, deals with databases that are a great help in putting together pieces of data we hold.
Course Description
Organizing a collection of data into records facilitates faster processing to produce the required information. This subject
will teach the students to use the database and they will understand how database work.

Course Hours/Week 1 hour/week

Prerequisite CSC 111
The student should develop skills and understanding in:

 What is Database
 What is Data and Information
 Properties and functions of the database
 What is database management system
Course Objectives
 Know the types of database
 Identify the ER Models
 Learn to connect tables using the proper Cardinalities
 Learn to create a database with the proper sql syntax
 Learn to create database using MS Access and MySQL
Prepared by: Recommending Approval: Approved:

NICO B. DELA CRUZ Engr. PETMAR M. SAING VON BRUUN M. PELLETERO, MA

Instructor (Signature Over PRINTED Name) Department Head/ Program Coordinator Asst. Campus Administrator for Academic /College Dean
ROSE MARIE T. PINILI, Ed.D., Ph.D.
Code: Version: Date of Revision: Date of Approval: Vice President, Academic Affairs
CONTROLLED U N C O N T R O L L ED

Course Outline and Timeframe:

Course Content / Subject Matter
 National and Regional Development Goals
 NORSU’s Vision and MissionGoals, Objectives and Academic Policies of the College of Arts and Sciences
Subject Orientation
 Introduction
 Properties of the database
 DBMS and its function
 FileSystem
 Database application and purpose
 Data Mining and Analysis
 Transforming raw data
Week 1 – 18
 Database Management System
 Types of Database
 Levels of abstraction
 Data Models
 ERD
 Intro to Access
 Intro to MySQL
Learning Plan :
Teaching and
Desired Learning Course Content/Subject Textbooks/ Assessment Resources Time
Learning Activities Values
Outcomes (DLO) Matter References Task (ATs) Materials Table
(TLAs)
At the end of this course,
the students must have:

 Familiarized the
National and  National Regional
Regional goals for Development Goals Students Handbook Library work Oral Recitation Students Handbook  Freedom and
development.  NORSU’s VMGO and  Responsibility
 Internalized the http://www.norsu.ed http://www.norsu.ed
Academic Policies of the Open Forum
Vision and Mission u.ph u.ph
College of Arts and
of Negros Oriental
Sciences – Computer
State University Projector
Science Department
 Explained the Goals,
Objectives and Computer
Academic policies of
College of Arts and
Sciences – Computer
Science Department

At the end of this course,

the students must have:

 Introduce Database,  Purpose of Database

Data and Systems  Teamwork
 Database Languages  Sharing ideas
Information. 10
 Relational Databases Classroom discussion Quizzes,  Responsibility
Database Systems: Hours
 Database Design Design, Implementation Brainstorming Oral Recitation  Tolerance
 Data Models & Management  Ambition
 Database Internals
 Know the properties  Database Users and
(International Edition;  Critical
Peter Rob) thinking
of the database Administrators
 Overall Structure http://www.tutorials
 History of Database point.com/dbms/db
Systems
 what is data and ms_transaction.htm
Information
 Real world
 Interdependence
 Built for Specific
 Functions of DBMS • Define the database Database Systems: Quizzes, 6
• Construction Design, Implementation Classroom discussion Oral Recitation Multimedia Projector Hours  Respect
Brainstorming
• Manipulate & Management Student Handbook  Sharing ideas
• Sharing (International Edition; Computers  Teamwork
Peter Rob) Training Manual
• Protection  Sharing ideas
 Responsibility
http://www.tutorials
 Tolerance
point.com/dbms/db
 Ambition
ms_transaction.htm  Critical thinking

 Transforming Raw  Initial Survey Screen http://www.tutorials Quizzes, Smart Tv 5  Teamwork

 Raw Data Classroom discussion Oral Recitation Computers Hours
Data into point.com/dbms/db  Sharing ideas
 Information Summary Brainstorming
Infromation Format ms_transaction.htm Hands-on  Responsibility
 Information Graphic  Tolerance
Format  Ambition
 Critical
thinking
 Types of Database  Single User Database Systems: Quizzes, Smart Tv 6  Teamwork
 Desktop Classroom discussion Oral Recitation Computers Hours
Design, Implementation  Sharing ideas
 Multi-User & Management Brainstorming Database Softwares
 Workgroup  Responsibility
(International Edition;
 Enterprise Peter Rob)
 Tolerance
 Classification  Ambition
 Location Critical thinking
 Use http://www.tutorials
point.com/dbms/db
ms_transaction.htm

 Levels of  Physical level Database Systems: Quizzes, Smart Tv 7  Teamwork

 Logical level Classroom discussion Oral Recitation Computers Hours
Abstraction Design, Implementation  Sharing ideas
 View level & Management Brainstorming
 ACID  Responsibility
(International Edition;
Peter Rob)
 Tolerance
 Ambition
Critical thinking
http://www.tutorials
point.com/dbms/db
ms_transaction.htm
 Data Models  semantic data model Database Systems: Quizzes, Smart Tv 5  Teamwork
 Types of Database Model Classroom discussion Oral Recitation Computers Hours
 Data Manipulation
Design, Implementation
Brainstorming
 Sharing ideas
& Management  Responsibility
Language (International Edition; Hands-on
 Data Definition Language Peter Rob)
 Tolerance
 Structured Query  Ambition
Language Critical thinking
 http://www.tutorials
point.com/dbms/db
ms_transaction.htm

Classroom discussion Quizzes, Smart Tv  Teamwork

 Entity–relationship  Crow's foot notation Brainstorming Oral Recitation Computers 5
http://www.tutorials  Sharing ideas
model  Cardinality Hands-on erd output Visio and other er- Hours
point.com/dbms/db Reporting software  Responsibility
ms_transaction.htm  Tolerance
 Ambition
Critical thinking
Database Systems: Quizzes, Smart Tv  Teamwork
 MS ACCESS  Discuss, navigate and Classroom discussion Oral Recitation Computers
Design, Implementation  Sharing ideas
 MYSQL learn to create database, & Management Brainstorming Database defense MS Office with Acces
tables, attributes and Hands-on and MySQL/Wamp 10  Responsibility
(International Edition;
insert records; also learn Peter Rob) Server Hours  Tolerance
to create GUI through the  Ambition
following application Critical thinking
http://www.tutorials
point.com/dbms/db
ms_transaction.htm
 Evaluation Criteria Computation of Final Grade

Major exams 20%

Oral Participation/attendance 1/2 of the Midterm Grade + 1/2 of the Final #NORSU – Guihulngan Campus
Laboratory Activities (Practical Exams) 20% term Grade #College of Arts and Sciences
Quizzes/ assignment/seat works 20% # Computer Science Department
Final Examination 40%
Total 100%

CONSULTATION HOURS : CLASSROOM POLICIES:

No Cell phones allowed during sessions.

7:00 -8 :00 MWF/ 4:00 – 5:00 MWF Proper wearing of uniforms.
CAS Faculty room No throwing of garbage anywhere inside the laboratory.
No eating and drinking inside the laboratory.
No pornographic viewing.
Playing computer games is not allowed.
Seven consecutive absentees is considered drop.

Prepared by: Recommending Approval: Approved:

NICO B. DELA CRUZ Engr. PETMAR M. SAING VON BRUUN M. PELLETERO, MA

Instructor (Signature Over PRINTED Name) Department Head/ Program Coordinator Asst. Campus Administrator for Academic /College Dean
ROSE MARIE T. PINILI, Ed.D., Ph.D.
Code: Version: Date of Revision: Date of Approval: Vice President, Academic Affairs
CONTROLLED U N C O N T R O L L ED