数据库设计基础(国外英文资料).docVIP

数据库设计基础(国外英文资料) The fourth chapter is database design basis Through the investigation on the part of the candidates and to summarize in recent years Zhenti analysis, written examination is often part of the database management system, the basic characteristics of the database, three level model of database system and two level mapping, E-R model, relational model and relational algebra, this part readers should focus on learning. Detailed emphasis on learning knowledge points: 1., the concept of data database management system provides data language, data management, database system, the main work stage characteristics, physical data independence and logical independence, unified data management and control, three level and two level concept mapping mode 2. data model, 3 description content, the concept of E-R model and three kinds of data constraint, E-R diagram representation, relation manipulation and relational model 3. basic operations of relational model and extended operations in relational algebra 4., database design life cycle method of 4 stages 4.1 basic concepts of database systems Test site 1 data, database, database management system Exam link: 1 test sites in the written examination, is a regular examination content, the probability of appearing in the written examination in 70%, mainly in the form of multiple-choice, score of 2 points, the test for the key memory content, readers should also include the data memorizing language data definition language data manipulation language and data control language. Data is the basic object stored in a database and represents the symbolic record of things. The database is stored for a long time in the computer, organized a large number of data sharing set, it has uniform structure form and stored in the storage medium in a uniform, is the integration of multiple application data, and can be shared by all applications. The database management system (DBMS, Database Management System) is a database, it is a kind o