473,320 Members | 2,122 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Online booking/appointment system for Hair Salon

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.
Aug 20 '09 #1
7 7463
mshmyob
904 Expert 512MB
@2desperate2usedesperate
Just some things to think about for now.

I wouldn't use an email for a PK for your customer. A simple autonumber would suffice. Email addresses can be very long and who wants to type all that in. Also what do you do if the customer doesn't have an email - you do realise the majority of people in the world don't have email.

I understand what a ServiceType is but what is an ApptType?

Also ApptDate and ApptTime cannot be used as a PK in your Schedule table. The would mean that you could only have one appoint at any one time on each date. For instance if you had 3 customers wanting to come in at 11:00am on Jan 1, 2009 for a haircut you could not do it.

What I suggest you do is list out all your business rules and then see if your tables make any sense.

cheers,
Aug 20 '09 #2
Hi there, thanks for the suggestion.
I really don't like the idea of using the email address as a primary key either. The database is for a hair salon and seeing that customers will be booking online they would not know what key to enter in the CustID field, hence I would like to use an autonumber..... but since my ApptNo is autonumber, Access tells me I can't have two fields using autonumber and the problem comes in when I use CustID as a foreign key in the Appointment Table.
Any ideas on solving that, please?
Thanks
Aug 20 '09 #3
mshmyob
904 Expert 512MB
@2desperate2usedesperate
Yeah, make CustID an autonumber in the Customer table. FK's are not autonumbers but Long Numbers that refer to autonumber PK's.

I would suggest you have your teacher teach you the basics of database design (to get the table structure proper ie: normalization) and then have him/her teach the basics of Access before getting you guys to design a web database and interface.

cheers,
Aug 20 '09 #4
ChipR
1,287 Expert 1GB
There is an issue here regarding customers booking appointments. Do you somehow inform the customer that they are making the 20th appointment for 10:00 AM, and you only have 10 employees?
Aug 20 '09 #5
Thanks mshmyob,
I will seek out some more tutorials concerning the afore-mentioned.


Thanks for your response ChipR,
I'm not sure if I'm accurately answering the questioning here, but I only want one booking per hour so that's why under the Schedule table I have made ApptDate & ApptTime my primary/compound key, I'm not sure if that makes any sense. I've redone these tables a few times well but I get a new issue every time I do. Any thoughts on how I should restructure/do my tables?
Aug 20 '09 #6
ChipR
1,287 Expert 1GB
Using the ApptDate and ApptTime as the compound key does make sense given the restriction of one booking per hour (if you assume that will never change?). That illustrates the problem with asking for help designing the database: people who don't know the requirements intimately just can't know the proper solution, they can only help explore factors to be considered. Fortunately, the person doing the grading is an excellent source for requirements.
Aug 20 '09 #7
Ok, Thank you very much
Aug 20 '09 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Ali.M | last post by:
Hi, I am looking for an online help authoring tool for the web application I am developing. Could anyone refer me to a tool with a reasonable price? Thanks! Alan
0
by: RS | last post by:
Hi, I am looking for some open source online test/exam system using ASP.net and SQL server 2000. Does anyone have any suggestion? Thank you! RS
1
by: simba | last post by:
Hello, I am currently doing a project which requires me to develop an online booking system for hotels and integrate both bed and room booking. I have the room booking working but I cant seem to...
2
by: yuori | last post by:
Hi this is my first time creating an online e-assessment system. i'm not too sure on how to set a time limit for each test papers that the user taken. The time would be shown after the test has...
1
by: jonkemm | last post by:
I'm making a a system for my school to allow students to have some online space to store their school files on. It has a basic upload / create folder / download / delete bit, it also has a 'submit...
3
by: vasu46 | last post by:
hi, i want the database design for online booking for a tutor, as i am totally confused in designing the database, could u plz help me, table contains of userid ,grade,subject,topic,session date,time...
0
by: outman | last post by:
I am creating a website online booking for hotels but I have problems in calculating price between two dates, my problem is: each hotel that records are created depending on the price schedules...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.