For each of the views that you defined in Exercise 6.10, explain how updates would be performed (if they should be allowed at all).
Answer to relevant QuestionsIn Chapter 3, we described the use of views to simplify access to the database by users who need to see only part of the database. In this chapter, we described the use of views as a securitymechanism. Do these two purposes ...Explain what is meant by repetition of information and inability to represent information. Explain why each of these properties may indicate a bad relationaldatabase design.Use Armstrong’s axioms to prove the soundness of the union ruleShow that the following decomposition of the schema R of Exercise 7.2 is not loss less-join decomposition:(A, B, C)(C, D, E).Let a prime attribute be one that appears in at least one candidate key. Let α and β be sets of attributes such that α → β holds but β → α do not hold. Let A be an attribute that is ...
Post your question