Database guidelines

Knowing the role of the databases makes a great tool for sorting date. Heres how to create one

1) Determine the purpose of the database

2) Design the tables or files
- Design tables or files on paper first
- Each table or file should contain data about one subject. The member table, for example, contains data about members.

3) Design the records and fields for each table or file.
- Be sure every record has a unquie primary key.
- Use seperate fields for logically distinict items
- Allow enough space for each field
- Set default values for frequently entered data.

4) Determine the relationships amoung the tables or files.

DATABASE

Today in class i learned about Database. I always hear "databases" but i never knew the real meaning behind them. A Database is date organized and allows us access to the data. With database users create a computerized database: add, change and delete date in database; sort and retrieve data from the database and create forms and reports from data in the database. The Database software to a business can be very important.For example, data keeps accurate information, verifiable information can be proven as incorrect or correct. Also businesses uses all types of information such as receipts, bank statements, pension plan summaries, stock analyses and credit reports that makes the database a very important asset. A store database might include Inventory, Members, and Purchases. In addition, Databases can be stored on a disk.