Question

Using your SQL Server Management Studio, complete the following task.

1. Create new login to your database. Take the screenshots and explain the step to create new login.
2. Create a new database. Take screenshot and explain the step to create new database.Show the screenshots of how you can create a new table in this database. Create a table called customer which will store the following information: ID, name, address, city, phone, email and salary. The column salary can be empty.

Answer 1

To create a new login in SSMS, right-click on the 'Security' folder and follow the prompts. Create a new database by right-clicking on 'Databases' and entering the necessary details. Lastly, create a 'customer' table with specified columns within the new database.

Step-by-step explanation:

To create a new login in SQL Server Management Studio (SSMS), follow these steps:

1. Open SSMS and connect to your server instance.
2. In the Object Explorer, right-click on the 'Security' folder and then click 'New' -> 'Login'.
3. In the Login - New dialog, enter the login name and choose authentication type, then click 'OK'.

To create a new database, follow the subsequent steps:

1. Right-click on the 'Databases' folder in the Object Explorer and select 'New Database'.
2. Enter the database name and configure settings as needed, then click 'OK'.

Finally, to create a new table called 'customer' within your database:

1. Expand the newly created database, right-click on the 'Tables' folder, and choose 'New Table'.
2. Define the columns as specified, setting ID as the primary key and allowing Salary to accept null values.
3. After defining all columns, click 'Save' and name the table 'customer'.

Bear in mind that screenshots are not provided here, as this is a text-based response.