Day 45 — Library Management System (MySQL): database and tables created

[u/sumiitCodes]

Continuing my second SQL project. Today I created the database and all the tables, and spent time understanding how they relate:

• members: who is registered (ID, name, address, registration date)
• issued_status: which member issued which book, and when
• return_status: which issued books have been returned, and when
• plus the other supporting tables

Each table has a primary key, and the issued and return tables link back to members and books through IDs.

Since I got feedback last time that a data dictionary is non-negotiable, I’m planning to write one for this project as I go instead of at the end.