Transcript Database System Design and Implementation
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