Transcript Database Design

Database Design
CS562
Fall 2012
CS562 Database Design
• Instructor : Professor Chin-Wan Chung
Office : Rm 3406 Tel : 3537
E-mail : [email protected]
• Lecture (Room 3444)
– Time : Tuesday, Thursday 2:30 PM – 4:00 PM
– Textbook
Conceptual Design : An Entity-Relationship Approach
C.Batani, S.Ceri, and S.Navathe
The Benjamin/Cummings Publishing Company, Inc., 1992
– Reference
Database System Concepts, 6th Edition
A.Silbershatz, H.Korth, and S.Sudarshan, Mc Graw-Hill, 2010
Data Mining : Concepts and Techniques, 3rd Edition
J. Han, M.Kamber, and J, Pei, Morgan Kaufmann, 2012
– English Lecture
• Home page
– http://islab.kaist.ac.kr/Lecture/cs562_2012_Fall/
• Office Hours: Tue 4:00 PM – 5:00 PM
• Homeworks and Projects
–
–
–
–
–
Exercise assigned in the class
Due date : a week from the assigned date (12:00 PM)
Submit to mailbox
Late penalty (20% per day)
2 projects
• Grade : Midterm exam (25%), Final exam(25%),
Homework(10%), Project(25%),
Presentation(5%), Class participation(10%)
• Exam : Thursday 2:30 PM
• Schedule Variation
– Conference or meeting
– Make-up Classes
• TA :MinJoong Lee(이민중, Rm 3441, x7837)
E-mail: [email protected]
Jong Ryul Lee(이종률, Rm 3441, x7837)
E-mail: [email protected]
ByungJin Jeong(정병진, Rm 3436, x7729)
E-mail: [email protected]
Class Schedule (Reading Assignment : Chapter)
Week
Content
Chapter
9/4
Planning
DB System Introduction
9/11
Relational DB
9/18
Relational Commercial Language
9/25
DB Design Introduction
Data Modeling and ER Model
Ch 1
Ch 2
10/2
Data Modeling and ER Model
Conceptual Design Methodology
Ch 2
Ch 3
10/9
Conceptual Design Methodology
View Design
Ch 3
Ch 4
10/16
Schema Integration
Restructuring
Ch 5
Ch 6
10/23
Midterm Exam
10/30
Restructuring
Functional Analysis
Ch 6
Ch 8
11/6
Joint Data and Function Driven Approach
Model Independent Logical Design
Ch 9
Ch 11
11/13
Relational Logical Design
Ch12
11/20
Mining Patterns and Associations
11/27
Indexing
12/4
Project English Presentation
12/11
Project English Presentation
12/18
Final Exam
Project
Project #1
Project #2