1 / 10

Database systems Design - Software School of Hunan university – 2006.08

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, ouyangliubo@126.com Experiment tutor: Shaofei Lu ( 陆绍飞 )

sylvia
Download Presentation

Database systems Design - Software School of Hunan university – 2006.08

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database systems Design- Software School of Hunan university –2006.08

  2. Course Information • Instructor: Liubo Ouyang (欧阳柳波） Office: Room 213, Building of software School Contact: 13574805086, 8821984, ouyangliubo@126.com • Experiment tutor:Shaofei Lu (陆绍飞) Contact: 13036780732, sflu@hnu.cn • Textbook: Thomas Connolly, Carolyn Begg. Database systems – APractical approachs to Design, Implementation, and management, third Edition. 电子工业出版社.

  3. 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/

  4. 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

  5. Pre-requisites And Related Courses • Data structure • Discrete mathematics • Computer principle. • Software Programming

  6. 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.

  7. 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.

  8. Course Topics • Background • 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

  9. Course Topics • Methodology • 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

  10. Course Topics • Emerging Trends • Web Technology and DBMSs • Semi-structure Data and XML • Data Warehousing • OLAP and Data Mining

More Related