Scribd
Upload
11 views1 page

CSCI450 Platform Based Development Project1 - Spring 2022

This document outlines Project #2 for the CSCI 475/575 course at St. Cloud State University, due on January 28, 2022. It involves creating a database, performing SQL operations such as INNER JOIN and LEFT JOIN, and taking screenshots of the results. Students must upload their screenshots for grading, and the project is developed by Sam Espana.

Uploaded by

Naomie Bambara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views1 page

CSCI450 Platform Based Development Project1 - Spring 2022

This document outlines Project #2 for the CSCI 475/575 course at St. Cloud State University, due on January 28, 2022. It involves creating a database, performing SQL operations such as INNER JOIN and LEFT JOIN, and taking screenshots of the results. Students must upload their screenshots for grading, and the project is developed by Sam Espana.

Uploaded by

Naomie Bambara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

St.

Cloud State University CSCI 475/575 Platform Based Development

CSCI 475/575 – Platform Based Development - Spring 2022


Project #2 – Due: Friday, January 28, 2022

NAME:

PART I – CREATING AN INNER JOIN


This project will require for you to install the MS SQL Server 2019 Developers Edition.
Copy/paste screenshots into this document.

STEPS
1) Create a database LastnameDB. Then, create the SQL Server Sample Database. Screenshot [Link]
[Link]
2) Insert your name in the table customers. SELECT customers to show data (screenshot as [Link])

3) Create an INNER JOIN showing products with list price in descending order. Save as [Link]
[Link]

4) Using the inner join above, create a view as uv_INNERjoin. Take screenshot as [Link]

5) Create a LEFT JOIN showing products ordered by model_year and order_id. Save as UVLeftJoin. ([Link])
[Link]

Note: Please show your name for every SELECT. Upload all five screenshots to D2L (Project #2) for grading.

Project developed by Sam Espana, for CSCI 475/575 Platform Based Development

You might also like