数据库第1次课数据库系统前言.ppt

数据库系统教程 主讲：司利云 Study Aim of This Curriculum Importance of database technology Supporting technology of information age Key technology for promoting popularization of computer and internet Study Aim of This Curriculum Database Applications: Banking: all transactions Airlines: reservations, schedules Universities: registration, grades Sales: customers, products, purchases Manufacturing: production, inventory, orders, supply chain Human resources: employee records, salaries, tax deductions Databases touch all aspects of our lives Study Planning of This Curriculum 共36学时 数据库系统的概念、原理与设计方法等内容，讲授20个学时 数据库设计的亲自实践，上机16学时 考核方法 平时成绩+实验成绩 占20% 考试成绩 占80% 另注：请假要有假条，无正当旷课一次 扣15分，迟到一次 扣5分。 Major Parts of This book Chapter1~5是重点章节，主要是围绕关系数据库展开。 Chapter1:basic concepts of database technology. Chapter2:Relational model and theory of relational operators. Chapter3:Standard relational database language. Chapter4:Normalization design theory of relational database. Chapter5:Overall process of database design. Other Parts of This book Chapter6~12 自学，包括了对象数据库及网络数据库中所用到的诸多技术，学生应有所了解。 Chapter6: the structure of data storage. Chapter7: database-system implementation, including the transaction management, concurrency control and several techniques for ensuring security and integrity. Chapter8:object-oriented databases. Chapter9: parallel databases. Chapter10~12: network database design technique. Development History of Database 1.W.Backman 62年： IDS—Integrated Data Store 2.System Development Corporation 63—Development and Management of a Computer_Centered Database 65—Development and Management of a Computer_Centered Database Development------------2 Data Independence Data Share Cross-access Expending and Redundancy Model and Data Languages 3.Conference On Data SYstem Languages CODASYL DBTG-----Data Base Task Group 67-71 Data language: DDL----Data Definition Language DML----Data Manipulation Language DBTG---database Network Model 4.IBM IMS----Hierarchical Model 5.E.F.Codd A Relati