数据库原理例题（Examples of Database Principles）.docVIP

数据库原理例题（Examples of Database Principles） BR (library card number, name, unit, telephone, press press, ISBN, title, address, loan date) 1) according to the semantics expressed by the model, use the arrow to indicate the different dependencies among the attributes in the pattern. What is the main keyword? Is the BR paradigm level? 2) standardize BR to 3NF 1. BR (card number, name, unit, telephone, press press, ISBN, title, address, loan date) Dependencies in: Library card number / name, card number / unit, library card number / telephone The title / ISBN, ISBN -- -- press press, ISBN. (card number, title) / loan date The 2. primary key is: (library card number, title) 3. BR is 1NF now. 4. Standardize: (library card number, readers name, unit, telephone number) (title, publisher, publisher address) (card number, number, loan date) Library card number / name / unit, library card number / name / phone Press press. ISBN -- These are called transfer function dependencies, and to achieve 3NF, you also need to eliminate transfer function dependencies, and update patterns should be Standardize: (library card number, readers name) (readers name, unit, telephone) (title, publisher) (publisher, publisher address) (card number, number, loan date) Library card number, name, unit, telephone, press press, ISBN, title, address, loan date 1. press 1NF to determine the unique primary key (PK): library card number (PK) Because only 1. library card number only, can have the same name as the reader, the celebrity, the same person can have more than one card, etc. 2., the library card number is the primary key, so that the table does not exist redundant columns 2., according to 2NF requirements, refining table, set the external key (FK): Table 1: library card number (PK), readers name, unit, telephone number Table 2: library card number (PK, FK), ISBN (PK, FK), loan date Table 3: (PK) ISBN, title, press, press. 3. according to the 3NF requirements in Table 3, press information depends o