关键词 > MSBA7024/MACC7020
MSBA7024 / MACC7020 Database Design and Management
发布时间：2022-02-19
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
MSBA7024 / MACC7020 Database Design and Management
|
COURSE DESCRIPTION |
|
The ability to store, retrieve, and manipulate data using modern database systems is essential to the success of business analytics projects. Besides relational databases that have been widely used in transactional systems and dimensional databases that have been the core of data warehouses, non-relational databases (often referred to as NoSQL databases) have also gained much popularity in business analytics because of their flexibility to handle semi- structured and unstructured data. This course aims to introduce the fundamental principles of the design, development, and administration of various database models for students with no prior experience and knowledge in database management. In this course, students will learn the basic concepts involved in the design and management of relational databases, dimensional databases, and NoSQL databases for business analytics. |
|
COURSE OBJECTIVES |
|
- Introduce the fundamental principles of design, development, and administration of database management systems for students with no prior experience and knowledge in database management.
|
|
PROGRAMME LEARNING OUTCOMES |
|
PLO1: Acquisition and internalization of knowledge of the programme discipline PLO2: Application and integration of knowledge PLO3: Inculcating professionalism and leadership PLO4: Developing global outlook PLO5: Mastering communication skills |
|
COURSE LEARNING OUTCOMES |
|||||
|
Course Learning Outcomes |
Aligned Programme Learning Outcomes |
||||
|
After taking this course, students should be able to: CLO1. Define and explain the characteristics, advantages and disadvantages of relational databases, dimensional databases, and NoSQL databases. CLO2. Describe the importance of data modeling concepts and use these effectively. CLO3. Plan and design a database. CLO4. Use database management systems such as MySQL and MongoDB to manage data for business analytics project. |
PLO1, 4, 5
PLO1, 4, 5 PLO1, 2, 3 PLO1, 2, 3 |
||||
|
COURSE TEACHING AND LEARNING ACTIVITIES |
|||||
|
Course Teaching and Learning Activities |
Expected contact hour |
Study Load (% of study) |
|||
|
T&L1. Interactive lectures T&L2. Online forum discussions T&L3. Assignments & Tutorials T&L4. Lecture preparation & Self-study |
30 6 42 42 |
25% 5% 35% 35% |
|||
|
Total |
120 |
100% |
|||
|
|
|||||
|
Assessment Methods |
Brief Description (Optional) |
Weight |
Aligned Course Learning Outcomes |
||
|
A1. In-class & forum participation A2. Assignments A3. Final exam |
Attendance & discussions Effort and accuracy Effort and accuracy |
20% 40% 40% |
CLO1, 2, 3, 4 CLO1, 2, 3, 4 CLO1, 2, 3, 4 |
||
|
|
Total |
100% |
|
||
|
|
|||||
