Course Syllabus
Republic of the Philippines
CITY OF MANDAUE
MANDAUE CITY COLLEGE
Don Andres Soriano Ave. Centro, Mandaue City
Tel. No. 236-5520
COURSE SYLLABUS
NAME: JEZEVYL S. PILOTA EMAIL: jezevylpilota@yahoo.com CONTACT NO.:
ROOM: COMPUTER LABORATORY TIME: 5:30-8:00 MONDAY-TUESDAY
COURSE CODE: IT 8 NO. OF HOURS PER WEEK: 5
COURSE TITLE: DATABASE MANAGEMENT I NO. OF WEEKS: 20
CREDIT UNITS: 3 PREREQUISITE: NONE
I. COURSE DESCRIPTION:
This course emphasizes the importance of database design, use and management of Information Systems. The module begins with a general description of databases and Database Management Systems (DBMS), including the relationships that exist among a database, a DBMS and an application. Relational database tables, Entity-Relationship Models and the role of metadata are discussed in detail. Finally, the module describes SQL, and explores the role of databases in data warehousing.
At the end of the course, the students will be able to:
Understand terms related to database design and management.
Understand the relational model and relational database management system.
Assess data and information requirements.
Develop logical data models.
II. COURSE OUTLINE
Allotted time: 60 hours
TOPICS TO BE DISCUSSED
SPECIFIC OBJECTIVES
STRATEGIES/ACTIVITIES
NO. OF HOURS
METHODS OF EVALUATION
REMARKS
1
Part I: Vision, Mission, Objectives of MCC
Part II: Orientation on the Course
Relate the course to the mission, vision and objectives of MCC
Demonstrate the Importance of the course.
Content Discussion together with the House Rules and Objectives
5
Oral Recitation
2
Chapter 1: Fundamental Database Concepts
Describe the importance of data and database.
Define the key terms needed to understand databases and database management.
Discussion and demonstration with an Application of the acquired knowledge
5
Short quizzes
Board works
Contest/games
Homework
3
Chapter 2: The Value
CITY OF MANDAUE
MANDAUE CITY COLLEGE
Don Andres Soriano Ave. Centro, Mandaue City
Tel. No. 236-5520
COURSE SYLLABUS
NAME: JEZEVYL S. PILOTA EMAIL: jezevylpilota@yahoo.com CONTACT NO.:
ROOM: COMPUTER LABORATORY TIME: 5:30-8:00 MONDAY-TUESDAY
COURSE CODE: IT 8 NO. OF HOURS PER WEEK: 5
COURSE TITLE: DATABASE MANAGEMENT I NO. OF WEEKS: 20
CREDIT UNITS: 3 PREREQUISITE: NONE
I. COURSE DESCRIPTION:
This course emphasizes the importance of database design, use and management of Information Systems. The module begins with a general description of databases and Database Management Systems (DBMS), including the relationships that exist among a database, a DBMS and an application. Relational database tables, Entity-Relationship Models and the role of metadata are discussed in detail. Finally, the module describes SQL, and explores the role of databases in data warehousing.
At the end of the course, the students will be able to:
Understand terms related to database design and management.
Understand the relational model and relational database management system.
Assess data and information requirements.
Develop logical data models.
II. COURSE OUTLINE
Allotted time: 60 hours
TOPICS TO BE DISCUSSED
SPECIFIC OBJECTIVES
STRATEGIES/ACTIVITIES
NO. OF HOURS
METHODS OF EVALUATION
REMARKS
1
Part I: Vision, Mission, Objectives of MCC
Part II: Orientation on the Course
Relate the course to the mission, vision and objectives of MCC
Demonstrate the Importance of the course.
Content Discussion together with the House Rules and Objectives
5
Oral Recitation
2
Chapter 1: Fundamental Database Concepts
Describe the importance of data and database.
Define the key terms needed to understand databases and database management.
Discussion and demonstration with an Application of the acquired knowledge
5
Short quizzes
Board works
Contest/games
Homework
3
Chapter 2: The Value
References: Hoffer, Jeffrey A., Prescott, Mary B. & McFadden R. Fred, "Modern Database Management", Sixth Edition, Prentice Hall, 2002, ISBN 0-13-033969-5 Databases Illuminated, Catherine Ricardo, Jones and Bartlett, 2004 (ISBN 0-7637-3314-8)