Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

3. An overview of the key behaviors is presented.

Answered: 1 week ago

Question

What is DDL?

Answered: 1 week ago