Page 1 of 9

DON HONORIO VENTURA TECHNOLOGICAL STATE UNIVERSITY

COLLEGE OF COMPUTER STUDIES
Department of Information Technology
Main Campus, Bacolor, Pampanga



U UN NI IV VE ER RS SI IT TY Y V VI IS SI IO ON N
The Don Honorio Ventura Technological State University will be the premier
technological state university.

U UN NI IV VE ER RS SI IT TY Y M MI IS SS SI IO ON N
The Don Honorio Ventura Technological State University provides advanced
instruction, professional training and progressive leadership in education,
engineering, computer studies, science and technology, arts and humanities, and
other relevant fields of study and to undertake research, extension, and training
and production activities for sustainable development.

C CO OL LL LE EG GE E V VI IS SI IO ON N
The primary concern of the College of Computer Studies to provide a detailed,
comprehensive and extensive training to its clientele through instruction and
other relevant methodology of learning in the various disciplines in information
technology, guided with the proper work attitudes and ideals, competence and
leadership skills capable of responding to the needs of the locality, country and
the demands of global standards.

C CO OL LL LE EG GE E M MI IS SS SI IO ON N
Produce information technology graduates encoded with sufficient training and
knowledge and making them highly competitive both locally and globally.
















Page 2 of 9

DON HONORIO VENTURA TECHNOLOGICAL STATE UNIVERSITY
COLLEGE OF COMPUTER STUDIES
Department of Information Technology
Main Campus, Bacolor, Pampanga


COURSE SYLLABUS
Second Semester, Academic Year 2013-2014

I. Course Code: DBMS 223 Database Management System

II. Class Schedule: Laboratory: _____________________ Room: _____________________
Lecture: _____________________ Room: _____________________

III. Instructor: Laurence G. De Jesus
IT Instructor 1

IV. Contact Information: [email protected]
Email - Address

V. Prerequisite: DBP213 (Database Programming)

VI. Credits Units: 2/1 Units

VII. Course Description: This course covers fundamentals of database architecture, database
management systems, and database systems. Principles and methodologies of
database design, and techniques for database application development.

EXPECTED GRADUATE ATTRIBUTES:

EXPECTED GRADUATE ATTRIBUTES LEARNING OUTCOMES (LO):
On the Completion of the course, the student is expected to
do the following:
Technically proficient LO1: Explain the concept of database and Database
Management System (DBMS).
Critical Thinkers LO2: Develop and refine the conceptual data model.
Apply normalization techniques.

Competent and confident LO3: Apply and demonstrate the use of different DBMS
software or tools such as Microsoft Access and MySQL.
Perform simple and complex database queries using
SQL statements.

LEARNING OUTCOMES:

As evidence of attaining the above learning outcomes, the student is required to do and submit the following
during the indicated dates of the term.

LEARNING OUTCOMES (LO): REQUIRED OUTPUT DUE DATE

LO1: Explain the concept of database and
Database Management System
(DBMS).



Compilation of Lectures, Activities,
and Supporting Documents. (Ring-
Bind).

End of Semester


Page 3 of 9

LO2: Develop and refine the conceptual
data model.

Apply normalization techniques
statements.

LO3: Apply and demonstrate the use of
different DBMS software or tools
such as Microsoft Access and
MySQL.

Perform simple and complex
database queries using SQL
statements.

Project Applying principles of DBMS
o Software
o Supporting Documents
End of Semester



RUBRIC ASSESSMENT:

A. COMPILATION OF LECTURES, ACTIVITIES, SUPPORTING DOCUMENTS


CRITERIA

EXEMPLARY
90 100


SATISFACTORY
80 89


DEVELOPING
70 79


INADEQUATE
65 69


RATING
Presentation Exactly follows the
prescribed format.
One to five
noticeable errors in
the prescribed
format.
More than five
noticeable errors
in the prescribed
format.

Did not follow
the prescribed
format.

15%
Content Consistent order in
the compilation of
learning modules.

Minimal order in
the compilation of
learning modules.
Some learning
modules are
compiled orderly.

Lack of order in
the compilation
of learning
modules.

15%
Completeness

Complete number
of modules,
activities, and
other
compilations.

Few modules,
activities, and other
compilations are
missing.

Some modules,
activities, and
other compilations
are missing.

Incomplete
number of
modules,
activities, and
other
compilations.

20%
Free from errors All business rules
and requirements
are satisfied.



Few business rules
and requirements
are satisfied.

Some business
rules and
requirements are
satisfied

All business rules
and
requirements
were not
satisfied.
50%
TOTAL:
100%

B. PROJECT SUBMITTALS SOFTWARE


CRITERIA

EXEMPLARY
90 100


SATISFACTORY
80 89


DEVELOPING
70 79


INADEQUATE
65 69


RATING
Logic / Program
Flow
All business rules
and requirements
are satisfied.

Few business rules
and requirements
are satisfied.

