Mysql-(vi)-practical practice

Demand

1) A project can be handled by multiple employees

2) A worker can take charge of multiple projects

3) Employee's salary shall be determined by job

---------------------------------------------------------------------------

Working hour table for engineering workers

Project number project name employee number name Job salary hours

---------------------------------------------------------------------------

Project table:

Project ID Project number project name

----------------------------------------------------------------------------

Staff table:

Employee ID Employee number name Job ID Job list:

Job ID Job Name Salary

----------------------------------------------------------------------------

Intermediate table (Engineering staff table)
Employee ID Project ID work
----------------------------------------------------------------------------

Mysql-(vi)-practical practice