ou can assume that each employee is uniquely identified by the social security number. a. Identify the entities in given business case above. b. Identify suitable attributes for all entities...

ou can assume that each employee is uniquely identified by the social security number.


a.    Identify the entities in given business case above.



b.     Identify suitable attributes  for all entities identified in the above (a)




c.    What are the statements which describe the relationships between entities? List all the statements in the business case.


d.    Represent the structure of your database visually by using the entity-relationship (E-R) diagram.








2.    Build this model using MS Access by creating these tables and Relationships in Access.   Populate these tables with appropriate data, at least 3 records in each table.  Include:


a.    Relationship diagram created in Access. (Select database tools Relationships in the Access menu)


b.    Data sheet view and design view of your tables.




3.    Determine the functional Dependencies that exist in the following table and convert it to an equivalent collection of tables that are in third normal form.