Pahina 5 sa 13NAKALIPASSUSUNOD

Design the tables for a new database

Grouping data

Sets of unique information

As you list the data you want to capture, you'll see it naturally falls into one or more subject matter categories or groups. For example, your information may group itself like this:

  • Asset data, such as models, purchase dates, and costs.
  • Supplier data — those who provide the computers, desks, and other equipment. This category will probably include company names, addresses, phone numbers, and contact names.
  • Support data — those who repair and maintain the equipment. This will look like supplier data because it also includes companies and contact names.

Grouping is important because each group can correspond to a table, such as Assets, Support, and Suppliers. Your groups may not result in a complete list of tables, but they're a good starting point. Don’t be afraid to redraft them. Just make sure each group contains unique data — just the asset information in one group, only the supplier data in another, and so on.

Pahina 5 sa 13NAKALIPASSUSUNOD