MySQL

Layout for Contact Management

Goals:

1. Naming Consistency
   • Singular instead of plural
2. Index Consistency
3. Relationship Management
   • Everything must tie back to contacts.
4. Task Management
5. Task Management
6. Foreign Key not rely on primary keys from another table.

# =====================================================================================================================# MYSQL SCHEMA CREATION# =====================================================================================================================# ORDER OF OPERATION# 1. CREATE Database & TABLES# 2. ADD CONSTRAINTS TO TABLES# 3. ADD INDICES TO TABLES# 4. ADD DATA TO TABLES