Unit10 交际的策略Communication Strategy.pptVIP

Unit 10 Sectinon A What is Database? What is database? A database is a collection of information that is organized so that it can easily be accessed, manged and updated in a computer. 数据库是有机组织起来的信息集合，以便在计算机里容易存取、管理和更新。 Applications of Database Why do we need database? Please read P176-177 P170 para3 Applications of Database Databases require management attention because they play many vital roles in business. There are four basic roles of databases: personal data, storing data needed for business operations, providing data for management, and providing external and competitive data. What is relational database? (RDB关系数据库) A RDB is a tabular database. 列表数据库 Please read P170para4, P171para1-4 What is relational database? (RDB关系数据库) A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the databse tables. 关系数据库是有组织的数据表的集合，在不需要对数据库表结构进行修改的条件下，这些对数据进行形式描述的表可以用不同的方式对数据进行存取和重组。 What is relational database? (RDB关系数据库) Database is often used interchangeably with the term table. Technically, they’re different: a table is a single store of related information; a database can consist of one or more tables of information that are related in some way. For, you could track all the infromation about the students in a school in a student table. If you then created separate tables containing details about teachers, classes and classroom, you could combine all for tables into a timetabling database(课程表数据库）. Such a multi-table database is called a relational database. What is the structured query language? (SQL结构化查询语言) SQL is the standar user and application program interface to a relational database. SQL statements are used both for interactive queries for information from a relational database and for gathering data for reports. SQL语言是用户和应用程序与关系数据库的标准接口。 SQL 语句用来从关系数据库中交互式查询信息并为报表采集数据。 What is the structured query la