Conceptual and Relational Modeling Background You have been hired by an organaization as an IT consultant in the Athletics department to help them organize data gathered from two Excel worksheets representing high school recruiting.
attached working sheets.
Tasks Create a single Word document. Place your name at the top of the document. Address each of the following tasks. Each task in your Word document must be numbered so that it is clear which task you are answering.
1. Using the worksheets above, write the business rules that govern the relationship between COACH and ATHLETE. Hint: Remember relationships are always bidirectional.
2. Using Visio or Lucidchart, create a conceptual model in Crow’s Foot notation to model the business rules you just identified. Make sure you properly label the entities and relationship using best practices covered. Include your name in bold in a text box on the diagram. Paste a screenshot of your completed diagram.
3. For additional data modeling practice with, recreate the conceptual model shown below, exactly as is. Replace the middle of the diagram with your name in bold in a text box. Paste a screenshot of your completed diagram.
attached a picture
Use the completed conceptual model you created in #2 and the Excel worksheets to answer all remaining questions.
4. To convert the conceptual model into a relational model, list the relations that would be present in the relational model. For each relation you list, identify the primary key and foreign keys (if there are any).
5. Using your data modeling tool, create a relational model to model the relations you just identified. Make sure you incorporate best practices covered for creating relational models.
6. Using the relational model you just created, write the relational schema correctly identifying each relation and its primary and foreign key(s) (if there are any)
7. Do all relations in your relational model exhibit entity integrity? Using course terminology, explain why or why not.
8. Do all relations in your relational model exhibit referential integrity? Using course terminology, explain why or why not.
