Using the Entity Relationship Diagram (ERD) model provided below, write the CREATE statements required to create the three tables (include all PK and FK relationships in your CREATE statements).

CREATE STATEMENTS: (10 points)

Below you will find five rows of data that is located in the Album table for Hallux Productions. Using your knowledge of INSERT statements in SQL, provide the SQL required to insert these rows of data into the Album table.

You should have a total of 5 insert statements upon completion. Be sure to end each of your statements with a semi-colon and watch datatypes (string versus integer).

INSERT STATEMENTS: (10 points)

SONG BAND ?BandID: INTEGER NOT NULL SongID: INTEGER NOT NULL BandName: VARCHARI20) NOT NULL BandStatusCode: VARCHARI2]NOT NULL FormationDate: DATE NULL AlbumlD: INTEGER NOT NULL (FK) SongName: VARCHAR(20) NOT NULL Sequence: INTEGER NOT NULL ALBUM ?AlbumID: INTEGER NOT NULL BandlD: INTEGER NOT NULL (FK) AlbumName: VARCHAR(40) NOT NULL ReleaseDate: DATE NULL ProductionCode: DECIMAL(7,2) NULL SONG BAND ?BandID: INTEGER NOT NULL SongID: INTEGER NOT NULL BandName: VARCHARI20) NOT NULL BandStatusCode: VARCHARI2]NOT NULL FormationDate: DATE NULL AlbumlD: INTEGER NOT NULL (FK) SongName: VARCHAR(20) NOT NULL Sequence: INTEGER NOT NULL ALBUM ?AlbumID: INTEGER NOT NULL BandlD: INTEGER NOT NULL (FK) AlbumName: VARCHAR(40) NOT NULL ReleaseDate: DATE NULL ProductionCode: DECIMAL(7,2) NULL