Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 3 (Marks: 10) Data that is relational in nature is best described by means of a relational data model. Q.3.1 Define redundant data and
Question 3 (Marks: 10) Data that is relational in nature is best described by means of a relational data model. Q.3.1 Define redundant data and provide an example in the context of a bank. (4) Q.3.2 The below Entity Relationship Diagram (ERD) was drawn according to the business rules shown below. Book club business rules: - A book belongs to a genre, and many books can belong to the same genre. - A member chooses one favourite genre, and a genre can be chosen as the favourite of many members. - A member reads many books, and each book can be read by many members. (6) (c) The Independent Institute of Education (Pty) Ltd 2022 Page 3 of 7 21;22;23 2022 Explain any three changes that should be made to the ERD to accurately reflect the business rules. Provide a full description of the change and the reason for the change
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started