Question: Exercises 1. You will design a simple database that will track membership information. Your database must be normalized to the third normal form. The following

Exercises 1. You will design a simple database that will track membership information. Your database must be normalized to the third normal form. The following items must be captured in your database: Individual Information 1. Member ID 2. Member first name 3. Member second name 4. Member join date 5. Member phone number 6. Group(s) that a member belongs to Group Information 1. Group ID 2. Group name 3. Group leader 4. Group members Each member will have a unique ID. Each member can have one or more phone numbers Each member can belong to zero or more groups Each group will have a unique ID Each group can have only one leader, which must be a member Each group can have zero or more members

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!