IT207 - Fundamentals of Database Systems Syllabus [2020-2021 1st Sem] PDF

Preview

Summary

Revision: 001 Date: 29 July 2019Republic of the PhilippinesSOUTHERN LEYTE STATE UNIVERSITYMain Campus, Sogod, Southern Leytewebsite: slsuonline.eduemail: slsumaincampus@gmail /[email protected] telefax: (053) 577-COURSE SYLLABUSIT207/IT207L – Fundamentals of Database Systems 1 st Semester, AY 2020-N...

Description

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

Republic of the Philippines SOUTHERN LEYTE STATE UNIVERSITY Main Campus, Sogod, Southern Leyte website: www.slsuonline.edu.ph email: [email protected] / [email protected] telefax: (053) 577-8299 COURSE SYLLABUS IT207/IT207L – Fundamentals of Database Systems 1st Semester, AY 2020-2021 National Goal

: The attainment of globally competitive Filipinos through quality and excellent education, relevant and responsive to changing environment, accessible and equitable to deserving students, and efficient and effective in optimizing returns and benefits.

Vision

: A high quality corporate science and technology university

Mission

: SLSU will 1) produce S and T leader and competitive professionals; 2) generate breakthrough research in Sand T –based disciplines; 3) transform and improve the quality of life in the communities in the service areas; and 4) be self-sufficient and financially viable

University Goals

: SLSU shall develop comprehensive curricula to produce S and T leaders and professionals; establish a culture of science and technology-based research; facilitate adoption of technology to communities and service areas; intensify production capability; establish transparent, efficient and effective management system.

Quality Policy

: We, at Southern Leyte State University, commit enthusiastically to satisfy our stakeholders’ needs and expectation by adhering to good governance, relevance, and innovations of our instruction, research and development, extension and other support services and to continually improve the effectiveness of our Quality Management Systems in compliance to ethical standards and applicable statutory, regulatory, industry and stakeholders’ requirements.

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

The management commits to establish, maintain and monitor our quality management system and ensure that adequate resources are available. : Service Excellence Leadership Competence Stewardship and Accountability Unity in Diversity

Core Values

Program Outcomes A. Common to all programs in all types of schools The graduates have the ability to: a.) b.) c.) d.) e.)

Articulate and discuss the latest developments in the specific field of practice. Effectively communicate orally and in writing using both English and Filipino Work effectively and independently in multi-disciplinary and multi-cultural teams. Act in recognition of professional, social, and ethical responsibility. Preserve and promote “Filipino historical and cultural heritage”.

B. Common to the discipline f.) Analyze complex problems, and identify and define the computing requirements needed to design and appropriate solution g.) Apply computing and other knowledge domains to address real-world problems. h.) Design and develop computing solutions using a system-level perspective. i.) Utilize modern computing tools C. Specific to Bachelor of Science in Information Technology j.) Apply knowledge of computing, science, and mathematics appropriate to the discipline.

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

k.) Understand best practices and standards and their applications. l.) Analyze complex problems, and identify and define the computing requirements appropriate to its solution. m.) Identify and analyse user needs and take them into account in the selection, creation, evaluation and administration of computerbased systems. n.) Design, implement and evaluate computer-based systems, processes, components, or programs to meet desired needs and requirements under various constraints. o.) Integrate IT-based solutions into the user environment effectively. p.) Apply knowledge through the use of current techniques, skills, tools and practices necessary for the IT profession. q.) Function effectively as a member or leader of a development team recognizing the different roles within a team to accomplish a common goal. r.) Assist in the creation of an effective IT project plan. s.) Communicate effectively with the computing community and with society at large about complex computing activities through logical writing, presentations and clear instructions t.) Analyze the local and global impact of computing information technology on individuals, organizations, and society. u.) Understand professional, ethical, legal, security, and social issues and responsibilities in the utilization of information technology. v.) Recognize the need for and engage in planning self-learning and improving performance as a foundation for continuing professional development. D. Institutional Outcomes

w.) Responsible IT professional who can develop and contribute to the advancement in ICT field with global mindset. E.

SLSU BS Information Technology graduates should be:

A.) Critical Thinking B.) Conceptual Thinking C.) Global Mindset D.) Open-Minded E.) Personal Responsibility

