Murachs MySQL 3rd Edition Chapter 11 Exercise 2 and 4

Description

Murach’s MySQL 3rd Edition Chapter 11 Exercise 2 and 4

2. Write a script that contains the CREATE TABLE statements needed to implement the following design in the EX schema:

These tables provide for members of an association, and each member can be registered in one or more groups within the association.
The member_id and committee_id columns are the primary keys of the Members and Committees tables, and these columns are foreign keys in the Members_Committees table.
Include any contraints or default values that you may think are necessary.
Include statements to drop these tables if the already exist.

4. Write an ALTER TABLE statement that adds two new columns to the Members table created in exercise 2.
Add one column for annual dues that provides for three digits to the left of the decimal point and two to the right. This column should have a defualt value 52.50.
Add on column for the payment date.