Hello all,
I am attempting to create a custom point-of-sale system for a pizza shop using MS access. I am by no means a professional programmer, so please forgive my ignorance...
The data that I will be working with is:
Inventory Items - everything in its most basic form as ordered from the distributor. Includes raw ingredients such as salt and pepper, paper goods like boxes and napkins, and items like...
2 results in 0.0042 seconds.
-
How to create a custom POS for a pizza shop restaurant?
-
Database Normalization and Table Structures
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). There are others but they are rarely if ever used. A database is said to be Normalised if it is in 3NF (or ideally in BCNF). These steps are descibed as follows:
Note:...Last edited by MMcCarthy; Jan 16 '13, 09:48 PM.
