Create a data dictionary TABLES table and an ATTRIBUTES table and enter data in them for Best Airlines’ mechanic's database. Your answer should be based on the format shown in Figure 10.6. Use your judgment to attribute type values, length values, etc.

b. Create a relationships table for these tables and attributes data, using the format in Figure 10.7.

                                   

FIGURE  10.6 Two data dictionary tables

                                   

FIGURE 10.7 A data dictionary table representing the many-to-many relationship between the TABLES table and the ATTRIBUTES table.

Transcribed Image Text:

Table Name Salesperson Customer Customer Employee Product Sales Office Attribute Nome Salesperson Number Salesperson Name Commission Percentage Year of Hire Customer Number Customer Name HQ City (a) TABLES table Table Length 500 6,400 127,000 83,000 273,000 600 (b) ATTRIBUTES table. Attribute Type Numeric Alphabetic Numeric Numeric Numeric Alphabetic Alphabetic Disk Number A23 A23 A23 A47 A47 A47 Attribute Length 3 20 2 4 4 20 15 Table Name Salesperson Customer Customer Employee Product Sales Office Attribute Nome Salesperson Number Salesperson Name Commission Percentage Year of Hire Customer Number Customer Name HQ City (a) TABLES table Table Length 500 6,400 127,000 83,000 273,000 600 (b) ATTRIBUTES table. Attribute Type Numeric Alphabetic Numeric Numeric Numeric Alphabetic Alphabetic Disk Number A23 A23 A23 A47 A47 A47 Attribute Length 3 20 2 4 4 20 15