第二章 关系数据库（The second chapter relational database）.docVIP

第二章 关系数据库（The second chapter relational database） The second chapter is relational database First, the multiple-choice question 1. the following options are not the basic features of a relational database. A. different columns should have different data types B. different columns should have different column names C. has nothing to do with the order of rows D. has nothing to do with the order of columns 2., there is only one relationship. A. candidate code, B. outer code, C. over code, D. master code In the 3. relational model, a code is (). A. can be made up of multiple arbitrary attributes B. consists of at most one attribute C. may consist of multiple or one attribute whose value uniquely represents any tuple in the relational schema No more than D. 4. existing relationships as follows: Patients (patient number, patient name, sex, date of birth, unit of address) Medical treatment (patient number, patient name, doctor number, doctor name, date of diagnosis, diagnosis) Among them, the outer code in the medical relation is (). A. patient number B. patient name C. patient number and patient name, doctor D. number and patient number 5. an existing relationship: borrowing (ISBN, title, inventory number, number of readers, through the period, but also the same period), if this book allows a reader to borrow many times, but not at the same time on a book to borrow books, the relationship model of the outer code is (). A. B. reader ISBN number C. + D. + reader ISBN ISBN reader + by period In the 6. relational model, the N:M linkage between entities is achieved by adding one (). The A. relationship implements the B. property, implements the C. relationship or an attribute, implements the D. relationship, and implements an attribute 7. relational algebra operations are based on () operations. A. relation operation, B. predicate calculus, C. set operation, D. algebra operation 8. relational database management systems should be able to implement specialized relational operat