Design a database that meets the reporting needs indicated above. The design should include an E-R Diagram, a logical data model using the relational model (relation/table definitions), with a domain definition chart (in a tabular form) for all the attributes/columns of each table/relation. For example, the start date and last name of the employee table:
Employee Table
Attribute/Column
Description/Full Data type name/Purpose
The start date of the employee.
DATE
Last name of the employee.
Character Variable
Length/Size
Filtering rule, etc.
Sample data
START_DATE
10
After 01/01/2005
06/25/2011
L_NAME
20
LEE