Can someone please tell me whether my normalization is correct? And if not can someone please help?
First Normal Form
Customer <CustomerID, first_name, last_name, email_address, date_of_birth,
HouseNo, StreetName, Town, City, PostCode, County, Country,
PhoneNo, Password, CardHolder, CardType, CardNo, ExpDate>
Order <CustomerID, ProductID, Logo, Price, DateOfOrder, OrderSent,
SupplierID, SupplierName>
Second Normal Form
Customer <CustomerID, first_name, last_name, email_address, date_of_birth,
HouseNo, StreetName, Town, City, PostCode, County, Country,
PhoneNo, Password,
BankDetails< CustomerID, CardHolder, CardType, CardNo, ExpDate>
Order <CustomerID, ProductID, DateOfOrder, Logo, Price, OrderSent>
Supplier < SupplierID, SupplierName>
Third Normal Form
Customer <CustomerID, first_name, last_name, date_of_birth,
HouseNo, StreetName, Town, City, PostCode, County, Country,
PhoneNo>
Password< CustomerID, email_address, password>
BankDetails< CustomerID, CardHolder, CardType, CardNo, ExpDate>
Order <CustomerID, ProductID, DateOfOrder,
Logos < ProductID, Logo, Price, OrderSent>
Supplier < SupplierID, SupplierName>
-Thank u
