table design

[SunTop]

Hello everyoneI have a list of items (around 100), these items are divided into categories, each category of these items are installed in a different number of methods (Renewal, Refixing, Removal), not all categories have the same methods. Each of these installation methods have a different price, how do I design tables for this setup ?

[CJ_London]

1. google 'normalisation' to understand how data relates to each other - in simple terms data should be stored only once, calculations should not be stored
2. get a piece of paper and start to draw out your tables - for each bit of data, work out where it need to go to be stored only once, creating additional tables as required
3. then create your tables and relationships from this design and test you can get the required outputs using queries

Also take a look at the links at the bottom of this thread where much the same question has been asked before - they may provide further links to some examples or things to think about

[orange]

Here are some links to database design concepts.
Videos for Database concepts

Intro to database
The relational model
Basics of data modelling

Tutorials to work through.
Spend 30-45 minutes working through one of these tutorials from RogersAccessLibrary. They show the Problem, the Process and include solutions. You can use this technique with any database.

You have to work through the exercise to appreciate the process and result.

Class information

Consolidated Widgets


Good luck.