Embedded Files
PROGRAM CORE
Credit hour : 3
Pre-requisite: Foundation of Programming
Knowledge Area : Computing and Computer Fundamentals (CCF) Sub domain : Storage System Fundamentals
Synopsis
This course emphasizes the knowledge and skills pertaining to the theory and concepts needed in the development of a database system. Students will learn the fundamental concepts of database, entity relationship model, relational model, structured query language and normalization. Besides that, this course offers the foundations of Human Computer Interactions (HCI) and ethics in Database and HCI.
Course Content
Chapter 1: Introduction to Database System
Types of Databases and Database Applications
Typical DBMS Functionality
Example of a Database
Main characteristics of the Database Approach Database Users
Chapter 2: Database System Concepts and Architecture •
Data Models and Their Categories •
Schemas, Instances, and States •
Three-Schema Architecture •
Data Independence •
DBMS Languages and Interfaces •
Database System Utilities and Tools •
Centralized and Client-Server Architectures •
Classification of DBMSs
Chapter 3 : The Relational Data Model and Relational Database Constraint
Relational Model Concepts
Relational Model Constraints and Relational Database Schemas
Update Operations and Constraint Violations
Chapter 4 : Relational Database Design by ER- and EERR-to-Relational Mapping
ER-to-Relational Mapping Algorithm
Mapping EER Model Constructs to Relations
Chapter 5 : Data Modeling Using the Entity-Relationship (ER) Mode
Database Design Process
Database Application
ER Model Concepts
ER Diagrams
Notations – UML class diagrams
Chapter 6 : Functional Dependencies and Normalization for Relational Databases
Design Guidelines for Relational Databases
Functional Dependencies
Normal Forms Based on Primary Keys
General Normal Form Definitions (For Multiple Keys)
BCNF (Boyce-Codd Normal Form)
Chapter 7 : SQL
Schema, Definition, Basic Constraints, and Queries
SQL Statements
Joining Multiples Tables and Setting Keys
Joining Multiples Tables and Setting Keys Application
Joining Multiples Tables and Combining Results More than One SQL Command Line
Chapter 8 Human Computer Interactions (HCI) Foundations
Introduction to HCI
Applications of media
Additive and subtractive color models
HCI in software process
Design rules
Chapter 9 Designing Interactions
Principles of graphical user interfaces (GUIs)
Elements of visual design
Evaluation Technique
Chapter 10 Ethics in Database and HCI
Social implications of computing in a networked world
Accountability, responsibility and liability
Cultural and environmental impacts of the database and HCI design
References
Silberschatz A., Korth H. F., Sudarshan S. (2019) Database System Concepts, 7th Edition, McGraw-Hill
Carlos Coronel , Steven Morris and Peter Rob.(2019) Data Systems Design Implementation and Management, 13th Ed. Cengage Learning
Dix A., Finlay J. E., Abowd G.D, Beale R. (2003) Human-Computer Interaction, 3rd Edition, Pearson
Prepared By:
Ts. Dr. Nuraminah Ramli
Page updated
Report abuse