Database Design for SCIRT | ER Diagram, DDL, Data Requirements

Running head: DATABASE DESIGN
Database Design
Name of the Student:
Name of the University:
Author Note

1
DATABASE DESIGN
ER Diagram
DDL
-- MySQL Script generated by MySQL Workbench
-- Sat Jun 30 12:04:09 2018
-- Model: New Model Version: 1.0
-- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

2
DATABASE DESIGN
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE,
SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
-- -----------------------------------------------------
-- Schema SCIRT
-- -----------------------------------------------------
DROP SCHEMA IF EXISTS `SCIRT` ;
-- -----------------------------------------------------
-- Schema SCIRT
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `SCIRT` DEFAULT CHARACTER SET utf8 ;
SHOW WARNINGS;
USE `SCIRT` ;
-- -----------------------------------------------------
-- Table `SCIRT`.`ProjectArea`

3
DATABASE DESIGN
-- -----------------------------------------------------
DROP TABLE IF EXISTS `SCIRT`.`ProjectArea` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `SCIRT`.`ProjectArea` (
`AreaID` INT NOT NULL,
`Name` VARCHAR(45) NOT NULL,
`Location` VARCHAR(45) NOT NULL,
PRIMARY KEY (`AreaID`))
ENGINE = InnoDB;
SHOW WARNINGS;
CREATE UNIQUE INDEX `AreaID_UNIQUE` ON `SCIRT`.`ProjectArea` (`AreaID` ASC);
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `SCIRT`.`AssementResult`