MANILA TYTANA COLLEGES
President Diosdado Macapagal Boulevard, Metropolitan Park, Pasay City
COLLEGE OF ARTS AND SCIENCES
BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY PROGRAM
COURSE SYLLABUS
COURSE TITLE: FUNDAMENTALS OF DATABASE SYSTEMS
COURSE CODE: IM 101
COURSE CREDIT: 3 Units (2 units lecture;1 unit laboratory)
PRE-REQUISITE: CC103
COURSE This course provides the fundamental concepts for designing, using and implementing database systems.
DESCRIPTION: It includes discussions about the properties and behavior of a database system, its structure, capabilities,
and users. Essential topics such as Entity-Relationship Model, Object-Oriented Model, and Relational
model are included which can help students in designing and manipulating databases. The Physical/Logical
Database Design and its implementation are also discussed which include important topics such as
controlling data integrity, normalization, bitmap indexes, RAID, etc.
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 1 of 9
Institutional Learning Outcomes Program Outcomes Course Objectives
Provide students with a broad liberal Pursue excellence in the field of Cognitive
education in forming holistic human Information Technology based on Understand File processing system
beings. international standards and with and Database Approach
Discover and develop the potentials exposures in the actual practices of IT Understand the ceoncepts and
and capacities of students for environment. various implementation of database
professional competence. Motivate students to do IT-based management systems
Guide students towards the attainment research that will help the country. Explain the theories of
of their goals anchored in a spirit of Instill among students a desire for normalization in designing a
concern for others. personal growth and encourage social database
Prepare students to function as worthy responsibility, moral and spiritual
and self-reliant individuals responsive to conduct, self-discipline and professional Affective
the needs of the society. ethics. Appreciate the importance of a
Nurture students to have well-rounded good database design in
personalities to withstand the pressures information systems
and demands brought about by Develop perseverance to practice
continuing social and technological skills in programming particularly in
changes. database development
Pursue excellence in developing
programs with appropriate and
logical database design
Psychomotor
Design database using data models
Use DBMS to manipulate and
integrate data to information
systems efficiently
Conduct business analysis and
propose a database design
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 2 of 9
Week Topics Learning Outcomes Methodologies Assessment
Tools
1–2 College Vision and Mission, and Recite the vision-mission of Inquiry-based learning Graded Recitation
Core Values the college and the overview of The students will ask
Classroom Policies the course questions and verify the
Grading System guidelines of the college
Course Content Articulate classroom policies and the course.
Course Requirements and grading system
1. The Context of Database
Management Name several limitations of Visualization Written Quiz
Database Environment and conventional file processing The teacher will
Development Process systems facilitate the discussion Graded Recitation
- Traditional File Processing using visual and
Systems Explain the role of individuals practical learning
- Relational Databases who design, implement, use experiences.
- Database Management and administer databases
Systems Inquiry-based
Explicate the differences Instructions
between external, conceptual, The teacher will pose
and internal schemas thought-provoking
questions about
experiences in dealing
with data (manual and
transactional) which
inspire students to think
for themselves and
become more
independent learners
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 3 of 9
3-4 2. Modelling Data in the Write good names and Demonstration- Laboratory/
Organization definitions for entities, Performance method Hands-on Activity
Modeling the Business Rules relationships, and attributes The teacher will
- Scope demonstrate how to Written Quiz
- Data Names and Model each of the following model an E-R diagram.
Definitions constructs in an E-R diagram: The students will do
- Relational Databases composite attribute, some exercises after.
Modeling Entities and Attributes multivalued attribute, derived
- Types of Entities attribute, associative entity, Think-Pair-Share
- Sorts of Attributes identifying relationship, and The students will be
Modeling Relationships minimum and maximum divided into pairs and
- Relationship Attributes cardinality constraints will collaborate draw an
- Degree of Relationship E-R diagram and share
- Cardinality Constraints Draw an E-R diagram to their answers with the
represent common business rest of the class
situations.
Laboratory Activity
Create an E-R diagram
using any modeling
software
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 4 of 9
5 3. Enhanced E-R Model Recognize when to use Demonstration- Laboratory/
Supertypes and Subtypes supertype/ subtype Performance method Hands-on Activity
Constraints in Supertype/ relationships in data modeling The teacher will
Subtype Relationships demonstrate how to Graded Exercises
Specify both completeness model an EE-R
constraints and disjointness diagram. The students Written Quiz
constraints in modeling will do some exercises
supertype/subtype after.
relationships
Think-Pair-Share
Develop a supertype/subtype The students will be
hierarchy for a realistic divided into pairs and
business situation will collaborate draw an
EE-R diagram and
Develop an entity cluster to share their answers with
simplify presentation of an E-R the rest of the class
diagram
Laboratory Activity
Create an EE-R
diagram using any
modeling software
6 PRELIM EXAMINATION
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 5 of 9
7-8 4. Logical Database Design and State two essential properties Visualization Written Quiz
Relational Model of a candidate key The teacher will
Relational Data Model Give a concise definition of facilitate the discussion Graded Seatworks
- Relationship Attributes each of the following: first using visual and
- Degree of Relationship normal form, second normal practical learning
- Cardinality Constraints form, and third normal experiences.
Integrity Constraints Create relational tables that
Transforming EER Diagrams incorporate entity integrity Demonstration-
into Relations and referential integrity Performance method
Creating Relational Tables constraints The teacher will
demonstrate how to
create a relational data
model.
9 -10 5. Normalization Transform an E-R (or EER) Demonstration- Quiz
Steps in Normalization diagram into a logically Performance method
Merging Relations equivalent set of relations The teacher will Hands-on
Use normalization to gradually demonstrate activities
decompose a relation with the steps normalizing a
anomalies into well-structured table. Students will Pair Exercises
relations normalize tables
Normalize a table to afterward.
transform it into a logical data
model Laboratory Activity
Students will create a
visualization of
normalized tables
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 6 of 9
11 6. Physical Database Design and Demonstration- Written Quiz
Describe the physical
Performance Performance method
database design process, its
Physical Database Design objectives, and its deliverable
The teacher will File Organization
Process demonstrate and activity
Table Fields Design Select an appropriate file discuss extensively
Denormalization and organization by balancing physical database Hands-on
Partitioning of Data various important design designing. activities
File Organizations factors
Unique Key Index Translate a relational data
model into efficient database
7. Introduction to MySQL structures, including knowing
Workbench when and how to denormalize
the logical data model.
12 MIDTERM EXAMINATION
13-15 8. Introduction to SQL Write single-table queries Demonstration- Quiz
SQL Environment using SQL commands Performance method
Queries The teacher will Hands-on
- Create Define a database using the demonstrate how to activities SQL
- Insert SQL data definition language write database queries statements
- Update using SQL.
- Delete Establish referential integrity
Processing of Single Tables using SQL Pause Procedure
- Select Statement Method
Processing of Multiple Tables Write single- and multiple- Students need to have
- Join Statements table queries using SQL time to discuss, ask
commands questions, or solve
query problems.
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 7 of 9
16 - 9. Embedding SQL Programs Create a Java application that Lecture-Discussion Quiz
17 Developing a Java client-side incorporates logical database
application with database design and facilitates Demonstration- Hands-on
integration inserting, editing, deleting, Performance method activities
and displaying records. The teacher will
demonstrate how to Project
write connection strings Presentation
in VB.Net to integrate
database in an
application
Laboratory Activity
Create an application
that implements CRUD
18 FINAL EXAMINATION
TOTAL 18 WEEKS - 90 HOURS
TEXTBOOK: None
REFERENCES:
Database system. (2018). New York, NY: 3G E-learning LLC. 2018
Talburt, J.R. & Zhou, Y. (2015). Entity information life cycle for big data: master data management and information
integration.Waltham, MA: Elsevier/Morgan Kaufmann.
Hoffer, J.A., Ramesh, V. & Topi, H. (2013). Modern database management. Essex: Pearson.
Hoffer, J.A., Ramesh, V. & Topi, H. (2013). Modern database management. Singapore: Pearson.
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 8 of 9
GRADING SYSTEM:
Course Grade: Prelim x 30% + Midterm x 30% + Finals x 40% = Semestral Grade
Major Requirements 60%
Major Exam 40%
Machine Problems 20%
Class Requirements 40%
Quizzes (Written and Hands On) 20%
Seatwork 10%
Assignment 5%
Recitation 5%
____________
100 %
Equivalent Grade = Raw Score / Total Score * 75 + 25
COURSE REQUIREMENTS:
1. Major Requirements = 60%
1.1. Prelim (30%)
1.2. Midterm (30%)
1.3. Finals (40%)
2. Class Requirements = 40%
Quizzes
Recitation
Seatwork
Laboratory Exercises
Machine Problems
Google Classroom Activities
Prepared by: Checked by: Reviewed by: Reviewed by: Approved by:
ASST. PROF. MARK PROF. RITA J. MRS. MARIFE M. DR. LORNA D. DR. SERGIO S.
ANTHONY D. UY FAMINI TEJERO TAMBOONG CAO
Faculty Program Head Head, Library Dean President and Chief
Academic Officer
Page 9 of 9
