第6章 关系数据理论（The sixth chapter is relational data theory）.docVIP

第6章 关系数据理论（The sixth chapter is relational data theory） Chapter 6th Theory of relational data I. Selection questions 1. The insert operation exception in relational normalization refers to (), and the delete operation exception is (). A. Data that should not be deleted is deleted B. Data that should not be inserted are inserted C. Data that should be deleted has not been deleted d. Data that should be inserted is not inserted 2. The relationship between the various levels of paradigms in the relational model is (). A. 3nf2nf1nf B. 3nf1nf2nf C. 1nf2nf3nf D. 2nf1nf3nf 3. Relational patterns in a relational model should at least belong to (). A.1nfb.2nfc.3nfd.bcnf 4. The better design performance of the relationship model is called normalization, the main theoretical basis for standardization is (). A. Relational algebra theory B. Relationship normalization theory C. Relational computing theory d. Mathematical logic 5. The theory of normalization is the theoretical basis for the logical design of relational database. According to this theory, relationships in relational databases must be satisfied: each of its properties is (). A. Unrelated B. Non-decomposable C. Variable length d. interrelated 6. The normalization of relational databases is introduced to address () problems in relational databases. A. Inserting exceptions, removing exceptions, and data redundancy b. Improving query speed C. Reducing the complexity of data operations like D. Ensuring data security and integrity 7. The normalization process is primarily to overcome the pitfalls of inserting exceptions, deleting exceptions, and () in the logical structure of the database. A. Inconsistencies in data B. unreasonable structure C. High redundancy d. Data loss 8. X→y, when one of the following is established, is called trivial function dependency (). A. XY b. Yx c. x∩y=φd. x∩y≠φ 9. With relational mode R (S, D, M), its function depends on set f={s→d, d→m}, the normalized degree of the relational mode R is up