SQL Homework… Will require SQL Server but it can be downl…

SQL Homework…  Will require SQL Server but it can be downloaded for free below I have alot more of these… I’d like to find someone who does good work that i can give all of these assignments to. you may also need this database

Answer

Introduction:
SQL (Structured Query Language) is a programming language used for managing and manipulating relational databases. It provides a standardized way to interact with databases and retrieve data for various purposes. In this assignment, we will be working with SQL Server, a popular database management system developed by Microsoft. SQL Server can be downloaded for free from the official Microsoft website. Additionally, we will require a specific database for this assignment, which can also be obtained online.

Objective:
The objective of this assignment is to familiarize ourselves with SQL Server and the basics of working with relational databases. We will learn how to create tables, insert data, perform queries, and modify the database structure.

Procedure:
To complete this assignment, follow the steps outlined below:

1. Download SQL Server:
– Visit the official Microsoft website.
– Search for SQL Server.
– Download the appropriate version of SQL Server based on your operating system.
– Follow the installation instructions provided.

2. Download the sample database:
– The assignment requires a specific database.
– Download the provided database from the given link.
– Extract the database files from the downloaded archive.

3. Import the database into SQL Server:
– Open SQL Server Management Studio (SSMS), which is the primary interface for working with SQL Server.
– Connect to your SQL Server instance by providing the necessary credentials.
– Create a new database by right-clicking on “Databases” and selecting “New Database.”
– Provide a name for the new database.
– Right-click on the newly created database and select “Tasks” > “Import Data.”
– Follow the instructions in the Import Wizard to import the database from the downloaded files.

4. Database exploration:
– Familiarize yourself with the database structure by examining the tables, their relationships, and the available data.
– Use SQL Server Management Studio to browse the tables, view the data, and understand the relationships between them.

5. Assignment-specific tasks:
– Read through the assignment instructions to understand the tasks you need to complete.
– Use SQL Server Management Studio to write and execute appropriate SQL queries to address each task.
– Write clear and concise queries that retrieve the required data in the desired format.

Deliverable: