🌟INFO90002 Database Systems & Information Modelling
数据库系统与信息模型
🏫University of Melbourne - Graduate coursework
墨尔本大学研究生课

学习目标

The subject introduces key topics in modern information organisation, particularly with regard to structured databases. The well-founded relational theory behind modern structured query language (SQL) engines, has given them as much a place behind the web site of an organisation and on the desktop, as they traditionally enjoyed on corporate mainframes. Topics covered may include: the managerial view of data, information and knowledge; conceptual, logical and physical data modelling; normalisation and de-normalisation; the SQL language; data integrity; transaction processing, data warehousing, web services and organisational memory technologies. This is a core foundation subject for both the Master of Information Systems and Master of Information Technology.

信息系统硕士与信息技术硕士专业的核心基础课程，重点围绕结构化数据库展开，课程涵盖的内容包括：

• • 数据、信息与知识的管理视角
• • 概念、逻辑与物理数据建模；
• • 数据规范化与反规范化；
• • SQL 语言应用；
• • 数据完整性；
• • 事务处理；
• • 数据仓库；
• • 网络服务及组织记忆技术

课程内容

This subject serves as an introduction to databases and data modelling from a data management perspective. Database design, from conceptual design through to physical implementation will be covered. This will include Entity Relationship modelling, normalisation and de-normalisation and SQL. Additionally the use of databases in various contexts will be explored (web based databases, connecting programs to databases, data warehousing, health contexts, geospatial databases).

• • 实体关系建模
• • 数据规范化与反规范化
• • 结构化查询语言（SQL）的应用
• • 网络数据库
• • 程序与数据库的对接
• • 数据仓库
• • 医疗领域及地理空间数据库的应用

课程资料

• • 【2022】https://github.com/JosieLLL/INFO90002-Database-Modelling-SQL
• • 【2020】https://github.com/infinityglow/INFO90002-Database-System
  
• • 【2019】https://github.com/LeonardDu98/INFO90002-Database

辅助材料

• • INFO90002 Assignment 1 Case Study (PDF): 作业1的案例研究，焦点在关系数据库设计。
  https://www.academia.edu/42717778/INFO90002_Assignment_1_Case_Study
• • 40-pages-databse-summary.pdf: 40页的数据库总结笔记，用于复习。
  https://www.coursehero.com/file/203133168/40-pages-databse-summarypdf/
  
• • sql ddl.docx: SQL DDL笔记，用于作业解读。
  https://www.coursehero.com/file/104811185/Armstrongdocx/
• • Wilks' guide to the M.IT @ Unimelb: 对课程的反思和解读，包括INFO90002作为数据库管理员准备。
  https://wilksjleong.wordpress.com/2017/12/23/some-reflections-on-the-m-it