Question: Just need help with 5-5- and 5-6 please. COLLABORATION EXERCISE 5 The Falcon Security problem is an excellent example of the use of a small

Just need help with 5-5- and 5-6 please.

Just need help with 5-5- and 5-6 please. COLLABORATION EXERCISE 5 The

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-8. Transform the data model in Figure 5-17 into a rela- 5-4. Study Figure 5-17 to understand the entities and their rela tional database design. Hint: Create a table for each entity and relate those tables tionships. Justify each of the cardinalities in this model. 5-5. Working with your team, develop a list of seven queries 5-9. Create an Access database for your design in question 5-8 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 Video Facility DronelD Type CameraType AcquisitionDate TopSpeed Ceiling VideolD Date StartTime Length Altitude URL FacilitylD Address Type ContractID ContactName ContactPhone 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!