SECP2523 - 01 Database (WBL)

Lecturer: Dr Nor Hawaniah Zakaria

This course introduces students to the concept of database system and how it can be used in daily human life and profession. The focus of the course is to equip students with knowledge and skills on important steps and techniques used in developing a database, especially in the conceptual and logical database design phase. Among topics covered are database environment, database design, entity relationship diagram, normalization, and structured query language (SQL). Students will be taught to use a database management system (DBMS). Students are required to work on a project, i.e. to develop a database application system, for a selected organization. In this project, students are required to work closely with the organization during the process of analysis, designing and implementing the system and to use the learned techniques, DBMS and development tools in the development process. At the end of the course, students should be able to apply the knowledge of designing and developing a good database system for a real world problem

Image

Chapters

  1. Overview of Database Concepts
  2. The Relational Model and Relational Database
  3. DB System Development Lifecycle
  4. SQL: Data Definition Language (DDL)
  5. SQL: Data Manipulation Language (DML)
  6. Advance SQL
  7. Database Design

 

WBL

  1. Problem formulation in industry & Project Proposal
  2. Conceptual design of the system’s database
  3. Logical design of the database
  4. Prototype development: Develop SQL queries for the proposed system
  5. Prototype development: Develop complete application
  6. Prototype development: Conduct user testing
  7. Submit Project Final Report