---

Fall Semester, 2018 Databases Ki-Joune Li

---

1. Materials 

_ Introduction (slide)

_ An Overview (slide, video)

_ Data Modelling (slide, video)

_ Relational Model (slide, video)

_ Design Relational Schema (slide, video-1, video-2)

_ Extended Relational Operators (slide, video)

_ SQL (slide, sample-SQL, video)

_ More about SQL (slide, video)

_ Tutorial on PostgreSQL (slide)

_ Interfacing DBMS (slide, env-setting)

_ XML (basic, xsd)

_ Tutorial on JDBC Basics (slide)

2. Assignment

_ Assignment 1

_ Assignment 2

_ Assignment 3

3. Announcements

_ Exam score: link

_ An UML diagram tool, called StarUML, is found at http://staruml.io/

_ Installing PostgreSQL

_ Teaching Assistants

1. Tel : 051 510 2876

2. Office : Building 313, Room 422

---