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	Email
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?

Identify the functional dependencies among the attributes represented in the table shown above. State any assumptions you make about the data shown in this table (if necessary). (2 Marks)

(c) Using the functional dependencies identified in part (b), describe and illustrate the normalization processes by converting the above table into the 1NF, 2NF and 3NF. Identify the primary and foreign keys correctly. (4 Marks)