Question: Topic: Checking the basics of Database design knowledge Preface: One of fundamental aspect of database design technique is to reduce data redundancy and elimination of

 Topic: Checking the basics of Database design knowledge Preface: One of

Topic: Checking the basics of Database design knowledge Preface: One of fundamental aspect of database design technique is to reduce data redundancy and elimination of undesirable characteristics like Insertion Update and Deletion Anomalies. There are specific rules in DUMS to fragment/ divide larger tables into smaller ones and links them using relationships. Your task is to use these rules to redesign the given simple database. Student Name Address Course taken Salutation Adbullah 26/A Mirpur, Dhaka CSC 101 M Monika 9/6 Dohs, Mohakhal CSC 101, CSC 200 Ms Saddam 3/10 Hasundhara RA CSC 101 Me Anamika 18.16 Utara CSC416, CFN616 MS There are several design anomalies exists in the above table. According to your understanding of Database design accomplish the following: # Report the design concern/ anomalies for the above table. b) For each anomaly, redesign the table to overcome it. Hint Think form the perspective of Normalization

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!