Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,450 members, 7,954,767 topics. Date: Saturday, 21 September 2024 at 08:51 AM |
Nairaland Forum / Science/Technology / Programming / Normalization To "(3NF)" (844 Views)
Database Normalization (help Please) / Database Normalization (help Please) (2) (3) (4)
Normalization To "(3NF)" by salix9ice(m): 8:28am On Oct 11, 2013 |
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, |
Re: Normalization To "(3NF)" by talk2hb1(m): 7:39am On Oct 13, 2013 |
Do you mind sharing what you have done so far, and what is giving you headache. |
Re: Normalization To "(3NF)" by salix9ice(m): 11:34am On Oct 13, 2013 |
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) |
Re: Normalization To "(3NF)" by deactivated(f): 6:07pm On Oct 13, 2013 |
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 |
(1) (Reply)
Building An API In 60 Seconds, Without Any Server Setup / How Do I Connect My System To A Wifi ? / Gurus In The House, I Need Ur Help
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 8 |