CARTHEL SCIENCE EDUCATIONAL FOUNDATION INC.
San Vicente, San Manuel, Tarlac
College of Information and Computer Studies
A. COURSE CODE : ACT 6
B. COURSE TITLE : Database Management System
C. COURSE CREDITS : 3 units (2units lecture = 36hrs / 1unit laboratory = 54hrs)
D. COURSE DESCRIPTION : This course gives an up-to-date view of distributed database processing. It was designed for
extending a traditional course on database systems with a treatment of distributed database
principles and concepts. At first students were introduced to basic concepts of database systems
in preparation to more complex topics as they go along the course. Computer network, operating
system and computer organization concepts were also introduced to facilitate learning and for
them to fully understand technical aspects included in distributed database.
E. PREREQUISITE/S : ACT 4 and 5
F. COURSE OBJECTIVES :
1.] General : At the end of the course, the student should be able to:
1.1] Distinguish a Distributed Database from a Centralized Database;
1.2] Learn the advantage and disadvantages of Distributed DBMS;
1.3] Know how vital transparencies in a Distributed DBMS are;
1.4] Fully understand the functions and architecture of a Distributed DBMS;
1.5] Facilitate learning in the manipulation of databases using non-procedural language such as SQL..
2.] Specific : At the end of the course, the student should be able to:
2.1] Cognitive
2.1.1] Describe the different processes/phases in the accounting cycle;
2.1.2] Compare the different types of financial statements;
2.1.3] Describe the different inventory valuation;
2.1.4] Define some business terminologies.
2.2] Affective
2.2.1] Learn basic accounting terminologies/processes;
2.2.2] Compute for the different legal deductions in the preparation of payroll;
2.2.3] Learn basic banking terminologies.
2.3] Psychomotor
2.3.1] To secure various forms needed in putting up a business;
2.3.2] To compute for the various expenses needed in setting up a business;
2.3.3] To compute for payroll together with all the legal deductions.
G. COURSE CONTENT/OUTLINE :
SUGGESTED
WEEKS/HOURS TOPIC OUTLINE READING ASSIGNMENTS EVALUATION
ACTIVITIES
st
1 Week A. Introduction to Database Database Concepts Class Discussion Research Study
3 hours Concepts Recitation Seatwork
DBMS end-user Quiz
application
Evolution of Computers
and Computer Data
Processing
Database and DBMS
Defined
Elements of Database
2nd Week B. Features of Data in a Features of Data in a Class Discussion Research Study
3 hours Database database Recitation Quiz
Shared Seatwork
Persistence
Security
Non Redundancy
Validity
Independence
C. Services Provided by a DBMS
D. DBMS Facilities
E. Classes of Computer
Systems and Database
System
3rd Week F. Features of Distributed versus Advantages and Class Discussion Assignments
3 hours Centralized Databases Disadvantages of DDBMS Recitation Written Quiz
G. Why Distributed Features of distributed Seatwork
Databases? database and centralized.
H. Advantage and
disadvantages of DDBMS
4th Week I. Homogeneous and Review of Computer Class Discussion Assignments
3 hours Heterogeneous DBMS Networks Recitation Quiz
J. Review of Computer Homogenous and Seatwork
Networks Heterogeneous
5th Week K. Functions and Architecture of Functions and Architecture of Class Discussion Assignments
3 hours a DDBMS a DDBMS Hands-on Activity Quiz
Functions of a DDBMS Recitation Seatwork
Reference Architecture
for a DDBMS
Reference Architecture
for a FMDBS
Component Architecture
for a DDBMS
L. Distributed Relational
database design
6th Week M. Transparencies in a DDBMS Transparencies in a DDBMS Class Discussion Research Study
4.5 hours Distribution Hands-on Activity Exercises
Transparency Recitation Written Quiz
Transaction PRELIMINARY
Transparency EXAMINATIONS
Performance
Transparency
DBMS Transparency
Summary of
Transparencies DDBMS
END OF PRELIM PERIOD
7th Week N. Distributed Transaction Distributed Transaction Class Discussion Research Study
2 hours Management Management Hands-on Activity Exercises
Recitation Written Quiz
8th Week O. Distributed Concurrency Distributed Concurrency Class Discussion Research Study
2 hours Control Control Hands-on Activity Exercises
Recitation Written Quiz
9th Week P. Distributed Deadlock Distributed Deadlock Class Discussion Research Study
2 hours Management Management Hands-on Activity Exercises
Recitation Written Quiz
10th Week Q. Distributed Database Distributed database recovery Class Discussion Research Study
2 hours Recovery Hands-on Activity Exercises
Recitation Written Quiz
Assignments
11th Week R. Replication Servers Replication Servers Hands-on Activity Research Study
2 hours Assignments
Exercises
Written Quiz
12th Week S. Distributed Query Distributed Query Hands-on Activity Assignments
4.5 hours Optimization Optimization Hands-on Exercises
Written Quiz
MIDTERM
EXAMINATIONS
END OF MIDTERM PERIOD
13th Week T. Overview of See-quel Class Discussion Research Study
3 hours Brief History of SQL Hands-on Activity Hands-on Exercises
What is SQL? Hands-on Quiz
14th Week U. SQL Commands Assignments
3 hours Syntax Rules Hands-on Exercises
Types of SQL Hands-on
Commands Quiz
SQL Functions
Designing
15th Week V. Relational Database Assignments
3 hours Creating Tables Hands-on Exercises
Sorting and Indexing Hands-on Quiz
16th Week W. Indexing Data, Summarizing Assignments
3 hours and Grouping Hands-on Exercises
Hands-on Quiz
17th Week X. Joining Data Tables Assignments
3 hours Advanced Topics Hands-on Exercises
Hands-on Quiz
18th Week Y. Presentation of Distributed Presentation of
5 hours System Programs
FINAL
EXAMINATIONS
END OF FINAL PERIOD
H. GRADING SYSTEM
The following percentage distribution shall be followed for each periodical grade
Prelims 30% 1) Lecture Units Laboratory units
Midterms 30% a. Class participation 10% Laboratory exercises 100%
Finals 40% b. Exercises n seatwork 20%
100% c. quizzes 20%
d. periodical exam 50%
I. INSTRUCTIONAL MATERIALS:
TEXTBOOK: NONE
J. REFERENCES/READINGS:
1. An Introduction to Database system Anil Tandon
2. Introduction to MySQL Alexander A. Hernandez
3. Introduction to SQL Server 2008 (Database Programming) Copernicus P. Pepito
4. Fundamentals of Databasae Systems 5th Ed. Ramez Elmasri
5 . Database Systems: A Practical Approach to Thomas M. Connolly
Design, Implementation and Mgmt.
6. Advanced Techniques in dBase III Plus Allan Simpson
7 . Database Systems Management and Design Philip J. Pratt
8 . Database Systems: Design, Implementation Peter Rob
and Management
9. Fundamentals of Database Systems Rames Elmasri
Prepared by:
Engr. Virgilio A. Zacarias, Jr
Dean, College of Information and Computer Studies
