Hi ALL
I need to build a database in Ms Access for my school project to facilitate appointments for a Hairdresser's Salon. Customers will book appointments online only.
I'm uncertain as to how I should go about the Normalization process. I'm unsure as to what tables to create that would be easily used as a backend (Db) and web pages as the front end.
I've tables like this:-
3NF
Appointment (ApptNo(PK), ApptType)
Customer (CustEmail (PK), CustSurname, CustName, Gender, CustTelNo)
Schedule (ApptDate(PK), ApptTime(PK), ApptNo*)
CustomerAppt (AppNo(PK), CustEmail(PK), ServiceID(PK))
Service (ServiceID(PK), ServiceType, ServicePrice)
I'm not sure if this is correct and HOW do I go about setting it to be used with HTML Pages.
Thank you for any assistance rendered.