GeezerVison is showing github.com — GitHub - JayRizzo/MySQL: Layout for Contact Management

Open more actions menu

Latest commit

History

Folders and files

Name		Name	Last commit message	Last commit date
Address.sql		Address.sql
AreaCode.sql		AreaCode.sql
City.sql		City.sql
Company.sql		Company.sql
Contact.sql		Contact.sql
CountryCode.sql		CountryCode.sql
CountryState.sql		CountryState.sql
Date.sql		Date.sql
Department.sql		Department.sql
Employee.sql		Employee.sql
LICENSE		LICENSE
Phone.sql		Phone.sql
README.md		README.md
Salary.sql		Salary.sql
SocialMedia.sql		SocialMedia.sql
Title.sql		Title.sql
Z_FULLSCRIPT.sql		Z_FULLSCRIPT.sql

Repository files navigation

MySQL

Layout for Contact Management

Goals:

Naming Consistency
- Singular instead of plural
Index Consistency
Relationship Management
- Everything must tie back to contacts.
Task Management
Task Management
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