第六章 数据库设计（The sixth chapter is database design）.docVIP

第六章 数据库设计（The sixth chapter is database design） The sixth chapter is database design First, the multiple-choice question 1. a data flow diagram is a tool for describing the phases in a structured method. A. outline design, B., feasibility analysis C. program code D. requirements analysis 2. database design, using E-R that describing the structure of information but does not involve the representation of information in the computer, this is the database design (). A. requirements analysis phase, B. logic design phase C. conceptual design phase, D. physical design phase 3. in database design, the process of converting E-R diagrams into relational data models belongs to (). A. requirements analysis phase, B. logic design phase C. conceptual design phase, D. physical design phase The 4. child pattern, DDL, is used to describe (). The overall logical structure of the A. database and the local logical structure of the B. database The physical storage structure of C. database and the conceptual structure of D. database 5., the conceptual design phase of database design, the common methods and description tools that represent conceptual structures are (). A. analytic hierarchy process and hierarchy structure diagram B. data flow analysis and data flow diagram C. entity relation method and entity relation diagram D. structure analysis and module structure diagram 6. in the E-R model to relational model conversion, M:N connection into relation model, the key is (). Keyword for A.M terminal entity Keyword for B.N terminal entity Keyword combinations of C.M, N, and terminal entities D. re select other properties 7. a school stipulates that there are at most 50 students in each class, with at least 10 students; each student must belong to one class. In the connection between a class and a student entity, the base of the student entity is (). A. (0, 1) B. (1, 1) C. (1, 10) D. (10, 50) 8. in relational database design, design relational model is the task of database design. A. log