数据库试题（Database questions）.docVIP

数据库试题（Database questions） 2. the following aggregation functions do not ignore the null value (null) [[] Dan Xuanti) A.SUM (column name) B.MAX (column name) C.COUNT (*) 5. in database design, the process of converting E-R diagrams into relational data models belongs to [[Dan Xuanti]] A. requirements analysis phase B. conceptual design phase C. logic design phase D. physical design phase A subsystem of transaction persistence in 5.DBMS is [[Dan Xuanti]] A. security management subsystem B. integrity management subsystem C. concurrent control subsystem D. recovery management subsystem 7. entity integrity and referential integrity in relational models (question and answer questions) View answers (1) entity integrity rules: if property / 4 is the basic relationship and the primary attribute, then the property A cannot take null values. (2) refer to the integrity rule: if the attribute (or attribute group) 9 is the outer relation of the basic relation and the outer code, it is the primary code S of the basic relation X. The corresponding (basic relations only and S is not different between), then for each R in the 9 tuple values must be: 1) or null value (each attribute value of 9 are null); 2) or equal to the main code S to a tuple value. 9. what is a data model and its elements? View answers Data model is a tool used in database to abstract the real world. It is the formal framework for providing information representation and operation means in database. Generally speaking, a data model is a collection of strictly defined concepts. These concepts accurately describe the static, dynamic and integrity constraints of the system. Therefore, the data model is usually composed of three parts: data structure, data operation and integrity constraint. (1) data structure: a collection of the types of objects studied, a description of the static characteristics of the system. (2) data manipulation: a collection of operations allowed by an instance (value) of a variety of objects