Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 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:

  1. 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)


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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing A Practical Approach

Authors: Robyn Moroney

1st Canadian Edition

978-1118472972, 1118472977, 978-1742165943

More Books

Students also viewed these Finance questions

Question

Explain why psychologists sometimes use animals in their research.

Answered: 1 week ago