In this section we will insert the example ERD model into a database.

CREATE DATABASE School;

USE School;

CREATE TABLE Professor ( `ID` INT(9) NOT NULL, `NAME` TEXT(45) NOT NULL, `DOB` DATE NOT NULL, PRIMARY KEY (`ID`));

CREATE TABLE School (`SID` INT(9) NOT NULL, `SNAME` TEXT(45) NOT NULL, PRIMARY KEY (`SID`));

CREATE TABLE Department (`DID` INT(9) NOT NULL, `DNAME` TEXT(45) NOT NULL, PRIMARY KEY (`DID`));

Create data to enter into the database.

Add at least 3 records for each table:

PRINT OUT THE CONTENTS OF EACH TABLE, AND THE TABLE DESCRIPTIONS BELOW: