Nil
COM1001 資料庫系統應用
COM2007 Database Management System and Data Warehousing
COM2103 Database Design and Management/MSIM3201 Database Design and Management
This module is not available to BA-AHCC/BSC-AC and BMSIM students.
This module is designed for the students in the pursuit of business, finance, marketing and related fields of study. This module aims to enable students to explain the theories of designing, developing, and maintaining a quality database. It will help students to develop an understanding of the role of the data and information in the business environment.
Upon completion of this module, students should be able to:
a. explain relational database concepts and design a relational database in business environment;
b. formulate SQL queries on the data for daily operation in business;
c. appraise how database technology can improve businesses;
d. design relational database using ER diagrams and normalization.
1. Introduction to database
1.1. What is database
1.2. Relational database
2. Conceptual Database Design
2.1. Entity-Relationship modeling
3. Logical Database Design
3.1. Data Dependencies and Normalization
4. Physical Database Design
4.1. Detailed specification of data elements, data types and indexing options
4.2. Creating, editing database
5. Structured Query Language (SQL)
5.1. Learning standard SQL commands
5.2. Using SQL to perform tasks such as retrieve data from a database, updating data on a database
6. Role of data and information management in business environment
6.1. Management planning
6.2. Control activities
6.3. Strategic planning
6.4. Daily operations
1. Assignments (20%)
2. Mid-term Examination (20%)
3. Final Examination (60%)
1. *Michael V.Mannino (2011). Database Design, Application Development, & Administration (5thed.). New York: McGraw-Hill.
