I am trying to build a rather robust system, and from what I'm seeing planning the database is basically the most important part - like the foundation of a house. Now, I know nothing about databases or how they work, so I'm learning as I go.
I've started outlining the database and I'm running into a couple questions.
#1 - Am I simply making too many tables?
#2 - I cannot grasp the difference between one-to-one and one-to-many links
I haven't created the tables yet, I'm outlining them as directed in IBS's Alpha Five Version 8 Level 1 Learning Guide (I'm using v8 currently).
So here are the tables currently on my list:
Customer
Orders
Order Detail
Vendors
Products
Sales Reps
Employees
Departments
Payment_Method
Delivery_Method
Account_Status - I have several standard "status" for my customers - Account, COD, etc. was planning on putting the options here
Price_Level - I have 4 different price levels based on customers. planning on putting each level here, allowing us to select level from drop down
Authorized_Purchasers
Purchase_Orders
Another question: We accept cash, check and credit cards. I can't decide if I should have a table for each type of payment, or if I need a blanket table that can cover all options or what.
As you can see, I need help - if anyone has any resources they can direct me to it would be greatly appreciated.
Thanks!
I've started outlining the database and I'm running into a couple questions.
#1 - Am I simply making too many tables?
#2 - I cannot grasp the difference between one-to-one and one-to-many links
I haven't created the tables yet, I'm outlining them as directed in IBS's Alpha Five Version 8 Level 1 Learning Guide (I'm using v8 currently).
So here are the tables currently on my list:
Customer
Orders
Order Detail
Vendors
Products
Sales Reps
Employees
Departments
Payment_Method
Delivery_Method
Account_Status - I have several standard "status" for my customers - Account, COD, etc. was planning on putting the options here
Price_Level - I have 4 different price levels based on customers. planning on putting each level here, allowing us to select level from drop down
Authorized_Purchasers
Purchase_Orders
Another question: We accept cash, check and credit cards. I can't decide if I should have a table for each type of payment, or if I need a blanket table that can cover all options or what.
As you can see, I need help - if anyone has any resources they can direct me to it would be greatly appreciated.
Thanks!
Comment