Fall Semester, 2019 ¡© Databases ¡© Ki-Joune Li
1. Materials
A. Introduction
(slide)
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/
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.