'******************** LAB ***********************' -- Do the following: -- 1) Create a new database called SoftwareInventory -- 2) Create tables to record what software is installed -- on the computers in a department. -- * Record both the Computer's and Software's name -- as well as the version of the Software. -- * Include both Primary Keys and Foreign Key constraints -- 3) Create a new Database Diagram and review the design -- 4) Insert data into each table to verify the design -- 5) Create a Query the shows all of the software on each computer -- 6) Create a Script that can be used to build this database -- 7) Optional: Include tables that detail which computer belonging to a department '*************************************************'