I am writing a program for a eyelash service business. Can you guys take a look at my database model and let me know if I'm missing something or doing something wrong before I go ahead and create the database?
I was thinking about maybe adding an "Invoice" table...but not too sure if it's necessary.
Here is the Visio file:
Take a look and let me know what you guys think. It's been a year since my last database course so I'm a bit rusty.
EDIT: Was just looking it over, and I added "Appointment_Time" as an additional PK to the Appointment Table
This post has been edited by toad87: 01 April 2013 - 02:46 AM