Your supervisor, Jesse Baker, has asked you to begin working on data design tasks for the new information system, which will be implemented as a relational database. You will need to identify the entities, draw an ERD, design tables, and add sample data to each table.

1. List all the entities that interact with the TIMS system. Start by reviewing the data library, previous e-mail messages, DFDs, and other documentation.

2. Draw an ERD that shows cardinality relationships among the entities. Send the diagram to Jesse.

3. For each entity, Jesse wants to see table designs in 3NF. Use standard notation format to show the primary key and the other fields in each table.

4. Jesse wants to use sample data to populate fields for at least three records in each table. Better get started on this right away.