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-4. Study Figure 5-17 to understand the entities and their relationships. Justify each of the cardinalities in this model. 5-5. Working with your team, develop a list of seven queries that together use all of the entities in Figure 5-17. 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 relationship's cardinalities. 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 relational 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-10. Fill your database with sample data. Because you do not have files on a server, leave the URL column blank. 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 DroneID Type CameraType AcquisitionDate TopSpeed Ceiling Video VideoID Date StartTime Length Altitude URL Facility FacilityID Address Type ContractID ContactName ContactPhone Analysis ID Date Time Employee Comments
Added by Richard C.
Close
Step 1
Cardinalities in a data model represent the number of occurrences of one entity that can be associated with the number of occurrences of another entity in a relationship. In the context of the Falcon Security problem, the E-R diagram in Figure 5-17 consists of Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 92 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Create two ERDs using Crow's foot notation on a blank sheet of paper. The Talent Agency You are asked to build a database for a talent agency that books musical bands into nightclubs. The agent needs a database to keep track of the agency's transactions and to answer day-to-day questions. For example, a club manager often wants to know which bands are available on a certain date at a certain time or wants to know the agent's fee for a certain band. Similarly, the agent may want to see a list of all band members and the instrument each person plays or a list of all bands that have their members. You have talked to the agent and have observed the agency's business operation. You conclude that your database needs to reflect the following facts: A booking is an event in which a certain band plays in a particular club on a particular date, starting and ending at certain times, and performing for a specific fee. Bands may play more than one booking, but each booking is for just one band. A nightclub can have multiple bookings (for the same day or different days), but each booking is for only one nightclub. Each band has at least one member and an unlimited maximum number of members. Musicians play in only one band. The agent keeps track of the primary instrument a musician plays (vocals, drums, bass guitar, etc.). 2. The Art Museum An art museum owns a large volume of works of art. Each work of art is described by an item code, title, type, and size; size is further composed of height, width, and weight. A work of art is developed by an artist, but the artist for some works is unknown. An artist is described by an artist ID, name, date of birth, and date of death (which is left blank for living artists). Only data about artists for works currently owned by the museum are kept in the database. At any point in time, a work of art is either on display at the museum, held in storage, away from the museum as part of a traveling show, or on loan to another gallery. The museum wants to retain a complete history of loaning a work of art to other galleries, and each time a work is loaned, the museum wants to know the date the work was loaned and the date it was returned.
Sri K.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD