A professional association in the Niagara Region would like to develop a database to maintain data about
Fantastic news! We've Found the answer you've been seeking!
Question:
A professional association in the Niagara Region would like to develop a database to maintain data about its members. The Association collects the data indicated in the following table on each member.
MEMBERS
Member ID | First Name | Last Name | Specialization | St. Num | St. Name | Postcode | City | Mob. Phone | |
0001 | Margunn | Aanestad | Artificial Intelligence | 45 | Oaktree Rd | L2V 9..d@gmail.com | |||
0002 | Tina | Jensen | Database | 48 | Oaktree Rd | L2V 9..d@yahoo.com | |||
0003 | Wanda | Orlikowski | IS Development | 24 | Silver Dale Dr. | L2S 3N1 | St. C..a@hotmail.com | ||
004 | Jason | Potts | Artificial Intelligence | 32 | North Service Rd. | L3J 0B9 | St. C..s@gmail.com | ||
0005 | Tina | Jensen | IS Development | 45 | Oaktree Rd | L2V 9..a@gmail.com |
As a requirement, the resulting database should let users be able to search the database using the first or last name of a member, list members who reside in a particular city, say Thorold, or by street name, etc. As part of the design process, normalize the table by answering the following questions:
- Explain the purpose of data normalization and describe the main steps in the normalization process.
Is the above table in first normal form (1NF)? Why or why not?
Related Book For
Posted Date: