《数据库处理基础、设计与实现第十版》第一章第一部分.pptVIP

David M. Kroenke’s Chapter Objectives To understand the nature and characteristics of databases To survey some important and interesting database applications To gain a general understanding of tables and relationships To describe the components of a Microsoft Access database system and explain the functions they perform To describe the components of an enterprise-class database system and explain the functions they perform To define the term database management system (DBMS) and describe the functions of a DBMS Chapter Objectives To define the term database and describe what is contained within the database To define the term metadata and provide examples of metadata To define and understand database design from existing data To define and understand database design as new systems development To define and understand database design in database redesign To understand the history and development of database processing The Characteristics of Databases The purpose of a database is to help people track things of interest to them Data is stored in tables, which have rows and columns like a spreadsheet. A database may have multiple tables, where each table stores data about a different thing Each row in a table stores data about an occurrence or instance of the thing of interest A database stores data and relationships Data in Tables The Key Characteristic of Databases: Related Tables Naming Conventions in this Textbook Table Names are written with all capital letters: STUDENT, CLASS, GRADE Column names are written with an initial capital letter, and compound names are written with a capital letter on each word: Term, Section, ClassNumber, StudentName Databases Create Information Data = Recorded facts and figures Information = Knowledge derived from data Databases record data, but they do so in such a way that we can produce information from the data The data on STUDENTs, CLASSes and GRADEs could produce information about each student’s GPA Database Examples Components