SQL :

Create the following four tables based upon the relational model and foreign key requirements. Use your judgment for data types, sizes, and when to use NOT NULL artist(aid, fname, Iname, dob, gender) band(bid, name, yearformed) in band(aid, bid, date in, date out) album (albumid, published year, title, price, publisher, format, bid) Note: If an artist is still in a band, then the in_band column date_out would be NULL. There must be some active artists and bands. Important: Be sure to set up primary and foreign keys correctly and add the "engine-innodb" statement. Refer to Lecture