COMP9311 Database Systems 传送门

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

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容