Instructor

Dr. Josephine R. Bayonito

Associate Professor 5

Reviews (5)

Reniel Torres
ronald ledda
Kristel Ruth
Frederick Edison Ortiz

Overview

Course Code    ACT 213  Introduction to DBMS

Course Description

The course includes discussions on database concepts and different DBMS models. It focuses on the entity relationship model and its components: entity type, relationship and attributes.   Discussions on supertype/subtype relationship which is the most common notation used in enhanced ERD are also included.  The course also includes thorough discussions about relational model as well as the rules on how to convert entity relationship diagram to specific relation schema.  The process of normalization is also given emphasized at the last part of the course.

FACULTY:                 DR. JOSEPHINE R. BAYONITO

CLASS/CONSULTATION HOURS:  REFER TO SECTION SCHEDULES

(NOTE: ALSO PART OF THE SCHEDULES ARE ONLINE SESSIONS, DISCUSSIONS AND ACTIVITIES.

Lessons, activities, quizzes, assignments and other supplementary materials are available in this online LMS)

LEARNING OUTCOMES (LO):

On completion of the course, the student is expected to be able to do the following:

Learning Outcomes

1. Acquire thorough understanding of the vision, mission, goals and objectives of the university and its importance to this course.

2. Acquire and apply the principles, methodologies and techniques in database design and information management to gain competitive advantage and to share the acquired knowledge/skills to other members of the organization/society.

3. Compare the advantages of database approach against the traditional file processing

4. Explain the components of a typical database environment

5. Discuss the differences between conceptual, external and physical schemas of databases

6. Understand business rules and the different constructs applicable in entity relationship diagram

7. Incorporate supertype/subtype in ERD if deemed necessary

8. Transform ER diagram to a logically equivalent set of relations

9. Normalize relations containing redundancy to produce well-structured relations

10. Apply the different DBMS concepts in basic information system using Microsoft Access

 

 

Course content


Request invitation

Content of this course is available by invitation only. You can not access this course if you don't have an invitation from the course instructor.

Get Started

Interested? Start your first course right now.

There is more to learn