COMP9311 Database Systems WEEK1:
什么是database,database中的重要概念,什么是data,什么是DBMS,什么是database system,Database Users,DBMS,数据库开发流程,数据库语言,Data Modeling,ER Model,ER Diagrams,entity sets,attributs的keys,relational sets,Subclasses and Inheritance
COMP9311 Database Systems WEEK2:
ER Model,Relational Data Model(Core values,Notice,Integrity Constraints,Describing Relational Schemas),Mapping ER Designs to Relational Schemas(Mapping strong entities,Mapping weak entities)
COMP9311 Database Systems WEEK3:
from 2-way to n-way relationships,Mapping composite attributes,Mapping multi-valued attributes,Derived attributes,Mapping subclasses,Mapping disjoint subclass,Mapping overlapping subclass,Relational DBMSs,Building/Maintaining Databases
COMP9311 Database Systems WEEK4:
SQL基本语法,Regular Expression基本语法
COMP9311 Database Systems Lab1:
配置PostgreSQL环境
COMP9311 Database Systems Lab2&3:
应用postgreSQL实现一个ER design