SocialBook Database - SQL - 2020

SocialBook Database made in SQL, with comprehensive documentation.

Content:

SQL Queries applied on the SocialBook DB
Exported Database - as an SQL file
3 Diagrams of the database
22 Page Documentation of the database
- Miniworld Description
- Modeling and Design
- Entities and Relationships
- Normalization
  - First Normal Form
  - Second Normal Form
  - Third Normal Form
- Physical Database
  - Referential Integrity
  - View
  - Index
  - Temporary Table
  - Stored Procedure and Function
  - Trigger
  - Scheduled Event
  - Transaction
- Operations, Use Cases, Code
- Rationale for Choices
- Screenshots of the Database

Technologies:

SQL

Tools:

MySQL Workbench

Preview: