Skip to content

Latest commit

 

History

History
31 lines (19 loc) · 1.13 KB

README.md

File metadata and controls

31 lines (19 loc) · 1.13 KB

🎓 University-DataBase

SQL DataBase Project implemented in team:

👨‍💻 Maciej Wiśniewski mcjwsn

👨‍💻 Konrad Szymański Konradajew

👨‍💻 Kajetan Frątczak KajetanFratczak

📄 Task description: View PDF

📁 Project Structure

📁 /raports – Reports from database development steps

📁 /diagram – Database schema (.png & .svg)

📁 /SQL Code – SQL scripts:

  • 📜 DDL Code.sql – Database schema (DDL)
  • 📜 Functions.sql – Defined functions
  • 📜 Indexes and Permission.sql – Indexes & permissions
  • 📜 Procedures.sql – Stored procedures
  • 📜 Views.sql – Database views
  • 📜 Triggers.sql – Triggers

🐍 data_generator.py – Python script for generating test data


Project implemented in MSSQL Server language