Some business
rules and
requirements are
satisfied

All business rules
and
requirements
were not
satisfied.
100%

Page 4 of 9

C. PROJECT SUBMITTALS SUPPORTING DOCUMENTS


CRITERIA

EXEMPLARY
90 100


SATISFACTORY
80 89


DEVELOPING
70 79


INADEQUATE
65 69


RATING
Presentation Exactly follows the
prescribed format.
One to five
noticeable errors in
the prescribed
format.
More than five
noticeable errors
in the prescribed
format.

Did not follow
the prescribed
format.

15%
Content Consistent order in
the compilation of
learning modules.

Minimal order in
the compilation of
learning modules.
Some learning
modules are
compiled orderly.

Lack of order in
the compilation
of learning
modules.

15%
Completeness

Complete number
of modules,
activities, and
other
compilations.

Few modules,
activities, and other
compilations are
missing.

Some modules,
activities, and
other compilations
are missing.

Incomplete
number of
modules,
activities, and
other
compilations.

20%
Free from errors All business rules
and requirements
are satisfied.



Few business rules
and requirements
are satisfied.

Some business
rules and
requirements are
satisfied

All business rules
and
requirements
were not
satisfied.
50%
TOTAL:
100%


PROJECT = Software (60%) + Supporting Documents (40%)



LEARNING PLAN:

LEARNING OUTCOMES
(LO):
TOPIC WEEK
NUMBER

LEARNING
ACTIVITIES
LO1: Explain the concept
of database and
Database
Management
System (DBMS).

LO2: Develop and refine
the conceptual data
model.

Apply normalization
techniques
statements.

Class Orientation
University Mission/Vision
College Mission/Vision
Departments Specific Objectives
Course Policies and Guidelines

Course Overview
Introduction
Nature and Scope
Learning Outcomes
Rubrics for Assessment
Learning Plan
Grading System
Other matters

1

Orientation
Discussion

Page 5 of 9

LO3: Apply and
demonstrate the use
of different DBMS
software or tools
such as Microsoft
Access and MySQL.

Perform simple and
complex database
queries using SQL
statements.

Database Systems

Data vs. Information
Introducing the Database and the DBMS
Why Database Design Is Important
Historical Roots: Files and File Systems
Problems with File System Data
Management
Database Systems

1 2

Lecture Discussion


Data Models

Data Modeling and Data Models
The Importance of Data Models
Data Model Basic Building Blocks
Business Rules
The Evolution Of Data Models
Degrees of Data Abstraction

2 4

Lecture Discussion

Quiz Mid 1



CREATING AND USING A DATABASE with
MS ACCESS 2010

Explore an Access 2010 Database
Create Databases and Simple Tables
Create Simple Forms
Display Data
Create Simple Reports
Maintain Data Integrity
Create Custom Forms
Create Queries
Create Custom Reports
Import and Export Data

2 8

Lab Discussion

Laboratory Activities

Seatwork Mid 1

Lab Exam Mid 1

Seatwork Mid 2

Lab Exam Mid 2

The Relational Database Model

A Logical View of Data
Keys
Integrity Rules
Relational Set Operators
The Data Dictionary and the System
Catalog
Relationships within the Relational
Database
Data Redundancy Revisited
Indexes
Codds Relational Database Rules

4 6

Lecture Discussion




Entity Relationship (ER) Modeling

Entity Relationship Model (ERM)
Developing an ER Diagram
Database Design Challenges: Conflicting
Goals

7 8 Lecture Discussion

Quiz Mid 2


MIDTERM

9


Written Exam
Actual Exam


Page 6 of 9

Normalization of Database Tables

Database Tables and Normalization
The Need for Normalization
The Normalization Process
Improving the Design
Surrogate Key Considerations
Higher-Level Normal Forms
Normalization and Database Design
Denormalization

10 11

Lecture Discussion

Quiz Fin 1

Introduction to Structured Query
Language (SQL) Part 1

Installing MySQL
Introduction to SQL
Data Definition Language
Advanced Data Definition Commands

11 13

Lecture Discussion

Lab Discussion


Introduction to Structured Query
Language (SQL) Part 2

Data Manipulation Commands
SELECT Queries
Advanced SELECT Queries

13 15

Lecture Discussion

Lab Discussion

Quiz Fin 2

Lab Exam Fin 1

Introduction to Structured Query
Language (SQL) Part 3

Virtual Tables: Creating a View
Joining Database Tables
16 17

Lecture Discussion

Lab Discussion

Quiz Fin_2

Lab Exam Fin_1

Advanced SQL (Optional)

Relational Set Operators
SQL Join Operators
Subqueries and Correlated Queries
SQL Functions

Lecture Discussion

Lab Discussion


FINALS 18

Written Exam
Actual Exam












Page 7 of 9

GRADING SYSTEM:

