search

JohannesValoy / WebShop-Group-12

0 stars 0 forks source link

SQL database sketch #12

Closed Dardnos closed 1 year ago

Dardnos commented 1 year ago

Identify what data will be stored in the database.

Suggested approach from teacher:

  1. Identify the entities first, the high-level concepts that you will store (products, etc).
  2. Identify the relationships between the entities.
  3. Define more specific fields for each entity (columns for your tables).
  4. Think about unique constraints and keys (primary keys, foreign keys).
  5. Advanced, optional: any triggers you will need?

Create an SQL database with the necessary tables