Database Desing

Database Desing

1. Database Desing

   • Not Duplicate Information
     • It is not good for information to have the same function.
   • Be Accurate
     • Analyze the information in detail so that you don't have errors
   • be completeness
     • try to make the information as clear as possible

2. The Design Process

   • 1. Have a database purpose or objective
   • 2. Gathering information
     • We need to collect all the information so that we do not leave important data
   • 3. Divide information into tables
   • 4. In each table place the columns and in each column place the corresponding data
   • 5. Each table must have a pk and fk key
     • Pk: is the main or unique data in the example table the id.
     • Fk: helps to join a table with another example table Auto with driver have different data but relate to each other