Task+2

a. Design and construct a schematic diagram for the AFL football club, including related tables, to assist in database management.  § Construct at least three tables with relationships.  § Include the primary and foreign keys. This must be completed using Microsoft Word. b. Create and insert fieldnames for each of the tables. (Insert at least 15 records in each table.) c. Create data dictionaries to describe the characteristics of the data.  § Include field name, data type, field size and a description of the field when designing the database.
 * 1. ****  Design the Solution  **

Please see Word file below.