F.) Leadership and Management Skills G.) Learning to Learn Skills H.) Problem Solving Skills I.) Research Skills

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

C0URSE NAME

COURSE DESCRIPTION

NUMBER OF UNITS PREREQUISTE

IT207 / IT207L – Fundamentals of Database Systems Developing and managing efficient and effective database applications requires understanding the fundamentals of database management systems, techniques for the design of databases, and principles of database administration. This course emphasized database concepts, developments, use and management in three main sections: database concepts, practice, and emerging trends. Relational database systems are the main focus, but other types, including object-oriented databases, are studied. Practical design of data-bases and developing database applications using modern software tools will be emphasized. Understand the theories and techniques in developing database applications and be able to demonstrate the ability to build databases using enterprise DBMS products such as Oracle or SQL Server. 3 units (1 hour lecture/3 hours lab) None

A. Course Details

B. Course Outcomes and Relationship to Program Outcomes

Course Outcomes After completing this course, the student should be able to:

Program Outcomes j

k

l

n

m

o

p

q

r

s

E

E

E

E

E

E

E

I

E

E

E

E

E

E

E

I

E

E

E

E

E

E

E

I

Knowledge(Think) 1. Examine query functions used for selecting and organizing database records according to user specified data requirements.

Skills(Do) 2. Design queries to correctly retrieve, restrict and sort data from database tables based on a specified set of fata requirements

Values (Feel) 3. Adapt a sound relational design principles in database to achieve the

t

u

v

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

formulated user requirement. C. Lec/Lab Learning Plan Graduate Attribute and CDIO Skills Graduate Attribute: Global Mindset

Graduate Attribute: Global Mindset Open Minded CDIO Skillset: Communications

Intended Learning Outcomes Explained and interpret the national and regional goal, University vision and mission, Campus objectives, program objectives, and relate the overall course outline, grading system and requirements.

ILO1. Define the purpose of a database system, Discuss the theoretical and physical aspect of a relational database and Describe the Oracle server’s implementation of relational database management system (RDBMS) and object relational database

Topics

Allotted Time in Hours

Teaching & Learning Activities

Assessment Tasks PBA

Orientation 1hr 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 1.

2. 3.

National Goal SLSU Vision, Mission, Goals, Objectives and Quality Policy Program Objectives Program Outcomes Course Outcomes Course Outline Course Grading System Course Requirements Gender Awareness and Development (GAD) Student/s with Special Needs Academic Integrity Disaster and Risk Preparedness Overview of relational database management concepts and terminologies Human Resource Schema and the tables used in this course Introduction to SQL and its developments

Instructional Materials

Lecture Online, Mobile & Blended Learning Team-based Learning

7 hours

Case Based Learning Online, Mobile and blended Learning Lecture

The students should understand and inculcate the SLSU VMGO, its policy and core values

Exams/Test

Course Syllabus (IT 207) Student Handbook

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

Graduate Attribute: Global Mindset Open Minded

management system (ORDBMS) ILO2. Execute a basic SELECT statement, List the capabilities of SQL SELECT statements.

1. Capabilities of SQL SELECT statements 2. Arithmetic expressions and NULL values in the SELECT statement 3. Column aliases 4. Use of concatenation operator, literal character strings, the alternative quote operator and the DISTINCT keyword 5. DESCRIBE command

4 hours

ILO3. Use ampersand 1. Limiting rows with substitution to restrict and  The WHERE clause sort output at run time,  The Comparison and Logical conditions Limit the rows that are retrieved by a query, sort 2. Rules of precedence for operators in an expression the rows that are retrieved 3. Sorting rows using the ORDER BY clause by a query. 4. SQL row limiting clause in a query 5. Substitution variables 6. DEFINE and VERIFY commands

4 hours

CDIO Skillset: Communications

Graduate Attribute: Global Mindset Open Minded CDIO Skillset: Communications

Midterm Examination Sub-total Graduate Attribute: Global Mindset Open Minded CDIO Skillset: Communications

ILO4. Describe the various types of functions available in SQL, use the character, number and date functions in SELECT statements

1. 2. 3. 4. 5. 6.

