Blog-Database-System This project is a complete design and implementation of the backend of a blog site application with MySQL. It focuses on the fundamental concepts of Relational Databases (RDBMSs), namely tables, views, procedures, functions,triggers and normalization. The tables are in Third Normal Form (3NF). Tables: USER - Blog users. POST - Posts uploaded by users. COMMENT - Comments written by users on posts. CATEOGRY - Stores all topics/categories POST_CATEGORY - Stores the categories associated with the posts POST_LIKES - Stores the likes made by users on posts Files in this repo: tables.sql - Table defintions record_insertion.sql - Populating the database procedures_and_functions.sql - Defining functions and procedures procedure_calls.sql - Calling the functions and procedures views.sql - Defining virtual tables to represent the data triggers.sql - Defining triggers
