Republic of the Philippines Central Mindanao University University Town, Musuan, Maramag, Bukidnon College of Engineering
INSTITUTE OF COMPUTER APPLICATIONS
Course Syllabus in IT29 Database Management
Prepared by: Kent Levi A. Bonifacio Faculty-in-charge
Reviewed by:
Jinky G. Marcelo Director, Institute of Computer Applications
John D. Tajones Member, Committee on OBE Syllabus
Approved by: Constancio M. Verula Jr., Ph.D. Dean, College of Engineering
Revised January 2017
CMU Vision: A leading ASEAN university actively committed to the total development of people for a globally sustainable environment and a humane society .
CMU Mission: To advance the frontier of knowledge through internationalization of education and equitable access to quality instruction, research, extension and production for economic prosperity, moral integrity, social and cultural sensitivity and environmental consciousness.
Goals of the College: A. To train prospective CPA’s and executives who can effectively carry out programs and generate effective services in the field of Accounting, Business and Management who are imbued with the right attitudes, knowledge skills essential for personal and social fulfillment as well as the attainment of national goals; B. To contribute to educational theory and practice through research activities; and C. To provide trainings for office executives and office managers.
Objective of the BS Accountancy Department Primary Objective: To produce competent and ethical professional accountants capable of making positive contribution over their lifetimes to the professional and society to which they work. Secondary Objective: o o
Prepare the students to pass the CPA licensure examination. Prepare the students for employment in commerce and industry, public practice, government and education sector.
Program Educational Objectives Versus CMU Mission A PROGRAM EDUCATIONAL OBJECTIVES (PEO) Instruction
PEO1
PEO2
PEO3
PEO4
The primary goal of accounting education is to produce competent professional accountants capable of making a positive contribution over their lifetimes to the profession and society in which they work. (Sec12 of the BSA CMO#3s2007) The BSA program should provide a foundation of professional knowledge, professional skills, and professional values, ethics and attitudes that enable them to continue to learn and adapt to change throughout their professional lives. (Sec13 of the BSA CMO#3s2007) Preparing students for the CPA licensure examinations and for employment in private establishment and public sector (government agencies) are subsidiary objectives which should judiciously blend with the primary goal of preparing students for a successful longterm professional accounting career. (Sec14 of the BSA CMO#3s2007) After completion of the program and passing the CPA licensure examination, the graduates can pursue a career in accountancy and related professions. Specific jobs vary widely among the four major fields of accountancy: public practice, commerce and industry, government and education. (Sec15 of the BSA CMO#3s2007)
B Research & Extension
C Production
PROGRAM/GRADUATE OUTCOMES VERSUS GOALS OF THE COLLEGE of BUSINESS MANAGEMENT
PROGRAM EDUCATIONAL OBJECTIVES (PEO)
PEO1
PEO2
PEO3
PEO4
The primary goal of accounting education is to produce competent professional accountants capable of making a positive contribution over their lifetimes to the profession and society in which they work. (Sec12 of the BSA CMO#3s2007) The BSA program should provide a foundation of professional knowledge, professional skills, and professional values, ethics and attitudes that enable them to continue to learn and adapt to change throughout their professional lives. (Sec13 of the BSA CMO#3s2007) Preparing students for the CPA licensure examinations and for employment in private establishment and public sector (government agencies) are subsidiary objectives which should judiciously blend with the primary goal of preparing students for a successful long-term professional accounting career. (Sec14 of the BSA CMO#3s2007) After completion of the program and passing the CPA licensure examination, the graduates can pursue a career in accountancy and related professions. Specific jobs vary widely among the four major fields of accountancy: public practice, commerce and industry, government and education. (Sec15 of the BSA CMO#3s2007)
A
B
C
COURSE SYLLABUS 1. Course Code
:
IT 29
2. Course Title
:
Database Management
3. Pre-requisite
:
None
4. Co-requisite
:
None
5. Credit
:
3 units
6. Semester Offered
:
2nd Semester 2016-2017
7. Number of Hours
:
2 Hours Lecture and 3 Hours Laboratory
8. Course Description : Database Management introduces students to the concepts of Database Management Systems. It focuses on fundamentals of entity relationship diagrams and data flow diagram, access database fundamentals, and database design and management. Concepts of the efficient and reliable storage, shared data, and relational database management system (RDBMS) and its application are also included.
9. Course Classification :
Required
10. Student Outcomes and Relationship to Program Educational Objectives
PEO1
PEO2
PEO3
PEO4
Program Educational Objectives The primary goal of accounting education is to produce competent professional accountants capable of making a positive contribution over their lifetimes to the profession and society in which they work. (Sec12 of the BSA CMO#3s2007) The BSA program should provide a foundation of professional knowledge, professional skills, and professional values, ethics and attitudes that enable them to continue to learn and adapt to change throughout their professional lives. (Sec13 of the BSA CMO#3s2007) Preparing students for the CPA licensure examinations and for employment in private establishment and public sector (government agencies) are subsidiary objectives which should judiciously blend with the primary goal of preparing st udents for a successful long-term professional accounting career. (Sec14 of the BSA CMO#3s2007) After completion of the program and passing the CPA licensure examination, the graduates can pursue a career in accountancy and related professions. Specific jobs vary widely among the four major fields of accountancy: public practice, commerce and industry, government and education. (Sec15 of the BSA CMO#3s2007) STUDENT OUTCOMES (CMO 03 s2007)
SO1
SO2
Public Practice: Audit Staff, Tax Staff, Management Services/Consulting Staff Commerce and Industry: Financial Accounting & Reporting Staff, Management Accounting Staff, Tax Accounting Staff, Internal Audit Staff, Financial Analyst, Budget Analyst, Credit Analyst, Cost Accountant.
PEO1
PEO2
PEO3
PEO4
SO3 SO4 SO5 SO6
SO7
SO8 SO9 SO10
SO11
SO12
Government: State Accounting Examiner, State Accountant, LGU Accountant, Revenue Officer, Audit Examiner, Budget Analyst, Financial Services Specialist Education: Junior Accounting Instructor Public Practice: Audit Manager, Tax Manager, Consulting Manager Commerce and Industry: Comptroller, Senior Information Systems Auditor, Senior Fraud Examiner, Senior Forensic Auditor Government: State Accountant V, Director III and Director IV, Government Accountancy and Audit, Financial Services Manager, Audit Services Manager, Senior Auditor Education: Senior Faculty, Accounting Department Chair Public Practice: Partner, Senior Partner, Senior Consultant/Financial Advisor Commerce and Industry: Chief Financial Officer, Chief Information Officer Government: National Treasurer, Vice President for Finance/CFO (for GOCCs), Commissioner, Associate Commissioner, Assistant Commissioner, (COA, BIR, BOC) Education: Vice President for Academic Affairs, Dean
11. Course Outcomes (COs) and Relationship to Student Outcomes COURSE OUTCOMES At the end of the course, the student must be able to:
CO1
CO2
CO3
CO4
To understand the different issues involved in designing and implementing a database system. To design and build a simple database system demonstrating applications of fundamental tasks involved in modeling, designing, and implementing a DBMS. To understand and use data definition and manipulation language to query, update, and manage a database. To develop an understanding of importance of database security, integrity, concurrency, and other transaction related concerns.
S O 1
S O 2
3
O
S
S
S O
O 4
5
S
S O
O 6
7
S
S
S
S
0
1
2
S O
O 8
9
I
I
I
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
*LEVEL: I – Introductory, E – Enabling, D -
O 1
1
O
O 1
Demonstrative
12. Course Coverage In order to achieve the outcomes of this course, learners will go through this learning plan: Course
Week Outcome
Topics
Intended Learning Outcome (ILO)
Course Orientation of the ff: National and Regional goals CMU Vision and Mission Vision and Mission, and Goals of College of Engineering. Objectives of BS Accountancy program. Computer Laboratory Rules and Regulations
1
CO1
2
CO1
Introduction to Databases and Database Technology
3-4
Introduction to System Analysis
5
CO1, CO2
Database System Architecture
6-7
CO1, CO2
Data Modeling Using the Entity-Relationship Database Design
8
CO3
Database Design Microsoft Access Interface
SQL Statement 9-11
References and Resources
Assessment Activities
Familiarize the national and regional goals for national development. Memorize and understand the CMU Mission, Vision and Quality Policy. Be familiar with the objectives of the vision, mission, and goals of College of Lecture Engineering. /Participatory Be familiar with the objectives of BS Approach Accountancy program. Be able to understand the role of a syllabus in reaching the goals and objectives of the course. Be aware with the rules and regulation in the Laboratory classes
Oral Participation
Understand the fundamentals of database technology. Identify the different personnel involved in database usage and interaction Understand the types, significance and various applications of Database
Lecture, Discussion
Quiz 1, LA 1
OR1, OR2
Understanding the system data flow Create Data Flow Diagram
Lecture, Discussion, Video
Case Study 1, Homework 1, Output Presentation, LA 2
OR1, OR2
Identify the of the different data models in DBMS Understand the DBMS structure and data independence Understand database system environment Categorize different types of DBMS packages
Lecture, Discussion
Quiz 2, LA 3
OR1, OR2
Identify the role of high-level conceptual data models in database design Apply database design modeling Understand entities and attributes and applying these to schema design Understand the concepts and proper naming of entity relationships
Lecture, Discussion, Video, Seat work / Board work
Case Study 2, Homework 2, Quiz 3, LA 4, LA 5
OR1, OR2
Create a database design structure Identify the database tools in Microsoft Access Interface Create database using Microsoft Access 2007
Lecture, Discussion, Video
Quiz 4, LA 6
OR3
Understand the SQL commands for the basic SQL for specifying retrieval queries, insertion, deletion, and data updates. Manage Database in Microsoft Access 2007 Create Forms in Microsoft Access
Lecture, Discussion, Video
Homework 3, Quiz 5, LA 7
OR3
National Developmen t Plan CMU Code Operation Manual for ICA Computer Laboratory
MIDTERM EXAMINATION
7-8
Learning Activities
CO3
Database Functions in Microsoft Access
Knowledge of the different causes of failures
3-4
Introduction to System Analysis
5
CO1, CO2
Database System Architecture
6-7
CO1, CO2
Data Modeling Using the Entity-Relationship Database Design
8
CO3
Database Design Microsoft Access Interface
SQL Statement 9-11
CO3
Database Functions in Microsoft Access
Trends and Issues in Database 1011
CO4
Advance Functions in Microsoft Access – Export and Report Production
17
Lecture, Discussion, Video
Case Study 1, Homework 1, Output Presentation, LA 2
OR1, OR2
Identify the of the different data models in DBMS Understand the DBMS structure and data independence Understand database system environment Categorize different types of DBMS packages
Lecture, Discussion
Quiz 2, LA 3
OR1, OR2
Identify the role of high-level conceptual data models in database design Apply database design modeling Understand entities and attributes and applying these to schema design Understand the concepts and proper naming of entity relationships
Lecture, Discussion, Video, Seat work / Board work
Case Study 2, Homework 2, Quiz 3, LA 4, LA 5
OR1, OR2
Create a database design structure Identify the database tools in Microsoft Access Interface Create database using Microsoft Access 2007
Lecture, Discussion, Video
Quiz 4, LA 6
OR3
Understand the SQL commands for the basic SQL for specifying retrieval queries, insertion, deletion, and data updates. Manage Database in Microsoft Access 2007 Create Forms in Microsoft Access
Lecture, Discussion, Video
Homework 3, Quiz 5, LA 7
OR3
Knowledge of the different causes of failures Understand the different concepts, techniques processes, security issues and threats to databases, and the relationship between data security and privacy that are used by recovery Knowledge of the mechanism of granting and revoking access privileges in DBMS Microsoft Access advance functions and Report Production
Lecture, Discussion, Video
MIDTERM EXAMINATION
7-8
Understanding the system data flow Create Data Flow Diagram
Homework 4, Quiz 6, LA 8
OR1, OR2, OR3
FINAL TERM EXAMINATION
LEARNING OUTPUTS (PROJECT) As evidence of attaining the above course outcomes, the student has to do and submit the following:
SQL Statement 9-11
CO3
Database Functions in Microsoft Access
Trends and Issues in Database 1011
CO4
Advance Functions in Microsoft Access – Export and Report Production
17
Understand the SQL commands for the basic SQL for specifying retrieval queries, insertion, deletion, and data updates. Manage Database in Microsoft Access 2007 Create Forms in Microsoft Access
Lecture, Discussion, Video
Knowledge of the different causes of failures Understand the different concepts, techniques processes, security issues and threats to databases, and the relationship between data security and privacy that are used by recovery Knowledge of the mechanism of granting and revoking access privileges in DBMS Microsoft Access advance functions and Report Production
Lecture, Discussion, Video
Homework 3, Quiz 5, LA 7
Homework 4, Quiz 6, LA 8
OR3
OR1, OR2, OR3
FINAL TERM EXAMINATION
LEARNING OUTPUTS (PROJECT) As evidence of attaining the above course outcomes, the student has to do and submit the following: LO#
Learning Output and Other Details
CO#
LO1
Database Design Project - The project shall be a simple database application of a chosen enterprise demonstrating the applications of the fundamental tasks involved with modeling, designing, and implementing a DBMS.
CO1, CO2, CO3, CO4
LABORATORY ACTIVITIES LA 1
Research Output – Concepts of Database
LA 2
Data Flow Diagram
LA 3
Database Modeling – DBMS Structure
LA 4
Database Modeling - Entity Relationship Diagram
LA 5
Database Modeling - Database Design Schema
LA 6
Building Databases
LA 7
Basic Database Manipulation
LA 8
Advance Database Manipulation
13. Life-long Learning Opportunities Students can further enhance their knowledge on database maintenance and
LEARNING OUTPUTS (PROJECT) As evidence of attaining the above course outcomes, the student has to do and submit the following: LO#
Learning Output and Other Details
CO#
LO1
Database Design Project - The project shall be a simple database application of a chosen enterprise demonstrating the applications of the fundamental tasks involved with modeling, designing, and implementing a DBMS.
CO1, CO2, CO3, CO4
LABORATORY ACTIVITIES LA 1
Research Output – Concepts of Database
LA 2
Data Flow Diagram
LA 3
Database Modeling – DBMS Structure
LA 4
Database Modeling - Entity Relationship Diagram
LA 5
Database Modeling - Database Design Schema
LA 6
Building Databases
LA 7
Basic Database Manipulation
LA 8
Advance Database Manipulation
13. Life-long Learning Opportunities Students can further enhance their knowledge on database maintenance and management topics. Database integration on a created computer software/program is highly encouraged to be learned after this course.
14. Contribution of the Course in Meeting the professional Component General Education Courses Business Education Courses IT Education Courses Accounting and Finance Courses
0% 0% 100% 0%
15. References R1
Fundamentals of Database Systems, 6th ed,. Elmasri & Navathe, Addison-Wesley, 2011, ISBN: 978-013-608620-8
R2
Database Systems: Design, Implementation, and Management, 10th ed., Coronel, Morris, Rob, Course Technology, 2012, ISBN: 978-111-196960-8
R3
Access® 2013 All-in-One For Dummies®, Barrows, A. et. al, John Wiley & Sons, Inc., 2013, ISBN 978-1-118-51055-1
16. Other References OR1
SQL Tutorial, w3schools.com, retrieved from: http://www.w3schools.com/sql/, date retrieved: 01/2017
OR2
Outcome 2: Creating a Relational Database Design, retrieved from: http://www.sqa.org.uk/e-learning/SoftDevRDS02CD/index.htm, date retrieved: 01/2017
OR3
Database Management System Tutorial, retrieved from: http://www.tutorialspoint.com/dbms/index.htm, date retrieved: 01/2017
OR4
Access 2007, retrieved from: http://www.gcflearnfree.org/access2007, date retrieved 01/2017
17. Course Evaluation The Students will be rated on the following: MAXIMUM AVERAGE FOR SATISFACTORY PERFORMANCE
ASSESSMENT TASK MIDTERM GRADE
LECTURE (2/3 of the Midterm Grade)
CO1, CO2
Quiz 1 Case Study 1 Homework 1 Output Presentation Quiz 2 Case Study 2
5% 5% 7.5% 5% 5% 5%
Homework 2 Quiz 3
7.5% 5%
Learning Output
20%
Term Exam
35%
Laboratory Activity 1 Laboratory Activity 2 Laboratory Activity 3 Laboratory Activity 4 Laboratory Activity 5
100% 10% 10% 10% 10% 10%
Learning Output
25%
Practical Exam
25%
TOTAL
LABORATORY (1/3 of the Midterm Grade)
CO1, CO2
TOTAL
50%
50%
100% FINAL TERM GRADE
LECTURE (2/3 of the Midterm Grade)
CO1, CO2
Quiz 4 Homework 3 Quiz 5 Homework 4 Output Presentation Learning Output Term Exam
12.5% 5% 12.5% 5% 5% 25% 35%
50%
100%
TOTAL
LABORATORY (1/3 of the Midterm Grade) CO1, CO2
Laboratory Activity 6 Laboratory Activity 7 Laboratory Activity 8 Learning Output Practical Exam
10% 10% 10% 35% 35% 100%
TOTAL
50%
COMPUTATION OF TERM GRADE Term Grade (MTG / FTG) = 2/3 Lecture Grade + 1/3 Laboratory Grade
COMPUTATION OF FINAL GRADE Final Grade = 1/3 Midterm Grade + 2/3 Final Term Grade
GRADING SYSTEM
Grade 1.00 1.25 1.50 1.75 2.00 2.25 2.50 2.75 3.00 4.00 5.00 INC
Percentage Equivalent 94 – 100 88 – 93 82 - 87 76 – 81 70 – 75 64 – 69 58 – 63 52 – 57 50 – 51 30 – 49 29 and below Incomplete
18. Other Course Policies
Student is entitled for a special exam when he/she can present an excuse slip duly signed by the college secretary. Students who will incur 20% unexcused absences of the total cla ss hours after the midterm will be given a grade of dropped provided he/she has a passing midterm grade or when within the midterm period. Student should observe the university dress code otherwise he/she will not be allowed to enter the class. Student who will enter the class 15 minutes (Lecture) or 30 minutes (Laboratory) after the start of the class will be marked absent. Anyone caught cheating on examinations, reports, or other assessment activities mean a grade of 5.0 on the particular examination, report, or assessment activity.
19. Course Material Made Available Teaching Materials in IT 29
20. Other Faculty who can teach the course All Faculty of the Institute of Computer Applications depart ment
21. Prepared by: BONIFACIO, Kent Levi A.
Instructor 1
22. Reviewed by: MARCELO, Jinky G.
- Chairperson, ICA Department
ANG, Roejae Carlo A. BALANDRA, Ronaldo C. DAQUAIDO, Niel Francis P. MAGALLONES, Tristan G. TAJONES, John D.
- member - member - member - member - member
