2 Replies - 310 Views - Last Post: 01 April 2013 - 08:18 AM Rate Topic: -----

#1 toad87  Icon User is offline

  • D.I.C Head

Reputation: 8
  • View blog
  • Posts: 188
  • Joined: 21-May 12

Give me some feedback/advice?

Posted 01 April 2013 - 02:44 AM

Hello guys,

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:

https://www.dropbox....jecn0ka/DOM.vsd

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.

Many thanks,

Toad

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


Is This A Good Question/Topic? 0
  • +

Replies To: Give me some feedback/advice?

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 8383
  • View blog
  • Posts: 31,159
  • Joined: 12-June 08

Re: Give me some feedback/advice?

Posted 01 April 2013 - 06:48 AM

How about you take a screen shot and post it here. Not everyone runs around with Visio installed.
Was This Post Helpful? 0
  • +
  • -

#3 toad87  Icon User is offline

  • D.I.C Head

Reputation: 8
  • View blog
  • Posts: 188
  • Joined: 21-May 12

Re: Give me some feedback/advice?

Posted 01 April 2013 - 08:18 AM

Sorry, here's a screenshot:

https://www.dropbox....cpjvsn3/dom.png

Posted Image

I probably will add "Position" under Employee too.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1