Database System

Section outline

• Select section Introduction

  Introduction

  Go to section 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 (6^th Edition), Pearson, 2014
  2. Elmasri, Ramez; Navathe, Shamkant B.; Fundamentals of Database Systems (6^th Edition), Boston Addison-Wesley, 2011
  3. Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan. Database System Concepts (6^th Edition), McGraw-Hill Education, 2010

  
  

  • Select activity Announcements

    

    Announcements Forum
• Select section 1. Database Management System

  1. Database Management System

  Go to section 1. Database Management System

  For this first e-campus, I want all groups submit your presentation material in the ppt format.
  We will use your group tasks for our discussion.
  The group tasks should be in the following format:
  1. ERD;

  2. Data Dependency Diagram (where all tables should confirm to 3NF);
  3. The structure of the data from SQL;

  4. The data that you have inserted into the tables.

  Activities: 3
• Select section 2. Data Modeling

  2. Data Modeling

  Go to section 2. Data Modeling

  ASSIGNMENT BY GROUP

  Activities: 1
• Select section 3. DB Design

  3. DB Design

  Go to section 3. DB Design

  DB Design and Query
  

  Activities: 1
• Select section 4. Entity Relational Diagram

  4. Entity Relational Diagram

  Go to section 4. Entity Relational Diagram

  Activities: 0
• Select section 5. CLASS REVIEW

  5. CLASS REVIEW

  Go to section 5. CLASS REVIEW

  CLASS REVIEW
  

  Activities: 1
• Select section 6. Case Study (ASSIGNMENT 2)

  6. Case Study (ASSIGNMENT 2)

  Go to section 6. Case Study (ASSIGNMENT 2)

  ASSIGNMENT 2
  

  Activities: 2
• Select section 7. MySql

  7. MySql

  Go to section 7. MySql

  Activities: 0
• Select section 8. Database Configuration and Backup

  8. Database Configuration and Backup

  Go to section 8. Database Configuration and Backup

  Activities: 0
• Select section 9. Data Manipulation (SQL Queries)

  9. Data Manipulation (SQL Queries)

  Go to section 9. Data Manipulation (SQL Queries)

  SELECT Queries 

  Activities: 1
• Select section 10. Data Manipulation (JOIN OPERATION)

  10. Data Manipulation (JOIN OPERATION)

  Go to section 10. Data Manipulation (JOIN OPERATION)

  JOIN OPERATION
  

  Activities: 1
• Select section 11. Data manipulation (multi query)

  11. Data manipulation (multi query)

  Go to section 11. Data manipulation (multi query)

  Activities: 0
• Select section 12. Data Manipulation (sub query and procedure)

  12. Data Manipulation (sub query and procedure)

  Go to section 12. Data Manipulation (sub query and procedure)

  Activities: 0
• Select section 13. Case Study

  13. Case Study

  Go to section 13. Case Study

  Activities: 0
• Select section FINAL EXAM

  FINAL EXAM

  Go to section FINAL EXAM

  MONDAY APRIL 27, 13.00-15.30

  Activities: 2