SQL Database: Reference Lab Database

2018

Relational Database Project for Database Administration Concepts and Database Management class (IST 659) at Syracuse University.

Summary:
Designed and implemented a relational database for healthcare data using MS SQL Server. Translated business needs into business rules, designed the conceptual model, and converted the Entity-Relationship Diagram (ERD) to a Normalized Logical Model. Created a physical database by writing SQL statements. Utilized SQL queries to manipulate data and answer business questions.

Project Report (PDF)