This project defines the structure of a simple movies database using SQL.
It includes a movie table with foreign key relationships to author and genre tables.
The movie table stores information about movies, their publication year, and references to their author and genre.
📚 Related Tables author – stores information about movie authors.
genre – stores genre classifications for movies.
🧠 Logical Schema Diagram Visual diagrams are included in the /diagrams/ folder.
Example:
🚀 How to Use Clone the repository:
Copy
git clone https://github.com/your-username/sql-book-database.git Open the .sql file in your preferred SQL editor (e.g., MySQL Workbench, DBeaver).
Run the script to create the table and set up foreign key constraints.
The diagram can be opened and edited using draw.io or any compatible viewer.
👤 Author Tijana Dajić