Question: In this assignment, I am required to take the table that I created in the past HomeWork, for the Freelance Contact form, and normalize it

In this assignment, I am required to take the table that I created in the past HomeWork, for the Freelance Contact form, and normalize it to reduce redundant data. The level of normalization is your choice as you are the database designer. So I would like to know how to normalize my Database's table(Table structure Attached) and also how to improve on the choices that I made(proper data type used and length) on this table to store the info of this Freelance Contact Form (Picture of the Form Attached)

If any additional Info on Table/database is required, please let me know.

https://ibb.co/dLPGtS (My Customer Database Table) https://ibb.co/iDqZf7 (Customer Form)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!