Computer Science week 5 assignment

Use the PDF book provided 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

#15.3 – What is meant by the closure of a set of functional dependencies? Illustrate with an example.

#15.6 - What is meant by attribute preservation condition on decomposition?

#15.14 – What type of constraints are inclusion dependencies meant to represent?

#15.16 - Why is the domain key normal form (DKNF) known as the ultimate normal form?

CH 16: RELATIONAL DATABASE DESIGN ALGORITHMS and FURTHER DEPENDENCIES

#16.1 – What is the difference between primary and secondary storage?

#16.22 – What characterizes the levels in RAID organization?

#16.29 – What is the function of a buffer manager? What does the buffer manager do to serve a request for data?