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:

---

---

---