Skip to content

SocialBook Database made in SQL, with comprehensive documentation.

License

Notifications You must be signed in to change notification settings

panaitescu-paul/SocialBook-Database-SQL-2020

Repository files navigation

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: