Question: Software Requirement: Microsoft SQL Server Management Studio 18.0 or higher Microsoft SQL Server Express 2017 Instructions Create queries for the following items. 1. The company

 Software Requirement: Microsoft SQL Server Management Studio 18.0 or higher Microsoft

Software Requirement: Microsoft SQL Server Management Studio 18.0 or higher Microsoft SQL Server Express 2017 Instructions Create queries for the following items. 1. The company manager requested to view the list of employees on the system, including employee ID and status. To comply with the request, create a query that shows the Employeeld, FirstName, LastName, and Status in the Employee table on the database. 2. Company XYZ manually viewed all the products and purchased items in their list. They have an existing system, but it does not have the function to view the products and purchased items. They requested to add a function to the developer. To comply with the request, create a query that displays the columns of the Product table and the Purchase table. 3. Company ABC requested to remove the existing database and create a new database for the new system. To comply with the request, write a query that creates a new database named dbo.Products and removes the database named dbo.Items

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!