₦airaland Forum

Can some one help me with this please?
Customer_ID, Customer_phone_number, Customer_E-mail, Customer_address, City, Customer_DOB, Gender, First_name, Last_name, State, Agency_name, Fax, Manager_name, Establishment_year
Staff_Name, Staff_ID, Staff_address, Staff_DOB, Staff_E-mail, Staff_phone_number, Join_date
Complain_ID, Complain_Date, Complain_type
Payment_ID, Payment_date, Payment_statues, Payment_amount, Payment_method
Advert_ID, Newspaper_name, Advert_cost, Publisher, Advert_type, Advert_size, Advert_date, Advert_tittle, Newspaper_type, Tax, Profit,
Newspaper_ID, Newspaper_name,

Do you mind sharing what you have done so far, and what is giving you headache.

I want to change this to 3NF
2NF
Custome[/b]r (Customer_ID, Customer_phone_number, Customer_E-mail, Customer_address, Complain_ID -FK, Payment_ID -FK, Advert_ID-FK)
[b]Individual Customer (IC number, City, Customer_DOB, Gender, First_name, Last_name, State, Customer_ID-FK)
Agency (Registration number, Agency_name, Fax, Manager_name, Establishment_year, Customer_ID-FK)
Staff (Staff_Name, Staff ID, Staff_address, Staff_DOB, Staff_E-mail, Staff_phone_number, Join_date)
Complain (Complain ID, Complain_Date, Complain_type, Customer_ID-FK, Staff_ID-Fk)
Payment (Payment ID, Payment_date, Payment_statues, Payment_amount, Payment_method, Customer_ID-FK, Staff_ID-Fk)
Advert (Advert ID, Newspaper_name, Advert_cost, Publisher, Advert_type, Advert_size, Advert_date, Advert_tittle, Newspaper_type, Tax, Profit, Customer_ID-FK, Staff_ID-Fk, Payment_ID-FK)
[b]Newspape[/b]r (Newspaper ID, Newspaper_name Newspaper_type, Advert_ID-FK)

What's is 3NF? You want to normalize your tables with foreign keys? Sure but all you have up there, idont know what you want