This repository contains multiple SQL scripts developed for educational purposes. These projects were created and submitted as part of the "Databanken 2" course at VIVES Hogeschool. Each script reflects practical use of SQL concepts including data modeling, DDL, DML, constraints, and more.
A database schema for managing a beer catalog.
- Tables:
Bier,Brouwer,Soort - Relationships via foreign keys
- Includes constraints, default values, and extended properties
- Use case: Beverage product database
A classic retail database model.
- Full Northwind database including:
Products,Orders,Customers,Suppliers,Employees, etc.
- Perfect for practicing joins, business logic, and subqueries
- Use case: Supply chain and customer management
Library Management System (in Dutch)
- Tables:
Boek,Auteur,Categorie,Uitgever,Klant,Uitleen - Well-structured with foreign key relationships
- Use case: Book lending and catalog system
University-style schema for managing student and class data.
- Tables:
Student,Class,Department,Faculty,Enrollment, etc. - Relationships: Many-to-many and one-to-many
- Use case: Student enrollment and department management
A custom SQL script submitted for an assignment.
- Contains multiple operations:
DELETEbooks by a specific authorINSERTbooks into the libraryUPDATEbeer alcohol valuesDELETEbeers below a certain alcohol level
- Purpose: Practice for PE1 Insert/Update/Delete exam
- ✅ SQL DDL:
CREATE TABLE,ALTER TABLE,PRIMARY KEY,FOREIGN KEY - ✅ SQL DML:
SELECT,INSERT,UPDATE,DELETE - ✅ Relational modeling & normalization
- ✅ Use of constraints and joins
- ✅ Practice with real-world schemas (retail, library, education)
- SQL Server (T-SQL)
- Microsoft SQL Server Management Studio (SSMS)
- .sql scripts compatible with standard SQL environments
Batuhan Öztürk
Student – VIVES Hogeschool
Program: Graduaat Programmeren
Course: Databanken 2
This project is for educational use only.
Reproduction or reuse should credit the original author.