Database systems Design

- Software School of Hunan university – 2006.08

Course Information

• Instructor:

Liubo Ouyang

( 欧阳柳波 ） Office: Room 213, Building of software School Contact: 13574805086, 8821984, [email protected]

• Experiment tutor:

Shaofei Lu

( 陆绍飞 ) Contact: 13036780732, [email protected]

• Textbook: Thomas Connolly, Carolyn Begg. Database systems – APractical approachs to Design, Implementation, and management, third Edition. 电子工业出版社 .

• Course Material at web site: http://ss.hnu.cn/oylb/dbsd/ Copies of all lecture slides and interesting articles will be provided at the web site.

• There are also an enormous number of Database System internet sites.

A First Course in Database Systems

: http://www-db.stanford.edu/~ullman/fcdb.html

Database System Design and Implementation

: http://www-2.cs.cmu.edu/~christos/courses/721.S03/

ACM Transactions on Database Systems (TODS)

http://www.acm.org/tods/

• Grade: HWs 10%, Project 25%, Final 50%, participation 15% • Project: – PBLT method (3 students in a team) • Plagiarism will be severely punished. • People who is absent from lecture for three times will not be permitted to seat in the final exam.

• English writing

Pre-requisites And Related Courses

– Data structure – Discrete mathematics – Computer principle.

– Software Programming

Objectives

To provide a solid foundation on database systems and database application development.

–To master the knowledge of Database systems design.

-To master fundamental ideas of database technology.

-To learn how to design databases using ER diagrams and the relational model -To know current new technology on database To improve the level of speaking, writing, demonstrating, behaving, communicating, collaborating, innovating, and inventing.

Database Implementation Project

 A significant part of your learning of the course is devoted to a major database development project.

   Design a database using ER diagrams and relational model.

Write SQL to query and update the database.

Develop a web user interface to your database.

－ In the process you will learn HTML and ASP or JSP.

 Those skills are highly valuable to your future individual development.

• Background

Course Topics

Introduction to Database Database Environment • The Relational Model and Languages The Relational Model Relational Algebra and Relational Calculus SQL RDBMS • Database Analysis and Design Techniques Database Planning, Design, and Administration Entity-Relationship Modeling Normalization

• Methodology

Course Topics

Conceptual Database Design Logical Database Design for the Relational Model Physical Database Design for the Relational Databases • Selected Database Issues Security Transaction Management Query Processing Programming SQL • Current Trends Distributed Database Object-Oriented Database

Course Topics

• Emerging Trends Web Technology and DBMSs Semi-structure Data and XML Data Warehousing OLAP and Data Mining