上海交通大学：《程序设计基础》课程教学讲义（密西根学院）Lecture Notes_15 Introduction to matlab

上海交通大学：《数据库系统原理 The principle of Database System》教学资源_Chapter 1 Introduction

上海交通大学：《数据库系统原理 The principle of Database System》教学资源_第二章习题与答案（第三版）

上海交通大学：《数据库系统原理 The principle of Database System》教学资源_第三章习题与答案（第三版）

上海交通大学：《数据库系统原理 The principle of Database System》课程教学资源（课件讲稿）chapter8 Views, Indexes

Keys and foreign keys Constraints on attributes and tuples Modification of constraints Assertions triggers

About SQL SQL is a standard database language, adopted by many commercial systems. ANSI SQL, SQL-92 or SQL2, SQL99 or SQL3 extends SQL2 with object￾relational features. SQL2003 is the collection of extensions to SQL3. How to query the database How to make modifications on database Transactions in SQL

Relational operations (chapter 2) Extended operators Datalog: a logic for relations Relational algebra and Datalog

Entity/Relationship Models (E/R diagram) Unified Modeling Language (UML) Object Definition Language (ODL) Hot to Transfer them to a relational model

Functional Dependencies Decompositions Normal Forms (BCNF, 3NF) Multivalued Dependencies (and 4NF) Reasoning About FD’s + MVD’s