test.sql

INSERT INTO Member (MemberID, MbrFirstName, MbrLastName, MbrPhoneNumber, Gender) VALUES (101, 'David', 'Hamilton', '555-2701', 'M');

CREATE TABLE Members (
    MemberID int NOT NULL ,
    MbrFirstName nvarchar (25) NULL ,
    MbrLastName nvarchar (25) NULL ,
    MbrPhoneNumber nvarchar (15) NULL ,
    Gender nvarchar (2) NULL 
)
GO

CREATE TABLE member
(
    id int PRIMARY KEY IDENTITY,
    first_name nvarchar(20) NOT NULL,
    last_name nvarchar(50) NOT NULL,
    band_id int NOT NULL REFERENCES band(id) 
    ON DELETE CASCADE
)