The Database Forum

**lung** · 08-07-2008, 01:37 AM

This is my first post at here..

i design database(access)
about sale

have 4 table;
1. Product(ProductID,ProductName,CategoryID,Unit in stock,Price)
2.Category(CategoryID,CategoryName)
3.Order Detail(OrderID,ProductID,UnitPrice)
4.Orders(OrderID,OrderDate)

do you see?

please give me some suggestion

**chrishirst** · 08-07-2008, 04:32 AM

And your question is?

**lung** · 08-07-2008, 05:30 AM

question:

i don't know it's OK or not?
i think this first step for design database about restaurant

i want to understand about system sale

**Learning Newbie** · 08-07-2008, 03:06 PM

Honestly the design you've described is much better than we should expect from somebody's first database. I don't know the specifics of what you're trying to do, but I don't see anything "wrong".

**Lashtal** · 08-07-2008, 04:10 PM

Are you also planning on associating customers' names, addresses, etc. with their purchases?

**lung** · 08-07-2008, 09:58 PM

hey..!

can i ask about vb.net 2005 with database(access) at here?

Thank you everybody..!

**webburu** · 08-12-2008, 05:58 PM

I only have one comments on naming convention of the table name, it is not consistent. You should give tables in plural noun form such as Products, OrderDetails, Categories and Orders.

**chrishirst** · 08-18-2008, 05:53 AM

There is no reason you should name your tables as such.

That is down to personal preferences

Secondly;
You should be careful when naming tables and columns with CamelCaps (mixed case)
IF you use a database that can run on *nix and Windows (eg: MySql), moving queries when rehosting DB servers can be a problem because *nix is case sensitive and windows is not.