Answered step by step
Verified Expert Solution
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
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 CommentsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started