Final Exam Review:

---

Design solution of a given system.

• E-R diagram
  • tables
  • PK
  • FK
  • Relationship
  • Cardinality
• Data Types
• Business rules
• Domain (must be certian values)
• Range constraints (must be within a range)
• Default values
• intrarelation constraint (date example)
• interrelation constraint (employee - project example)
• What would the SQL Insert look like for ....
• What would an SQL update look like for ....
• What is a trigger, how could a trigger be used in this example....
• What is a procedure and give example of when we would use one for this example...
• Why use a View and give example
• What would the SQL to create a view look like for....

Examples of implementing relationships:

• Setting FK constraints
• Create tables in SQL
• Alter tables in SQL
• Delete rows
• Cascade

DB Theory :

• What does is mean to normalize a database
• Why normalize a database system
• Example of O-M, O-O, M-O, M-M (M- Mandatory, O-Optional)
• N:M intersection table