Question

In this class, you will need to install the Amazon WorkSpace (AWS), a cloud based virtual desktop, and use the SQL Server in the AWS to complete the database projects of the class. An email with AWS access code has been sent to your CTU email account. Double check the Junk Folder if you cannot see it. Click here for the instruction to install and launch AWS.

After installing the AWS application, launch it and login to your AWS virtual desktop. On the virtual desktop, launch SQL Server 2014 Management Studio (Start->All Programs->Microsoft SQL Server 2014). Then, create a sample database with one table (click here for a video instruction to create a database with tables). Your deliverable should be a Word document with screenshots showing the sample database and table you have created, and discuss the issues that you had for this project related to AWS and/or SQL Server and how you solved them.

Please submit your assignment.

Answer 1

After performing all the above steps that are mentioned in your assignment, You need to run the following command in your SQL server:

CREATE DATABASE database_name;

Then move to that database in order to create a table within that database. The command for this is:

USE database_name;

Then in order to create the table within the database the command is :

CREATE TABLE table_name( column1 datatype, column2 datatype.....columnN datatype);

Eg:

CREATE TABLE Student_Info(id int PRIMARY KEY, Name text, Address varchar(500));