Open up Terminal in Visual Studios

08 Aug Open up Terminal in Visual Studios

Posted at 12:02h in computer science by

PART I

Type: npm -v and node -v

The output should provide the versions that are installed

Save a screenshot and upload it here.

Posted Wed Apr 27, 2022 at 3:50 pm

PART II

Write the queries in MySQL Workbench

1. Write a query that links 2 different tables together and provides all of the data fields except for the ID

>>>> Output should be in the console showing the data on the screen

2. Write a second query that INNER JOINS on all of the tables in your schema and provide data elements from each of the tables

>>>> Output should be in the console showing the data on the screen

3. Write a query that includes a INNER JOIN on all of the tables, with a WHERE clause, AND clause, ORDER BY

>>>> Output should be in the console showing the data on the screen

4. Provide a copy of the SQL Queries that you utilized (Save as Mod8_PartII_YourName.sql) and attach

PART III

Repeat Part II but this time use the HTML table output

>> Provide an output of ALL of the data

>> Provide a second output of the data with the WHERE , AND clause in the statement

Upload your source code (JS, HTML) etc; all here..

Instructions: Download the JS file here and modify lines 13, 28, 30, 39

Provide a screenshot showing the data was outputted on the Web Screen

Posted Wed Apr 27, 2022 at 3:50 pm