Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hoover Zoo works with TV and movie producers who need birds that can perform special tricks, such as playing dead, reciting poetry, climbing ladders, and

Hoover Zoo works with TV and movie producers who need birds that can perform special tricks, such as playing dead, reciting poetry, climbing ladders, and various other tricks. Hoover Zoo has about 45 birds and a list of 15 tricks from which to choose. Each bird can perform one or more tricks, and more than one can perform many tricks. When a bird learns a new trick, the trainer assigns a skill level. Some
customers insist on using birds that score a 10, the highest skill level. As an IT consultant, you are asked to design an ER model.
Put your answer below each question.
1. Draw a complete ERD using Chens notation.
2. Draw a complete ERD in Crows Foot notation
3. Develop a data dictionary for all tables in your ERD.
4. Use Excel to add 5 sample records to each of your tables
5. Analytical thinking: Given the above scenario, what are the business-related questions you can
think of?( develop 2 questions)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administration The Complete Guide To Dba Practices And Procedures

Authors: Craig S. Mullins

2nd Edition

0321822943, 978-0321822949

More Books

Students also viewed these Databases questions

Question

What about leadership lessons from particularly good or bad bosses?

Answered: 1 week ago

Question

When would you use one approach, and when would you use another?

Answered: 1 week ago