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 repr

Get perfect grades by consistently using www.custompaperwriting.org. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

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.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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.

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an excellent paper from our writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper