database

database

1. ER diagrams

   • Many to Many (M:N)
   • Many to One (M:1)
   • One to Many (1:M)
   • Shows the relationship
   • Data modelling
     • process of defining entities, attributes and relationships that are required
     • the result of this is called a data model.

2. Keys

   • Primary Key
   • Foreign Key
   • Candidate Key
   • Compound Key

3. Attributes

   • Also known as a entity
   • Database Field
   • could be a row of fields in a database

4. Data, Knowledge, information

   • Knowledge
     • Understood and learned information
   • Data
     • raw, unprocessed facts and figures
   • Information
     • Processed data which we can understand