数据库的lecture(广东工大).pptVIP

Y.Xing Database Principles and Applications YAN XING(邢延) Course Goals This is the unique course in database management systems. You will learn to: Design relational databases Use a relational database (SQL = Structured Query Language) Implement a relational database This course will emphasize on hands-on learning: 16 hours experiment, implement a database application system Course Prerequisite Know how to program C, C++，VB, JAVA,… English skill This course is bilingual If I speak too fast, please tell me to slow down. You can ask questions in English or Chinese. Textbooks (I) Required textbooks: A First Course In Database Systems, Jeffrey D. Ullman and Jennifer Widom 数据库原理与应用，蔡延光主编，机械工业出版社。 Textbooks (II) Other good textbooks on database systems Database System Concepts by Silberschatz Korth, and Sudarsan “Database Systems: The Complete Book”, by Garcia-Molina, Ullman, and Widom Course Format Lecture（32 hours） Tuesday: 8:30~10:05 Friday: 10:25~12:00 Programming Experiment（16 hours） Report is required Exam Grading Breakdown Lecture attendance 10％ of grade Programming experiment report 20％ of grade Exam 70％ of grade Programming Experiment Schedule Contact Information Lecture Notes I will try to send lecture notes to your public email account before each lecture Email: yanxing05@163.com Tel: Lecture Schedule Ch1 The worlds of database systems，Ch2 The relational model of data（2 hours） Ch4 Hihg-level database models（8 hours） Ch5 Algebraic and Logical query languages (4 hours) Ch6 The database language SQL，Ch7 Constraints and trigger，Ch8 Views and Indexes （10 hours） Ch9 SQL in a Server Environment—SQL Server 2000 （2 hours） Ch3 Design theory for relational databases （2 hours） Review (2 hours) Exam (2 hours) Ubiquitous Computing (普适计算) （Won’t be Tested ） (I) Data Are Everywhere Data are everywhere Data volume：huge Data format：text、image、audio、video,etc Data storage：central