bc-sql-server-db-project

A collaborative SQL Server database project completed as part of coursework

Features

• Database schema with tables, indexes, and constraints
• Sample data population
• Stored procedures, views, and triggers
• Full database backup

Folder Structure

• /sql: Sql scripts
• /docs: Project documentation and overview
• /backup: Backup database (.bak) file

Tools Used

• Microsoft SQL Server
• T-SQL
• SQL Server Management Studio (SSMS)

Quick Start

To create the database, simply run the script below in SQL Server Management Studio (SSMS):

-- file: /sql/full-database-script.sql