Skip to content

Example of SQL University Database implementation with data generator

Notifications You must be signed in to change notification settings

mcjwsn/University-SQL-DataBase

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🎓 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

About

Example of SQL University Database implementation with data generator

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •