EBK DATABASE SYSTEM CONCEPTS
EBK DATABASE SYSTEM CONCEPTS
7th Edition
ISBN: 9781260049268
Author: SILBERSCHATZ
Publisher: MCG COURSE
Expert Solution & Answer
Book Icon
Chapter 7, Problem 42E

Explanation of Solution

Normalization of the schema to 4NF:

  • It is the normalization level next to Boyce-Codd Normal Form (BCNF).
  • Given schema,

books(accessionno, isbn, title, author, publisher)

users(userid, name, deptid, deptname)

  • The constraints given in the question are,

accessionno → isbn

isbn → title

isbn → publisher

isbn →→ author

userid → name

userid → deptid

deptid → deptname

  • Second Normal Form (2NF): If the schema does not contain any functional dependencies, then it is said to be in second Normal Form.
    • The conversion of the given  normal  to 2NF is a s follows,
    • Consider the functional dependencies,

isbn → title

isbn → publisher

isbn →→ author

  • For the above functional dependencies,
    • The relational schema “books(accessionno, isbn, title, author, publisher)” is converted to “books(isbn, title, author, publisher)” and books(accessionno, isbn)...

Blurred answer
Students have asked these similar questions
Write a C program using embedded assembler in which you use your own function to multiply by two without using the product. Tip: Just remember that multiplying by two in binary means shifting the number one place to the left. You can use the sample program from the previous exercise as a basis, which increments a variable. Just replace the INC instruction with SHL.
using r language
r language
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education