B. Information/Logical design of database model (using a word file) Your task in this part of the assignment is to create an information/logical level design model for the given case study (see below...

B. Information/Logical design of database model (using a word file) Your task in this part of the assignment is to create an information/logical level design model for the given case study (see below for the case study). The information/logical model is a representation of an organization’s data, organized in terms of entities and relationships and independent of any data management technology. It includes all entities and relationships among them, all primary keys for all entities are specified, all attributes for each entity are specified, all foreign keys are specified. Normalization occurs at this level, if needed.