Repository files navigation
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).
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
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
About
A complete backend implementation of a Blog App/Site using SQL and MySQL, along with a simple GUI developed using Python and Tkinter.
Topics
Resources
Stars
Watchers
Forks
You can’t perform that action at this time.
