search

tatjanarusso / CriminalRecords

Project for M226 (Harald Müller)
1 stars 0 forks source link

Create Database Schema #5

Open Laureatus opened 3 years ago

Laureatus commented 3 years ago

Create Database shema for Criminal Record database. File Format: SQL

Laureatus commented 3 years ago

Created Database schema script based on the current DatabaseERM. Since I found some issues with the current layout I will add following improvements:

-Create additional Table for race that is currently a varchar(255) value inside the criminals table to make the data more standardized

-Create additonal table for victims that is currently a varchar(255) value inside the crime table to get the possibility to see more info about the crime victim