2nd Semester, SY 2021-2022

2 nd Semester, SY 2021-2022. Course Description: This course is a 3-unit course for second year BSIT students with 2 unit/2 hrs lecture and 1 unit/3 hrs laboratory. It covers information management, database design, data modelling, SQL, and implementation using relational database system..

WVSU as the center for educational excellence in the Visayas and the hub for Human Resource Development in the Asia-Pacific region..

WVSU is committed to provide holistic education geared towards sustainable growth and development..

S cholarship H armony I nnovation N urturance E xcellence S e rvice.

Program/Degree Outcomes: Based on CMO No. 25, s. 2015.

TA-SE (TUNING Asia-South East) Generic Competencies:.

Course Outcomes. LO1: Analyzed an existing database system with respect to quality issues reliability, scalability, efficiency, effectiveness and security. LO2: Designed a database based on user requirements using widely used modelling notation, and be able to use declarative query language to elicit information..

Course Content. UNIT SUBJECT MATTER WEEK 0 Vision, Mission, Core Values, and Outcomes 1 1 Introduction of the Information Management 2-3 2 Database Systems 4 3 Data Model 5 4 The Relational Database Model 6-7 5 Entity Relationship (ER) Modeling 7-8 MIDTERM EXAM 9 6 Advanced Data Modeling 10-11 7 Normalization Of Database Table 11-12 8 Introduction to Structured Query Language (SQL) 12-14 9 Database Design 14-16 10 Database Implementation 16-17 FINAL 18.

Criteria for Grading. Lecture (40%) Laboratory (60%) Components Percentage Components Percentage Quizzes/Assessment 40% Laboratory Activities 100% Midterm/Final Exam/Alternative Learning Assessment 60% Total 100% Total 100% Midterm Grade and Tentative Final Grade = 40% lecture + 60% laboratory Final Grade = 1/3(Midterm Grade) + 2/3(Tentative Final Grade).

ID_NO 00994 Fname Mercedes Lname Pagunsan MName Casalmer Addr Rizal Ilawod , Calinog , Iloilo Tel_No 033-3931134 Program BSIT Year 2 Section C.