If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > New Members & Introductions > Database Concept Issues

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-29-11, 18:03
Forky Forky is offline
Registered User
 
Join Date: Oct 2011
Posts: 1
Database Concept Issues

Hello I am relatively new to databases despite having studied then briefly as part of my A-Level course.
I have been given the task of creating a database that would suit the needs of a specific company who previously relied on a paper-based system.

The company uses index cards, when a customer make an order their details are checked with the previous index cards if they have not traded with the company before a new card is created. The same is true if a new item or product is added.

The last thing is an invoice is created when a purchase is complete which contains relevant information from the index card for the customer and the item along with the date item costs and the total cost and two are printed, one for the customer and one for the company.

Essentially I'm asking for some support on what I believe would be suitable.
The obvious tables would be:
Customer Table- Store customer details
Item Table- Store item details
Possible Tables?
Order table- Stores the items chosen for a specific order, the date of the order and the total for items
Invoice Table- Takes the relevant details from each of the other tables.

As I've stated I find myself to be a slight novice at this and any support on whether these tables are suitable would be greatly appreciated
Reply With Quote
  #2 (permalink)  
Old 11-12-11, 22:39
Martin22 Martin22 is offline
Registered User
 
Join Date: Nov 2011
Posts: 30
Quote:
Originally Posted by Forky View Post
Hello I am relatively new to databases despite having studied then briefly as part of my A-Level course.
I have been given the task of creating a database that would suit the needs of a specific company who previously relied on a paper-based system.

The company uses index cards, when a customer make an order their details are checked with the previous index cards if they have not traded with the company before a new card is created. The same is true if a new item or product is added.

The last thing is an invoice is created when a purchase is complete which contains relevant information from the index card for the customer and the item along with the date item costs and the total cost and two are printed, one for the customer and one for the company.

Essentially I'm asking for some support on what I believe would be suitable.
The obvious tables would be:
Customer Table- Store customer details
Item Table- Store item details
Possible Tables?
Order table- Stores the items chosen for a specific order, the date of the order and the total for items
Invoice Table- Takes the relevant details from each of the other tables.

As I've stated I find myself to be a slight novice at this and any support on whether these tables are suitable would be greatly appreciated
You're definitely on the right track in defining the tables first. Anything that you would have more than one of (like a customer, or an item) should be it's own table. Also, ask yourself if it is important, and can you describe it? If it's important, then it is worth saving. If you can describe it, then those would be your attributes. For instance, a customer is definitely important, but can you describe a customer? The answer is yes. A customer has a first name, a last name, an address, city, state, zip code, phone number(s), and more.

All in all, I think you're headed in the right direction.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On