Column description of Company database tables
=============================================

department
  DNAME		varchar(15)	// department name
  DNUMBER	int		// department number
  MGRSSN	char(9)		// manager's social security number
  MGRSTARTDATE	char(10)	// manager's starting date

dependent
  ESSN		char(9)		// employee's social security number
  DEPENDENT_NAME varchar(15)	// employee's dependent's name
  SEX		char		//            dependent's sex
  BDATE		char(10)	//            dependent's birthdate
  RELATIONSHIP	varchar(8)	// dependent's relationship to employee

dept_locations
  DNUMBER	int		// department number
  DLOCATION	varchar(15)	// department location

employee
  FNAME		varchar(15)	// first name
  MINIT		char		// middle initial
  LNAME		varchar(15)	// last name
  SSN		char(9)		// social security number
  BDATE		char(10)	// birthdate
  ADDRESS	varchar(30)
  SEX		char
  SALARY	decimal(10,2)
  SUPERSSN	char(9)		//employee's supervisor's social security number
  DNO		int		// department number where this employee works

project
  PNAME		varchar(15)	// project name
  PNUMBER	int		// project number
  PLOCATION	varchar(15)	// project location
  DNUM		int		// department number that controls this project

works_on
  ESSN		char(9)		// employee's social security number
  PNO		int		// project number
  HOURS		decimal(3,1)	// no. of weekly hours worked on the project
				//   by the employee