数据库原理例题（The principle of the database.）.doc

数据库原理例题（The principle of the database.） BR (library card number, name, unit, telephone, press press, ISBN, title, address, loan date) 1) according to the semantic expression patterns, with different dependence among the properties with the arrow in the model, what is the key? The BR paradigm level is? 2) were normalized to 3NF on BR 1. BR (card number, name, unit, telephone, press press, ISBN, title, address, loan date) In dependence: Library card number / name, card number / unit, library card number / telephone The title / ISBN, ISBN -- -- press press, ISBN. (card number, title) / loan date The key is: 2. (card number, title) The 3. BR is 1NF. 4. Standard for: (card number, name, unit, telephone) (title, press, press address) (card number, number, loan date) Library card number / name / unit, library card number / name / phone Press press. ISBN -- This is the so-called transfer function dependence, to reach 3NF, also need to eliminate the transfer function dependence, update mode should be Standard for: (card number, name) (name, unit, telephone) (title, press) (press, press address) (card number, number, loan date) Library card number, name, unit, telephone, press press, ISBN, title, address, loan date 1. according to 1NF requirements, 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 as the primary key, the table does not exist redundant columns 2. according to the requirements of 2NF, refining the table, set the external key (FK): Table 1: library card number (PK), name, unit, telephone 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 on any non transitive relation ISBN, Lord, to further standardize: Table 3: ISBN (PK, FK), title, press (PK, FK) T