hi, im new to normalization and i am trying to normalize a table i made,

btw this is the fields: (payment depends on time_in and time_out)

unnormalized table

customer_number, customer_name, time_in, time_out, cottage_num, cottage_name, rental_fee, payment



1NF

sales customer data - customer_number customer_name time_in time_out payment
cottage data - customer_number cottage_num cottage_name rental_fee




2NF

Data in SECOND normalized form

sales customer data - customer_number customer_name time_in time_out payment


Data in SECOND normalized form

sales data - customer_number cottage_number payment





3NF

sales customer data - customer_number customer_name
sales data - customer number cottage_number payment
cottage data - cottage_number cottage_name rental_fee




please correct me if i did something wrong with the normalization steps thx :)