• Introduction

    Course Overview:
    Database System course introduce the concept and terms in database, database model, entity relational database, introduction to SQL and others. Students can learn several types of database and how to illustrate the database with its entity. It is expected that through this course, students are able to design the database system by using SQL.

    Learning Outcomes:

    1. Understand basic concept, advantages and disadvantages of database
    2. Understand model of database and components related to database
    3. Learn relational database model
    4. Using SQL command to manipulate data in database
    5. Understand entity relationship model
    Assessment:
    1. Individual and Group Assignments                                   20 %
    2. Quizzes                                                                                     10 %
    3. Midterm Exam                                                                        30%
    4. Final Exam                                                                               40%
    Text Books/Resources:
    1. Connoly, Thomas; Begg, Carolyn; Strachan, Anne; Database Systems: A Practical Approach to Design, Implementation and Management (6th Edition), Pearson, 2014
    2. Elmasri, Ramez; Navathe, Shamkant B.; Fundamentals of Database Systems (6th Edition), Boston Addison-Wesley, 2011
    3. Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan. Database System Concepts (6th Edition), McGraw-Hill Education, 2010

◄12. Data Manipulation (sub query and procedure)FINAL EXAM►

13. Case Study

◄12. Data Manipulation (sub query and procedure)FINAL EXAM►