Introduction to Database #

주교재 : J.D. Ullman and J. Widom, A First Course in Database Systems, Prentice Hall#

부교재 : A. Silberschatz, H. F. Korth, and S. Sudarshan, Database System Concepts, Mcgraw Hill#

강의 Slides#

차 례	주 제	강의자료
Chap 1	The Worlds of Database Systems	Chapter1.pdf
Chap 2	E/R Model - E/R	Chapter2_1.pdf
Chap 2	E/R Model - Design Principles and Constraints	Chapter2_2.pdf
Chap 3	The Relational Data Model - Relational	Chapter3_1.pdf
Chap 3	The Relational Data Model - Functional Dependency	Chapter3_2.pdf
Chap 3	The Relational Data Model - Normalization	Chapter3_3.pdf
Chap 4	Other Data Models - ODL	Chapter4_1.pdf
Chap 4	Other Data Models - ODL to Relational Model	Chapter4_2.pdf
Chap 4	Other Data Models - Object-Relational, Semistructured Data and XML	Chapter4_3.pdf
Chap 5	Relational Algebra - Algebra	Chapter5_1.pdf
Chap 5	Relational Algebra - Bags, Extended RA, and Constraints	Chapter5_2.pdf
Chap 6	Using PostgreSQL	using-postgresql-2up.pdf
Chap 6	Intro to SQL - Queries	Chapter6_1.pdf
Chap 6	More SQL-DB Modification, Schema, View	Chapter6_2.pdf
Chap 7	Constraints and Assertions	Chapter7.pdf
Chap 8	System Aspects of SQL - EmbeddedSQL	Chapter8_1.pdf
Chap 8	System Aspects of SQL - PSM and PL and PL/SQL	Chapter8_2.pdf
Chap 8	System Aspects of SQL - Transaction	Chapter8_3.pdf
Chap 8	System Aspects of SQL - SQL Environment and Authrization	Chapter8_4.pdf

보조 자료#

CentOS 5에 PostgreSQL 설치하기	install_postgresql_centos5.html
PostgreSQL 초기화 SQL 파일	fcdb_postgresql.sql
Windows에 PostgreSQL 서버와 클라이언트 설치하기	PostgreSQL Setup.pdf
CentOS 5에 Oracle XE 설치하기	install_oraclexe_centos5.html
Oracle 초기화 SQL 파일	fcdb_oracle.sql
Ullman's Oracle Guide	http://infolab.stanford.edu/~ullman/fcdb/oracle.html
PostgreSQL JDBC Demo Program	jdbc-demo-postgresql.tgz
PostgreSQL ECPG Demo Program	ecpg-demo.tgz
Oracle XE JDBC Demo Program	jdbc-demo-oracle-xe.tgz
Oracle ADO.NET Demo Program	ado.net-demo.zip
Oracle Pro*C Demo Program	proc-demo.tgz
(old)컴퓨터공학전공 Oracle 사용하기	UsingOracle.pdf
(old)교재에 준하는 예제 데이터베이스 구축하기	Database.pdf