第五章 关系数据理论（The fifth chapter relational data theory）.docVIP

第五章 关系数据理论（The fifth chapter relational data theory） The fifth chapter is relational data theory First, the multiple-choice question 1., in order to design a better relational model, we must standardize and standardize it. The main theoretical basis is (). A. relation normalization theory B. relational algebra theory C. mathematical logic, D. relation, operation theory 2., the theory of normalization is the theoretical basis for logical design of relational databases. According to this theory, relations in relational databases must be satisfied: each attribute is (). A. whose length is constant; B. is not decomposable C. interrelated, D., uncorrelated 3. known relational patterns R (A, B, C, D, E) and their functional dependency sets F = {A = D, B = C, E = A}, the candidate key for this relational schema is (). A.AB B. BE C.CD D. DE 4. students between S (SNO, SNAME, SSEX, SAGE, SDPART) of the primary key SNO, student relationship between SC (SNO, CNO, SCORE) key for SNO and CNO, then the relationship between R (SNO, CNO, SSEX, SAGE, SDPART, SCORE) key for SNO and CNO, to meet the (). A. 1NF B.2NF C. 3NF D. BCNF 5. with W (C, P model, S, G, T, R), in which the attribute meaning is: C courses, P said S said the teacher, students, G scores, T said, R said, according to the semantic dependency set has the following data: D={(C, P, S, C, G), (T, R), C (T, P), R (T, S) - R}, a keyword relationship model W is (). A. (S, C) B. (T, R) C. (T, P) D. (T, S) In the 6. relational schema, the schema that satisfies 2NF (). A. may be 1NF, B. must be 1NF C. must be 3NF, and D. must be BCNF 7., the attributes in the relational schema R are all primary attributes, and the highest paradigm of R must be (). A. 1NF B. 2NF C. 3NF D. BCNF 8., the 1NF relational schema that removes some of the functional dependencies must be (). A. 1NF B. 2NF C. 3NF D. BCNF 9. if AB, then A attribute and attribute of B is (). A. one to many, B. to many to one C. is many to many, D. is not above The candidat