DCIT 24 Information Management
DCIT 24 Information Management
VPAA-QF-10
Republic of the Philippines
CvSU Vision CvSU Mission
The premier university in
CAVITE STATE UNIVERSITY Cavite State University shall provide
historic Cavite recognized for
Trece Martires City Campus excellent, equitable and relevant educational
excellence in the development 410-5247 opportunities in the arts, science and
of globally competitive and www.cvsu.edu.ph technology through quality instruction and
morally upright individuals. relevant research and development activities.
It shall produce professional, skilled and
morally upright individuals for global
competitiveness.
DEPARTMENT OF INFORMATION TECHNOLOGY
COURSE SYLLABUS
First Semester, AY 2022-2023
Course Information Lecture
DCIT 24 Course Title Type Credit Units 3
Code Management Laboratory
Course This course information management, database design, data modeling, SQL, and implementation using relational database
Description system.
Pre- Lecture: TBA
DCIT 23 Course Schedule
requisites Laboratory: TBA
Students are expected to live by and stand for the following University tenets:
TRUTH is demonstrated by the student’s objectivity and honesty during examinations, class activities and in the development
of projects.
EXCELLENCE is exhibited by the students’ self-confidence, punctuality, diligence and commitment in the assigned tasks,
Core Values
class performance and other course requirements.
SERVICE is manifested by the students’ respect, rapport, fairness and cooperation in dealing with their peers and members
of the community.
In addition, they should exhibit love and respect for nature and support for the cause of humanity.
V02-2020-06-01
1. provide high quality instruction in order to produce skilled, morally upright, and globally competitive graduates;
Campus 2. develop and pursue advance research activities through arts, sciences, and technology to support instruction; and
3. develop and conduct extension activities that will empower local people and communities.
The department shall endeavor to:
1. support the university’s mission and vision in providing globally competitive individuals through technological
Objectives
advancements;
of the
2. equip students with knowledge in the field of information technology; and
Department
3. strengthen students’ skills through research development and extension activities that will endow their personal and
social growth.
1. apply knowledge of utilization of both hardware and software technologies involving planning, installing, customizing, operating,
managing and administering, and maintaining information technology infrastructure that provides computing solutions to address the
needs of an organization;
2. conduct relevant researches ad extension program activities in the field of information technology;
3. the development and transfer of appropriate information technology;
4. promote environmental conservation and protection on projects and enterprises related to information technology; and
5. become morally upright IT professionals with primary or secondary job roles.
V02-2020-07-01
creation, evaluation and administration of computer-based systems;
design, implement, and evaluate computer-based systems, processes,
e components or programs to meet desired needs and requirements under
various constraints;
f integrate IT-based solutions into the user environment effectively;
apply knowledge through the use of current techniques, skills, tools and
g
practices necessary for the IT profession;
function effectively as a member or leader of a development team
h
recognizing the different roles within a team to accomplish a common goal;
i assist in the creation of an effective IT project plan;
communicate effectively with the computing community and with society at
j large about complex computing activities through logical writing,
presentations, and clear instructions;
analyze the local and global impact of computing information technology on
k
individuals, organizations, and society;
understand professional, ethical, legal, security and social issues and
l
responsibilities in the utilization of information technology; and
recognize the need for and engage in planning, self-learning and improving
m
performance as a foundation for continuing professional development.
Course Outcomes and Relationship to Student Outcomes
Program Outcomes Addressed by the Course Program/Student Outcomes Code
After completing this course, the students must be able to: a b c D e f g h i J k l m
1. explain database schema, principles of database
I I E E I I E I I I I I I
environment and database development process;
2. analyze an existing database system with respect to
quality issues, reliability, scalability, efficiency, E E D E E E D E E D E E E
effectiveness, and security; and
3. design a database based on user requirements using a
widely used modeling notation, and be able to use D E D E D D D D E D E E E
declarative query language to elicit information.
*Level : I-Introductory E- Enabling D-Demonstrative
V02-2020-07-01
COURSE COVERAGE
Mode Due Date of
Topic Teaching and Outcomes-based
Wee Intended Learning of Resources Submission
Learning Assessment
k No. Outcomes (ILO) Deliver Needed of Output
Activities (TLA) (OBA)
y
After the completion of I. Introduction of the Virtual Class Distanc Google OBA 1: End of Week
the chapter, students Course Discussion e Mode Classroom List at least 5 2
will be able to: 1.1 University Mission (Synchr references related
and Vision Acknowledgeme onous Course to Object Oriented
1. introduce oneself to 1.2 Goals and nt of Course Class) Syllabus Programming
the class; Objectives Syllabus from e-Library
2. list down 1.3 Quality Policy (10 points)
expectations for the 1.4 University Tenets Checking of Internet
course; 1.5 Gender and Certificate of Connection
3. identify course Development Registration
requirements and Orientation (COR) Laptop/
regulations in the 1.6 Course Overview Desktop
new normal of self- (Syllabus) and Video Viewing: Computer/
paced learning; Requirements Mobile
4. reflect on the vision 1.7 Re-orientation on CvSU at Glance: Phone or
1
and mission of the the use of https://youtu.be/ other related
University, goals and Campus LMS _4bQ1Z9gUuA devices
objectives of the I.1 Virtual tour e-
Campus and Library System Gender and Pen and
department, Development: Notebook
integrating gender https://www.yout
and development ube.com/watch?
principles throughout v=_Gmd0xAZ8Ac
the study of the ;
course; and https://www.yout
5. use the CvSU ube.com/watch?
Integrated Library v=WZvNcflKBDs
System in searching
for relevant online Tutorial on
references. Online E- Library
V02-2020-07-01
System:
https://
www.youtube.co
m/watch?
v=vznuvaP1XRg
6. determine the Laboratory: Online Distanc Google OBA #2: End of Week
laboratory class Laboratory Class Discussion thru e Mode Classroom Reflection Paper 2
expectations of Expectations Video/Audio (Asynch on Laboratory
the course; and Conferencing ronous Internet class
7. familiarize the Class) Connection expectations
software/applic
ation to be used Laptop/ 1-Page Reflection
Desktop (20 Points)
Computer/
Mobile
Phone or
other related
devices
Pen and
Notebook
2 After the completion of II. The Context of E-Module with Distanc Lecture OBA#3: End of Week
the unit, students will be Database Video or e Mode (Power Point -Differentiate 3
able to: Management PowerPoints (Synchr Presentation Data and
1. identify the Presentation onous ) Information.
functions of a 2.1 Basic Concepts and Class) -Roles in
database; Definitions Modules database
2. appreciate the a. Roles and management.
roles of a DA/DBA; Advantages of Learning (DBA vs DA)
the DBMS Guide
b. Data versus Identify:
Information. Computer/ -Importance
c. Types of Laptop/ and qualities
Database mobile of a -
V02-2020-07-01
2. 2. Software Systems phone Database.
II.3 Data Models -System
2.4 Roles of Data and software
Database Administrator usages.
2.5 Data Application
Components (10 points)
2.6Range of Database
Applications
3. recognize the Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
differences between Creating METADATA Exercise e Mode Mobile/tablet Activity 1. 3
data and database; and (Asynch with internet
ronous connection Creation of
4. determine data Class) Metadata
models. E-Module (25points)
Google
Classroom
3 After the completion of III. Database Systems E-Module with Distanc Lecture OBA#4: End of Week
the unit, students will be Video or e Mode (Power Point 4
able to: 3.1Importance of PowerPoints (Synchr Presentation 1. The Different
1. explain the Database Design. Presentation onous ) file system data
importance of 3.2Evolution of File Class) processing.
Database Design; System Data Modules 2. Issues
2. analyze the issues Processing encountered in
with File System a. Manual File Learning FSDP.
Data Processing; Systems Guide
3. familiarize Database b. Computerized (10 points)
System File System Computer/
Environments; c. File System Laptop/
Redux: Modern mobile
End-User phone
Productivity
Tools
3.3 Problems with File
V02-2020-07-01
System Data
Processing
a. Structural and
Data
Dependence
b. Data
Redundancy
c. Data Anomalies
3.4 The Database
System Environment.
(Components)
3.5 DBMS Functions
Managing the Database
System
4. explain different Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
DBMS Functions; Creating Database Exercise e Mode Mobile/tablet Activity 2 5
and (Asynch with internet
5. recognize database ronous connection Create a layout
management Class) of a database
system. E-Module environment with
label (25points)
Google
Classroom
4 After the completion of IV. Database Online Distanc Lecture OBA#5: End of Week
the unit, the students Development Discussion thru e Mode (Power Point 5
will be able to: Process Video/Audio (Synchr Presentation Explain Database
Conferencing onous ) Development
1. Familiarize and Class) Process and
design an EDM; 4.1 Enterprise Data Modules system
2. Appreciate an Modeling development
information system 4.2 Information System Learning cycle
architecture; Architecture Guide
4.3 Information (10 points)
Engineering Computer/
V02-2020-07-01
and Planning Laptop/
Phase mobile
4.4 System phone
Development
Process
4.5 Database
Development
3. recognize Laboratory: Online Distanc Computer/ Laboratory End of Week
information Creating EDM Discussion thru e Mode Mobile/tablet Activity 3 5
engineering and Video/Audio (Asynch with internet
planning phase; Conferencing ronous connection 1. Creation of
4. define system Class) EDM.
development process E-Module 2. Application of
and database Information
development. Google system
Classroom architecture and
Information
engineering
planning phase
(25points)
5 After the completion of V. Modeling Data in Lecture/ Distanc Lecture OBA#6: End of Week
the unit, the students Organization Discussion e Mode (Power Point 6
will be able to: (Synchr Presentation Identify and
1. identify basic 5.1 ER Model Presentation onous ) explain the
concepts of ER 5.2 Business Rule Class) components of an
model; 5.3Naming Objects Demonstration/ Modules ER model.
2. familiarize entity 5.4Attributes Simulation
types; 5.5Entity Relationships Learning . (10 points)
a. One to One Guide
b. One to Many
c. Many to Many Computer/
5.6ER Diagram Laptop/
mobile
phone
V02-2020-07-01
3. recognize Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
relationships in Creating ERD Exercise e Mode Mobile/tablet Activity 4 7
creating an ER (Asynch with internet Creation of ERD.
design; and ronous connection Student will be
4. design an ERD. Class) given problems
E-Module and they will
construct a model
Google
Classroom (25points)
6 After the completion of VI. Introduction to Discussion Distanc Lecture OBA#7: End of Week
the unit, the students Structured Query e Mode (PowerPoint 7
will be able to: Language Presentation (Synchr Presentation Differentiate
1. define the basics of onous ) different types of
database functions 6.1Basic MySQL Demonstration/ Class) data types
of MySQL; and Functions Simulation Modules (10 points)
6.2Data Types
6.3Primary/ Secondary Learning
Key Guide
6.4Three main parts of
query Computer/
Laptop/
mobile
phone
2. apply basic functions Laboratory: E-Module with Distanc Computer/ Laboratory End of Week
of MySQL Execution of different Video or e Mode Mobile/tablet Activity 5 7
queries PowerPoints (Asynch with internet
Presentation ronous connection 1. Installation of
Class) technology and
Asynchronous E-Module familiarization of
video recordings UI.
of lecture Google
accessed online Classroom 2. Simple queries
practice.
V02-2020-07-01
3. Creation of
Queries: SQL
View in MS
Access
(25points)
7 After the completion of VII. Microsoft Access Discussion Distanc Lecture OBA#8: End of Week
the unit, the students engaging to SQL e Mode (Power Point 8
will be able to: output (I) Presentation (Synchr Presentation 10 item quiz
onous ) about different
1. familiarize on 7.1 Creating Demonstration/ Class) queries
LibreOffice Base database in MS Simulation Modules
IDE; Access
7.2 Creating Table Learning
7.3 Inserting data Guide
Computer/
Laptop/
mobile
phone
2. create and use a Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
database in MS Creating and inserting Exercise e Mode Mobile/tablet Activity 6 8
access; and data in table (Asynch with internet
3. modify a table in the ronous connection 1. Creating
database. Class) database and
E-Module inserting of data
in database table.
Google
Classroom 2. Creating
Database using
MS Access
(25points)
8 After the completion of VIII. Microsoft Access Online Distanc Lecture OBA#9: End of Week
V02-2020-07-01
the unit, the students engaging to SQL Discussion thru e Mode (Power Point 9
will be able to: output (II) Video/Audio (Synchr Presentation Explain RDMS
Conferencing onous ) using figures (10
1. Design a relational 8.1 Relational Database Class) points)
database. Modules
.
Learning
Guide
Computer/
Laptop/
mobile
phone
2. Modify field Laboratory: Online Distanc Computer/ Laboratory End of Week
properties of table and Designing RDMS Discussion thru e Mode Mobile/tablet Activity 7 9
create views Video/Audio (Asynch with internet
Conferencing ronous connection 1. Designing a
Class) relational
E-Module database.
Google
Classroom 1. Modifying field
properties of
tables
and viewing
outputs
(25points)
V02-2020-07-01
will be able to: Presentation (Synchr Presentation)
9.1 Create a query in onous 10 item
1. apply basic queries design, wizard and Demonstration/ Class) Modules quiz(simulation)
using MS Access; SQL view. Simulation
2. create reports using 9.2 Basic queries. Learning
MS Access; and 9.3 Creating reports Guide
using a database.
Computer/
Laptop/
mobile phone
3. create entity Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
relationship using MS Creating DB with Exercise e Mode Mobile/tablet Activity 8 12
Access. attributes (Asynch with internet
ronous connection 1. Creating
Class) database form
E-Module and applying
attributes and
Google primary key.
Classroom
2. Continue
database form
and creating
relationships
among entities
(25points)
12 After the completion of X. Database Analysis Online Distanc Lecture OBA#11: End of Week
the unit, the students Discussion thru e Mode (Power Point 13
will be able to: 10.1 Modeling data in Video/Audio (Synchr Presentation) Create a basic
the organization. Conferencing onous model using
1. create a basic data 10.2 Modeling the Class) Modules diagram
model; and (10 points)
rules of the
Learning
organization. Guide
V02-2020-07-01
Computer/
Laptop/
mobile phone
2. apply business rules. Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
Creating data models Exercise e Mode Mobile/tablet Activity 9 13
(Asynch with internet
ronous connection 1. Creating data
Class) models with
E-Module connection
/relationships
Google
Classroom 2. Using
previously
created DM to
create a DB
form and apply
simple query.
(25points)
13 After the completion of XI. SQL | DDL, DQL, Discussion Distanc Lecture OBA#12: End of Week
the unit, the students DML, DCL and TCL e Mode (Power Point 14
will be able to: Concepts (I) Presentation (Synchr Presentation) Differentiate
11. 1DDL(Data onous DDL and DQL
1. explain the concepts Definition Language) Demonstration/ Class) Modules with examples
and applications of 11.2DQL (Data Query Simulation (10 points)
DDL, DQL, DML, Language) Learning
DCL, and TCL; and 11.3 ML(Data Guide
Manipulation Language)
Computer/
Laptop/
mobile phone
2. apply the usage of Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
SQL (DDL, DQL, DML, Creating DDL and DML Exercise e Mode Mobile/tablet Activity 10 14
DCL, and TCL) using (Asynch with internet
V02-2020-07-01
DB software. ronous connection 1. DDL
Class) exercises(Creat
E-Module e, Drop, Alter,
Truncate,
Google Comment,
Classroom Rename)
2. DQL
exercises(Select
)
3. DML (Insert,
Update, Delete)
(25points)
14 After the completion of XI. SQL | DDL, DQL, Discussion Distanc Lecture OBA#13: End of Week
the unit, the students DML, DCL and TCL e Mode (Power Point 15
will be able to: Concepts (II) Presentation (Synchr Presentation) Differentiate
onous DCL and TCL
1. explain the concepts 11.4DCL (Data Control Demonstration/ Class) Modules with examples
and applications of Language) Simulation (10 points)
DDL, DQL, DML, DCL, 11.5TCL (transaction Learning
and TCL; and Control Language) Guide
Computer/
Laptop/
mobile phone
2. apply the usage of Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
SQL (DDL, DQL, DML, Creating DCL and TCL Exercise e Mode Mobile/tablet Activity 11 15
DCL, and TCL) using (Asynch with internet
DB software. ronous connection DCL exercises
Class) (Grant, Revoke)
E-Module TCL (Commit,
Rollback,
Google Savepoint, Set
Classroom transaction)
V02-2020-07-01
(25points)
15 After the completion of XII.MySQL functions Discussion Distanc Lecture OBA#14: End of Week
the unit, the students e Mode (Power Point 16
will be able to: 12.1 Concepts and Presentation (Synchr Presentation) 10 item quiz
1. identify the usage application of onous about MySQL
and applications of aggregate functions: Demonstration/ Class) Modules functions
MySQL functions; Simulation
and a. AVG Learning
. b. COUNT Guide
c. MAX
d. MIN Computer/
e. SUM Laptop/
f. Standard mobile phone
Deviation
g. GROUP_CONCA
T
2. create queries using Laboratory: Laboratory Distanc Computer/ Laboratory End of Week
MySQL function scripts Applying different SQL Exercise e Mode Mobile/tablet Activity 12 16
Function (Asynch with internet
ronous connection Aggregate
Class) function
E-Module exercises. Apply
the
Google following(AVG,C
Classroom OUNT,MAX,MIN
,SUM,SD,GC)
and generate
outputs.
(25points)
16 After the completion of XIII.Advanced MySQL Online Distanc Lecture OBA#15: End of Week
the unit, the students (I) Discussion thru e Mode (Power Point 17
will be able to: Video/Audio (Synchr Presentation) 10 item quiz
1. explain the 13.1 Concepts and Conferencing onous about advanced
V02-2020-07-01
concepts and application of Class) Modules MySQL
applications of advanced scripts:
advanced scripts; Learning
and a. BETWEEN Guide
b. LIKE
c. ALIASES Computer/
d. INNER JOIN Laptop/
e. LEFT JOIN mobile phone
f. RIGHT JOIN
g. FULL & SELF
2. create queries using Laboratory: Online Distanc Computer/ Laboratory End of Week
MySQL Advance Applying different Discussion thru e Mode Mobile/tablet Activity 13 17
scripts. Advance SQL Video/Audio (Asynch with internet
Function Conferencing ronous connection Advance scripts
Class) exercises. Apply
E-Module the following
(BETWEEN,
Google LIKE, ALIASES)
Classroom and generate
outputs.
Advance scripts
exercises. Apply
the following
(JOINS) and
generate
outputs.
(25points)
17 After the completion of XIV. Advanced MySQL Discussion Distanc Lecture OBA#16: End of Week
the unit, the students (II) e Mode (Power Point 18
will be able to: Presentation (Synchr Presentation) 10 item quiz
1. explain the concepts 14.1 UNION onous about advanced
V02-2020-07-01
and applications of 14.2 GROUP BY Demonstration/ Class Modules MySQL
advanced scripts; and 14.3 Simulation
Learning
Guide
Computer/
Laptop/
mobile phone
2. create queries using XIV. Advanced MySQL Laboratory Distanc Computer/ Laboratory End of Week
MySQL Advance (II) Exercise e Mode Mobile/tablet Activity 14 18
scripts. 14.4 HAVING (Asynch with internet
14.5 CASE ronous connection Advance scripts
Class exercises.
E-Module Apply the
following
Google (UNION,GROU
Classroom P
BY,HAVING,CA
SE) and
generate
outputs
(25points)
Laboratory Requirements:
V02-2020-07-01
1. Laboratory Activities
2. Mid-Term Examination
3. Final Examination
4. Attendance
Attendance
*All exams must follow a Table of Specifications (TOS) and Rubrics for evaluation of student’ performance or projects.
GRADING SYSTEM
Lecture Grading System (2-unit Lecture and 1-unit Laboratory)
For Midterm:
V02-2020-07-01
STANDARD TRANSMUTATION TABLE FOR ALL COURSES
CLASS POLICIES
A. Attendance
Students are not allowed to have 20% or more unexcused absences of the total face to face class hours; otherwise, they will be graded
as “DROPPED”.
B. Classroom Decorum
V02-2020-07-01
During distance mode
Students are required to:
1. sign an honor system pledge;
2. avoid giving or receiving unauthorized aid of any kind on their examinations, papers, projects and assignments,
3. observe proper netiquette during on-line activities, and
4. submit take home assignments on time.
C. Examination/ Evaluation
1. Quizzes may be announced or unannounced.
2. Mid-term and Final Examinations are scheduled.
3. Cheating is strictly prohibited. A student who is caught cheating will be given a score of ”0” for the first offense. For the second
offense, the student will be automatically given a failing grade in the subject.
4. Students who will miss a mid-term or final examination, a laboratory exercise or a class project may be excused and allowed to
take a special exam, conduct a laboratory exercise or pass a class project for any of the following reasons:
a. participation in a University/College-approved field trip or activity;
b. due to illness or death in the family; and
c. due to force majeure or natural calamities.
REFERENCES & SUPPLEMENTARY READINGS
References:
A. Required Textbook/Workbook
C. Reference Books
Connolly, T.M. & Begg, C.E. (2005). Database systems: A practical approach to design, implementation and
management.
Hoffer, J., Ramesh, V., & Topi, H. (2013). Modern database management (8th ed). Pearson Prentice Hall
V02-2020-07-01
.
D. Electronic References (E-books/Websites)
Tutorials Point (I) Pvt. Ltd. (2020). DBMS: Database management system. Available from:
https://www.tutorialspoint.com/dbms/dbms_tutorial.pdf
https://www.pdfdrive.com/chapter-1-introduction-database-management-system-dbms-e6817410.html
http://www.TutorialsPoint.com
https://www.mysqltutorial.org/mysql-functions.aspx/
https://www.geeksforgeeks.org/sql-ddl-dql-dml-dcl-tcl-commands/
REVISION HISTORY
Revision
Date of Revision Date of Implementation Highlights of Revision
Number
VPAA-QF-10 Format; Intended Learning Outcome;
1 June 06, 2020 First Semester, AY 2020-2021 Topic; Mode of Delivery; Outcome Based
Assessment; & References
Blended Learning considerations;
2 July 02, 2020 First Semester, AY 2020-2021
Contents; TLA; OBA; & References.
3 August 30, 2021 First Semester, AY 2021-2022 Revised based on flexible learning approach
4 September 11, 2022 First Semester AY 2022-2023 Minor revision schedule and who prepared
V02-2020-07-01
khenilyn_lewis@cvsu.edu.ph
Date Prepared: September 11, 2022
Date Evaluated:
V02-2020-07-01