Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Just need help on 5-4 COLLABORATION EXERCISE 5 The Falcon Security problem is an excellent example of the use of a small database in business.

Just need help on 5-4

image text in transcribed

COLLABORATION EXERCISE 5 The Falcon Security problem is an excellent example of the use of a small database in business. It is also within reach for you to develop as a practice exercise. To do so, work with your team to answer the following questions: 5-7. Discuss the advantages and disadvantages of the model you created in your answer to question 5-6 and the model in Figure 5-17. 5-4. Study Figure 5-17 to understand the entities and their rela- tionships. Justify each of the cardinalities in this model. 5-8. Transform the data model in Figure 5-17 into a rela- tional database design. Hint: Create a table for each entity and relate those tables. 5-9. Create an Access database for your design in question 5-8. 5-5. Working with your team, develop a list of seven queries that together use all of the entities in Figure 5-17. 5-10. Fill your database with sample data. Because you do not have files on a server, leave the URL column blank. 5-6. Modify the E-R model in Figure 5-17 to include a Contact entity that is related to the Facility entity. Create the relationship, and specify and justify the rela- tionship's cardinalities. 5-11. Using the Access query facility, process each of the seven queries you created in your answer to question 5-5. Figure 5-17 E-R Diagram for Falcon Security's Database Drone DronelD Type Camera Type AcquisitionDate TopSpeed Ceiling Video VideoID Date StartTime Length Altitude Facility FacilityID Address Type ContractID ContactName Contact Phone URL Analysis ID Date Time Employee Comments

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_2

Step: 3

blur-text-image_3

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

More Books

Students also viewed these Databases questions

Question

4. Solicit help from parents.

Answered: 1 week ago