Information/Logical design of database model (using a word file to include in e-portfolio 1) Your task in this part of the assignment is to create an information/logical level design model for the...

 Information/Logical design of database model (using a word file to include in e-portfolio 1)
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.

B.1 Design requirements for the information/Logical Model:
a)     Specify all entities
b)     Find attributes for each entity
c)      Specify primary keys for all entities
d)     Find the relationships between different entities
e)     Resolve many-to-many relationships
f)       Perform normalization.
g)     Write down five useful queries that can be used to ask questions from the database.
1.    One query – using 1 table only
2.    Four queries – using more than 1 table
Note: These queries may vary when you implement the database in the second assignment. However, it is important to think about how the database can be used for query purposes at this stage.
h)     Draw an E-R diagram

Use a Word document to record and address the requirements listed in item B.1 above. This word file is the second element in your e-portfolio 1. You may use any software program to draw the E-R diagram and paste it on to the word document.