Your Tasks 1. Create an MS Word document named “Your Name – Your Student Number – Musica.docx" 2. Create an ER Diagram from the above scenario. Create this ER Diagram with Lucidchart (on Google Drive)...

Your Tasks


1.   Create an MS Word document named “Your Name – Your Student Number –
Musica.docx"


2.   Create an ER Diagram from the above scenario. Create this ER Diagram with Lucidchart (on Google Drive) or similar.  Mark cardinality, existence, primary keys (with an underline), and foreign keys (with an FK in brackets).  Be sure to include your name and student number within the drawing.


Insert that ER Diagram into your Word document.  You can do this by taking a screenshot, by exporting it and then inserting it, or using any other techinique.


3.   For each of the following write the T-SQL code in Microsoft SQL Server and after each question copy and paste into our Microsoft Word document


    The code as plain text
    Screenshots of Microsoft SQL Server, showing all of the code and the result of running the code.


a)   Use CREATE statements to build the database and its tables.  Build relationships between tables and enforce referential integrity appropriately.  Use your given name in the name of the foreign key constraint
b)  Include in the code a comment containing your full name and the date you write your code.
c)   Use INSERT statements to insert at least 5 records into each of the tables in your database.  Include a comment in the code that shows your name and the date.
d)  Use SELECT statements to display all of the records in each table