数据库系统课件introduce1.pdfVIP

Database systems ➢教学目标： ➢掌握关系数据库设计 （包括数据库概念建模和关系数据 库模型的设计）和编程 （包括关系模型代数运算和数据 库语言SQL）的基本概念和原理； ➢掌握数据库设计和编程的一般过程和基本方法； ➢能自主开发和 简单的数据库系统； ➢提高专业英文资料的查阅能力 2 Database systems ➢ ➢ Jeffrey D.Ullman, Jennifer Widom. A first course in database systems. 机械工业 ， 2008. ➢参考资料 ➢Jeffrey D.Ullman, Jennifer Widom. 数据库系 统基础 . 岳丽华译. 机械工业 ，2003. ➢Abraham Silberschatz, Henry E Korth, S.Sudarshan. Database System Concepts. 机械工业 ➢ 3 Database systems ➢教学安排： 48 hours ➢Classroom teaching 40 hours ➢Practice 8 hours ➢考查方式： ➢Final exam 70% ➢ 15% ➢Project 15% 4 1 The Worlds of Database Systems ➢The Evolution of Database Systems ➢Overview of a DBMS ➢Outline of Database System Studies 5 1.1 The Evolution of Database Systems What’s a database? ➢In essence, a database is a collection of information that exists over a long period of time, often many years. 6 1.1 The Evolution of Database Systems Database Applications: Universities: registration, grades Airlines: reservations, schedules Banking: all transactions Sales: customers, products, purchases Online retailers: order tracking, customized mendations Manufacturing: production, inventory, orders, supply chain Human resources: employee records, sa