Skip to content

README.md

Latest commit

 

History

History
25 lines (19 loc) · 1.22 KB

README.md

File metadata and controls

25 lines (19 loc) · 1.22 KB

🍷 Wine Shop Database & Security

Academic project focused on SQL Data Control Language (DCL) and Database Management.

This repository hosts the database structure for a Wine Shop ("Adega"), featuring a complete catalog of wines, wineries, and regions. The main highlight of this project is the implementation of User Permission Strategies to secure sensitive data.

🚀 Live Documentation

Check out the interactive documentation for this project here: https://apollo-stack.github.io/Wine-Shop-Database/

🛠️ Key Features

  • Database Schema: Tables for Vinho (Wine), Vinicola (Winery), and Regiao (Region).
  • Advanced Queries (DQL): complex JOINs connecting wines to their geographical origins.
  • Security & Permissions (DCL):
    • Creation of a restricted role 'Somellier'.
    • GRANT specific permissions (e.g., viewing wine details but restricted access to winery contact info).

📂 Repository Structure

  • Usuário Somellier.sql: Script managing users and GRANT permissions.
  • servienski_*.sql: Dump files ensuring data persistence and structure.
  • Consulta...sql: Analytical queries for reporting.
  • index.html: Interactive project documentation.

Developed by Matheus Ramon - 2025