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
Get step-by-step solutions from verified subject matter experts
