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
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?
Step by Step Solution
3.45 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
a Data normalization is the process of organizing data in a database to minimize redundancy and dependency Normalization helps to eliminate data inconsistencies and improve data integrity The main ste...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started