Chapter 5, Problem 5.9CE5

Explanation of Solution

Two steps in transforming the data model into database design:

The following are the two steps required in transforming the data model into database design:

• The table is created for each entity by the database designer.
  • The key of the table will be its identifier.
  • The column of the table will be the attribute.
  • The tables that are present, normalized in such a way to form a single theme.
• The relationship are established among the tables.

List of entities identified in the “Figure 5-28”:

The below are the lists of entities identified in the “Figure 5-28”:

• Drone
• Video
• Facility
• Analysis

Analysis of the relationship cardinalities present in the “Figure 5-28”:

The below are the cardinalities that are identified in the “Figure 5-28”:

• Mandatory one to optional Many cardinalities
  • Between Drone and Video entities
    • A Drone can take many Videos
    • A video can be taken by one Drone
    • The instance of the Video is optional for Drone...