MIDTERM GRADE (50%) FINAL TERM (50%)
Attendance and Character 10% Attendance and Character 10%
Class Standing / Seatwork / Homework 15% Compilation of Lectures and Outputs 15%
Quizzes 15% Quizzes 15%
Laboratory Exercises 30% Laboratory Exercises 30%
Midterm Exam:
o Written (50%)
o Actual (50%)

30%
Project
o Software (60%)
o Supporting Documents (40%)

30%
TOTAL: 100% TOTAL: 100%

FINAL GRADE = MIDTERM (50%) + FINALS (50%)

The FINAL GRADE will be based on the following scale:
































The grade of INC is given if a student whose class standing throughout the semester is passing but fails to take
the final examination or fails to complete other requirements for the course, due to illness or other valid
reasons. Removal of the incomplete grade shall be made before the start of each semester. Such a grade may
no longer be improved after the end of one school year after the submission of the grade.



GRADE PERCENTAGE
GRADE
GENERAL
CLASSIFICATION
1.0 100 Outstanding
1.1 98 99 Excellent
1.2 96 97 Excellent
1.3 94 95 Superior
1.4 92 93 Superior
1.5 90 91 Superior
1.6 89 Very Good
1.7 88 Very Good
1.8 87 Very Good
1.9 86 Very Good
2.0 85 Very Good
2.1 84 Good
2.2 83 Good
2.3 82 Good
2.4 81 Good
2.5 80 Good
2.1 84 Good
2.2 83 Good
2.3 82 Good
2.4 81 Good
2.5 80 Good
2.6 79 Fair or Passing
2.7 78 Fair or Passing
2.8 77 Fair or Passing
2.9 76 Fair or Passing
3.0 75 Fair or Passing
5.0 74 and below Failed
INC Incomplete
DRP Dropped

Page 8 of 9

REFERENCES:

Carlos Coronel, Steven Moris, Peter Rob (2012). Database Principles - Design, Implementation, and
Management Fundamentals. Cengage Learning.

Joyce Cox, Joan Lambert (2010). Microsoft Access 2010 Step by Step. Microsoft Press.

Gavin Powell (2006).Beginning Database Design. Wiley Publishing, Inc.

Andrew J. Oppel (2004). Database Demystefied. The McGraw-Hill Companies.


CLASS POLICIES:

ATTENDANCE
Prompt and regular attendance in all classes of all students from the first meeting of every course.
A deduction of 5 points for late and 10 points for absent on the Attendance grade.
Students should wear the prescribed school uniform inside the classroom otherwise they will be
marked absent.
The maximum allowable absence that the student can make is up to 20% of the total number of
hours required per subject per semester. For lecture subjects maximum of 6 absences and for
subjects with laboratory maximum of 7 absences to be dropped out.
A student is said to be excused from the attendance if the student has an excused letter, medical
certificate signed by a physician if he/she got sick, or memorandum signed by the legal authorities
in the university if the student has an assigned task.

CLASS DISCUSSION
Mobile phones should be in silent mode during class period.
Silence should be observed during the class period.
In case of an emergency phone call, the student is advised to answer the call outside the class
room.
No eating and drinking inside the classroom and laboratory room.
Always keep your classroom clean and organize.

WRITTEN EXAMS
During quizzes all lectures, books, and other learning materials are prohibited.
Students who will be caught cheating in any form during quizzes will have a grade equivalent of 50.
Students who will be caught cheating in any form during written major exam will have an
automatically failing grade for the said subject.

LABORATORY ACTIVITIES / EXAMS
During laboratory exams or activities, all lectures, books, and other learning materials are
prohibited unless allowed by the instructor.
Lectures are allowed during seatwork or laboratory activities & exercises.
Students who will be caught cheating in any form during laboratory exam will have a grade
equivalent of 50.
Students who will be caught cheating in any form during actual major exam will have an
automatically failing grade for the said subject.
Always shutdown your pc, turn off the AVR and arrange your chair back to its proper position after
using the laboratory room.
Always keep your laboratory room clean and organize.




Page 9 of 9

PROJECTS / SUBMITTALS
Plagiarism and copying of ones work is a major offense and shall be given the appropriate penalty.
Deadline of submission of assignments and projects is strictly followed.

GRADING SYSTEM
No remedial exam nor special projects will be given to students with failing grades.
The final grade should be greater than or equal to 73.0 without rounding to pass the subject.
Ranking of grades is applied throughout the end of each term.

COLLEGE
Avoid staying at the corridor to avoid disturbance on other classes.
Avoid putting the chairs outside the classroom.
Borrowed chairs must be returned back to their original place.
When before approaching a teacher on the faculty office, first respectfully ask permission to the
secretary.



Prepared by:



LAURENCE G. DE JESUS
IT - Instructor



Noted by:



ANICIA L. FERRER, MSIT
Chairman, Department of Information Technology




Approved by:



ARCH. HERMEL S. SOTIANGCO
Dean, College of Computer Studies