Fall Semester, 2019 Databases Ki-Joune Li


1. Materials 

A.     Introduction (slide)

B.     An Overview (slide, video)

C.     Data Modelling (slide, video)

D.     Relational Model (slide, video)

E.      Design Relational Schema (slide, video-1, video-2)

F.      Extended Relational Operators (slide, video)

G.    SQL (slide, sample-SQL, video)

H.     More about SQL (slide, video)

I.       Tutorial on PostgreSQL (slide)

J.       Interfacing DBMS (slide)

K.     XML (basic, xsd)

L.      Tutorial on JDBC Basics (slide)

M.   SQL Exercise (slide, answer)

2. Assignment

Assignment #1 - Reading Assignment

Assignment #2 - UML Class Diagram

Assignment #3 - Relational Model

Assignment #4 - SQL

3. Announcements

A.     Supplementary lectures: Oct. 11, 10:30 – 11:45, 13:30 – 14:45

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

C.      Installing PostgreSQL

D.     Teaching Assistants: Yong Bok CHOI, 051 510 2876, yongbok@pnu.kr, Office : Building 313, Room 422

4. Notice

l  You should install Java, Eclipse, PostgreSQL, and pgAdmin on your laptop before class on December 3.