Question: I need help using CREATE TABLE statements in mySQL to create a company database. The EMPLOYEE table has columns Fname, Minit, Lname, Ssn(underlined), Bdate, Address,

I need help using CREATE TABLE statements in mySQL to create a company database. The EMPLOYEE table has columns Fname, Minit, Lname, Ssn(underlined), Bdate, Address, Sex, Salary, Super_ssn, Dno. The DEPARTMENT table has columns Dname, Dnumber(underlined), Mgr_ssn, Mgr_start_date. The DEPT_LOCATIONS table has columns Dumber(underlined), Dlocation(underlined). THe PROJECT table has columns Pname, Pnumber(underlined), Plocation, Dnum. The WORKS_ON table has columns Essn(underlined), Pno(underlined), Hours. The DEPENDENT table has columns Essn(underlined), Dependent_name(underlined), Sex, Bdate, Relationship. You have to properly identify any primary key and foreign key constraints(use your best judgment). Any help would be awesome, thanks.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!