Question: 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

Just need help on 5-4 COLLABORATION EXERCISE 5 The Falcon Security problem

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!