Assignment task:
Use the book: Fundamentals of Database Systems, Seventh Edition By Ramez Elmasri and Shamkant B. Navathe to answer the questions listed below. This is not an essay. Do not answer the questions in an essay format. Keep the format the same and answer the questions from each chapter below.
CH 15: Relational Database Design Algorithms and Further Dependencies
Question 1: What is meant by the closure of a set of functional dependencies? Illustrate with an example.
Question 2: What is meant by attribute preservation condition on decomposition?
Question 3: What type of constraints are inclusion dependencies meant to represent?
Question 4: Why is the domain key normal form (DKNF) known as the ultimate normal form?
CH 16: Relational Database Design Algorithms And Further Dependencies
Question 5: What is the difference between primary and secondary storage? Need Online Tutoring?
Question 6: What characterizes the levels in RAID organization?
Question 7: What is the function of a buffer manager? What does the buffer manager do to serve a request for data?