Database System Concepts
Database System Concepts
7th Edition
ISBN: 9789332901384
Author: Henry F. Korth & S. Sudarshan Abraham Silberschatz
Publisher: MCGRAW-HILL HIGHER EDUCATION
Expert Solution & Answer
Book Icon
Chapter 18, Problem 34E

Explanation of Solution

Three Armstrong’s axiom:

The below are three Armstrong’s axiom and they are

  • Reflexivity
    • A is considered to be set of attributes
    • BC and BA then AB
  • Augmentation
    • A is considered to be set of attributes
    • BC, then ABAC will also hold
  • Transitivity
    •  AB and BA, then AC can also be hold.

Other axioms:

  • Decomposition
    • When  ABC holds, then AB and AC can also hold.
  • Union
    • When  AB and AC holds, then ABC can also hold.

Computing the closure of the given functional dependency:

The below is the computation of the functional dependencies (F+):

  • Considering the dependency  ABC
  • Utilizing the decomposition axiom to yield  AB and  AC
  • The transitive axiom is used on the provided functional dependency  BD and also with the functional dependency  AB to get  AD
  • Utilize union axiom on  AC and  AD, to get  ACD
  • The transitive axiom is used on the provided functional dependency  CDE and also with the functional dependency  A

Blurred answer
Students have asked these similar questions
what are some available cloud components, types, delivery models, and configurations in web services and cloud computing? thanks
I would like to get information to know features about the following concepts: 1. Anything as a Server (XaaS) 2. Block Storage 3. WebSocket
Please answer JAVA OOP problem below: You are working at a university that tracks students. Each student is identified by their name and faculty advisor. Each faculty advisor is identified by their name, department, and maximum number of students they can advise. Using solid OO design principles, create a modular program that implements all the classes for the problem and also creates an implementation class that gathers user input for one student and then prints out the information gathered by creating the appropriate data definition and implementation classes. All data must be validated.    I have given the code so far: Implementation: import javax.swing.JOptionPane; public class Implementation {     public static void main(String[] args) {         FacultyAdvisor facultyAdvisor = new FacultyAdvisor("Sharmin Sultana", "IT", 30);         Student student = new Student("John", facultyAdvisor);         JOptionPane.showMessageDialog(null, student.toString());     } }   Student: public…
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