please create the databse per assignment instructions from the databse ERD diagram i have included at the bottom

Based on your corrected diagram (which you will turn in with this assignment), you will now create a PHYSICAL SQL SERVER script (writing it out using the standards l discussed and demonstrated in this week's video presentations. Your ONE SINGLE CONTINUOUS SCRIPT (SAVED WITH EXTENSION txt, not sql) should: 1) Have comments 2) CREATE the DATABASE (make sure you name it WSU, and prefix it with your last name Example: "FRY WSU"), and drop the database first, IF it already EXISTS. Use a filesize of 10MB with a Maxsize of 50MB and filegrowth of 10%. Include a log file that assumes heavy read/write. Note: The FileName path on Titan 2014 is"C:\Stage" (this will differ from your local (and what was shown in older videos). I also recommend creating a C:lstage on local, so the same script will work in both places. 3) CREATE every TABLE (without PK s you have in your corrected assignment 2 diagram, with the correct SQL SERVER DATA TYPES, using NULL/NOT NULL, and IDENTITY, as appropriate. 4) ALTER every TABLE and ADD a CONSTRAINTS (first PRIMARY, then FOREIGN (including CASCADE), then a least a couple CHECK and DEFAULT constraints make some up)