INFO90002 学习辅助资料

INFO90002 Database Systems & Information Modelling 数据库系统与信息模型 University of Melbourne 墨尔本大学 Graduate coursework 研究生课程 Lecture Slides Tutorial Assignment Exam sample solutions

 

🌟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

 

0 条评论

发表评论