Skip to content

This project is a relational database developed as part of my Master's program in CIS at Boston University. Built using MS SQL, it includes a physical ERD, normalized database design, stored procedures and triggers to automate business logic, constraints, and sample SQL queries.

License

Notifications You must be signed in to change notification settings

abelreqma/Nutshell

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Project Description

Nutshell is a relational database designed to identify, track, and mitigate vulnerabilities on user devices. It stores detailed information about users, their devices, operating systems, running services, software versions, ports, and network protocols. The database also maintains a repository of known vulnerabilities from ExploitDB, including exploit details, risk assessments, and CVSS severity scores. Designed with a structured ERD, it features stored procedures, triggers, indexing for performance optimization, and SQL queries to extract key insights for vulnerability management.

Physical ERD

alt text

About

This project is a relational database developed as part of my Master's program in CIS at Boston University. Built using MS SQL, it includes a physical ERD, normalized database design, stored procedures and triggers to automate business logic, constraints, and sample SQL queries.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages