BpCtw97m

1DROP DATABASE IF EXISTS memberships_database_2;
2CREATE DATABASE memberships_database_2;
3USE memberships_database_2;
4
5CREATE TABLE members (
6    member_id INT PRIMARY KEY AUTO_INCREMENT,
7    first_name VARCHAR(30) NOT NULL,
8    last_name VARCHAR(30) NOT NULL,
9    address VARCHAR(30),
10    city VARCHAR(30),
11    state VARCHAR(30),
12    phone VARCHAR(30)
13);
14CREATE TABLE group_info (
15    group_id INT PRIMARY KEY AUTO_INCREMENT,
16    group_name VARCHAR(30) NOT NULL
17);
18CREATE TABLE members_groups (
19    member_id INT,
20    group_id INT,
21    CONSTRAINT fk_member_id
22        FOREIGN KEY (member_id) REFERENCES members (member_id),
23    CONSTRAINT fk_group_id
24        FOREIGN KEY (group_id) REFERENCES group_info (group_id)
25);
26
27
28USE memberships_database_2;
29ALTER TABLE members
30ADD anual_dues DECIMAL(3, 2) NOT NULL DEFAULT 52.50