Single-row SQL functions Character functions Nesting functions Number functions Working with dates Date functions

Problem Based Learning Online, Mobile and blended Learning Lecture Scenario Based Learning Online, Mobile and blended Learning Lecture

2 hours 18 hours 6 hours

Scenario Based Learning Online, Mobile and blended

Exams/Test

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

Graduate Attribute: Global Mindset Open Minded CDIO Skillset: Communications

Graduate Attribute: Global Mindset Open Minded CDIO Skillset: Communications

ILO5. Describe the various types of conversion functions that are available in SQL, Apply conditional expressions in a SELECT statement.

1. Implicit and explicit conversion 2. TO_CHAR, TO_DATE, functions 3. General functions 4. Conditional Expressions

data

type

TO_NUMBER

ILO6. Identify the 1. Group functions: available group functions,  Types and syntax Describe the use group  Use AVG, SUM, MIN, MAX, COUNT functions, Group data bu  Use the DISTINCT keyword within using the GROUP BY clause group functions Include or exclude grouped  NULL values in a group functions rows by using the HAVING 2. Group rows: clause  GROUP BY clause  HAVING clause 3. Nesting group functions Final-term Examination Sub-total Grand Total

6 hours

4 hours

Learning Lecture Scenario Based Learning Online, Mobile and blended Learning Lecture Scenario Based Learning Online, Mobile and blended Learning Lecture

2 hours 18 hours 36 hours

D. References: 1. Connolly, T.M, & Begg, C.E. (2005). Database systems: a practical approach to design, implementation, and management. Pearson Education. 2. Elmasri, R., & Navathe, S. (2010). Fundamentals of Database systems. Addison-Wesley Publishing Company.

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

3. 4. 5. 6. 7. 8. 9.

Silberschatz, A. Korth, H.F., & Sudarshan, S. (1997) Database system concept (Vol. 4). New York: McGraw-Hill. MySQL Documentation. [Online]. Available: https://dev.mysql.com/doc. Retrieved on 2018, August 6 MySQL Workbench [Online]. Available: https://www.msql.com/products/workbench/. Retrieved on 2018, August 6 MySQL GUI Tools. [Online]. Available: https://downloads.mysql.com/archives/gui/. Retrieved on 2018, August 6 XAMPP – Database Server. [Online]. Available: https://www.apachefriends.org/index.html/. Retrieved on 2018, August 6 PHP Web Development. [Online]. Available: https://github.comredlinx/PHP-Web-Development. Retrieved on 2018, August 6 PHP Online Documentation for MySQL Drivers and Plugins. [Online]. Available: http://php.net/manualen/set.msqlinfo.php . Retrieved on 2018, August 6

E. Grading System

A. Lecture Term Exam Quizzes Project Total

50 % 30 % 20 % 100%

B. Laboratory Term Exams 60 % Laboratory Exercised 20 % Projects 20 % Total 100%

Final Grade = Midterm Grade + Final Grade 2 F. Provisions for Flexibility:  

Students with special needs shall be dealt with appropriately depending on the course activities /requirements. The syllabus is updated, the new topics included in this updated syllabus are the following; Professions and Careers in the Different Computing Field, Evolution of Computing & Number System Representation, Computer Security & Networks, Web Development and Computer Systems.

Prepared by:

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

RENE C. RADAZA, MSIT Instructor

ARMAN MASANGKAY Instructor

Recommending Approval:

JAMES BRIAN FLORES, Ph. D. Head, IT Department

Approved:

ALEX C. BACALLA, DIT Dean, CCSIT

ALEX C. BACALLA, DIT Instructor

JUNE VIC W. CADAYONA Instructor

FRANCIS REY F. PADAO, MIM Instructor

Doc. Code: SLSU-QF-IN01 Revision: 001 Date: 29 July 2019

CONFIRMATION AND ACKNOWLEDGEMENT This is to confirm that the contents of the course syllabus in IT207/ IT207L Fundamentals of Database Systems, 1st Semester, 2020 -2021 at SLSU, were discussed to us during the first day of class and a copy of which was provided for reproduction and individual reference and guide. Name of Student

Course & Year

Signature

Name of Student

Course & Year

Signature...