第四章公共基础（The fourth chapter, public basis）.docVIP

第四章公共基础（The fourth chapter, public basis） Chapter fourth Basics of database design After the survey of some candidates and the summary of the real problems in recent years, the written part of the test is often the database management system, the basic characteristics of the database, database system three-level model and two-level mapping, E-R model, relational model and relational algebra, the reader should focus on this part of learning Focus on learning knowledge points: 1. The concept of data, the data language provided by database management system, the main work of data manager, the characteristics of database system stage, the physical independence and logical independence of data, the unified management and control of data, the concept of three-level mode and level two mapping. 2. Data Model 3 Description content, the concept of E-R model and its R/C graph representation, relational manipulation, relational model three kinds of data constraints 3. The basic operation of relational model and the expansion operation in relational algebra 4. 4 Phases of database design lifecycle method 4.1 Basic concepts of database systems Test Center 1 data, database, database management system Test Link: Test Center 1 in the written examination, is a regular examination of the content, in the written examination of the probability of 70%, mainly in the form of the choice of questions, the score is 2 points, this test center for the focus on the content, readers should also remember the data language included in the data definition language, data manipulation language and data Control language. Data is the basic object stored in the database, which describes the symbolic records of things. The database is a collection of large amount of data stored in the computer, organized and shareable for a long time, it has the unified structure form coexist in the unified storage medium, is a variety of application data integration, and can be shared by each application. Database manag