Business
The business
database contains the following tables:
The staff table
The staff
table contains information about all staff members described as follows:
Column |
Description |
---|---|
|
A primary key used to uniquely identify each staff member in the table. |
|
The staff member's first name. |
|
The staff member's last name. |
|
A foreign key identifying the address of the staff member in the address table. |
|
A photograph of the employee. |
|
The staff member's e-mail address. |
|
The staff member's "home store". The employee can work at other stores but is generally assigned to the store that is listed. |
|
Indicates whether the staff member is an active staff member. Setting this to |
|
The username used by the staff member to access the rental system. |
|
The password used by the staff member to access... |