[an error occurred while processing this directive]

The COMPANY Database
in mSQL

The company example database from "Fundamentals of Database Sysytems" by Elmasri and Navathe.

The Schema

PROJECT

pname

pnumber

plocation

dnum

DEPT_LOCATION

dnumber dlocation

EMPLOYEE

fname minit lname ssn bdate address sex salary superssn dno

DEPARTMENT

dname dnumber mgrssn mgrstartdate

DEPENDENT

essn dependent_name sex bdate relationship

WORKS_ON

essn pno hours