Design a collection of database tables for the Springfield Town Council. The council is made up of representatives from each of the town’s 15 precincts. The data you need to store includes the following attributes:
Precinct number
Precinct population
Council representative’s last name
Council representative’s first name
Council representative’s phone number
Council representative’s political party
Political party chairperson’s name
Political party headquarters address
Design the tables you would need so they are all in third normal form. Create at least five sample data records for each table you create.