How to design your first Database

How to design your first Database

1. What you should do

   • You should put away every Primary and Foreign Key in the respective tables to easily access to them
   • You must automate some information such as the current date to facilitate storage in the database
   • You should find out the database purpose so you can identify the information you want you want to store
   • You should take apart the entities to create the tables from the start of the design
   • You should recognize everything that makes up the entities to convert that information into the columns of the entities

2. What you have to do

   • You must avoid duplicate and redundant information because increases the storage when we store the same infomation multiple times
   • You have to correctly define constrains to keep the accuracy and completeness of the information

3. What you mustn't do

   • You mustn't put everything in a single table because it can cause redundant information
   • You mustn't put information into the database without normalize the database first