SQLServer

Need Help in SQL Server Assignment?
We can help you if you are having difficulty with your SQL Server Assignment. Just email your SQL Server Assignment at admin@assignmentcache.com.
We provide help for students all over the world in SQL Server Assignment.

3 Item(s)

per page

Grid  List 

Set Ascending Direction
  1. ITCO231 Unit 5 HR Database Tables

    ITCO231 Unit 5 HR Database

    Regular Price: $25.00

    Special Price: $20.00

    ITCO231 Unit 5 HR Database


    Update the database diagram, and generate the data definition language (DDL) for the Contacts table and any others that you wish according to the following diagram. Be sure to define the appropriate relationship between the Contact table and the Employee table.


    Add data to your database and validate that your records loaded properly. In tabular format, include 3 rows for each table, making sure that the primary–key and foreign–key relationships are properly applied.
    Next, you will insert the 20 rows of data that you identified (using the concepts you worked on identifying the primary and foreign keys), then perform queries using JOIN syntax of the database.
    Task 1: Create 3 rows of data for each table ensuring that the referential integrity is valid.
    Task 2: Add the 20 rows of data to the appropriate table in your database (using any appropriate method available).
    Task 3: SELECT all columns and all rows of the tables. Create a screenshot of each query and output data, and submit them.
    Task 4: Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data):
    Display the employee id, contact id, first_name, middle name, last_name, and phone number for all employees.
    Rows returned
    Display the employee id, contact id, first_name, middle name and last_name, and email address for all employees.
    Rows returned
    Display the employee id, contact id, first_name, middle name, last_name, phone number, and email address for all employees.
    Rows returned
    Combine all of the DDL/SQL statements (text only), diagram and screenshots into a single Word document. Submit it for grading.

    Learn More
  2. ITCO231 Assignment 1 AdventureWorks Database

    ITCO231 Unit 2 AdventureWorks Database

    Regular Price: $25.00

    Special Price: $20.00

    ITCO231 Unit 2 AdventureWorks Database


    Task 1
    Click here to download and install the AdventureWorks LT2012 database into the SQL environment. Unzip the file and store the data file and the log file into the Data folder within the folder Program Files (x86)/Microsoft SQL Server/MSSQL11.SQLEXPRESS/MSSQL/DATA .
    Choose the appropriate file based on whether you are running SQL Server 2012 or 2008.


    Task 2
    Generate a database diagram for all the tables in the database.
    Include a screenshot of this diagram in your Word document.


    Task 3
    Write SELECT statements for the following questions:
    For each of these statements, include a screenshot of the SQL statements and results. Make sure to include the statement execution, including the resulting data.
    Display all columns and all rows from the Customer table.
    Display the ProductID, ProductNumber and ListPrice for all rows in the Products table.
    Modify query 2 so that the column headings are as follows:
    "ID," "Number," and "List Price"
    Display the CustomerID, full customer name, and CountryRegion for all customers.
    Display the CustomerID, full customer name, and CountryRegion for all customers.
    Name the columns "ID," "Name," and "Region" (respectively), and sort the data by the company name.


    Combine all of the screenshots into a single Word document, and submit this for grading.

    Learn More
  3. ITCO231 Unit 3 HR Database Tables

    ITCO231 Unit 3 HR Database Tables

    Regular Price: $25.00

    Special Price: $20.00

    ITCO231 Unit 3 HR Database Tables


    Create the needed tables in the SQL server environment (just tables, no relationships yet).


    Use integer (INT) data types for all ID columns.
    Use DATE data types for all date-related columns.
    Rate related columns should be DECIMAL data types.
    All other data types should be VARCHAR.
    In addition, create 3 additional tables that could be consistent in a database for a human resources (HR) application, including an appropriate table name and appropriate columns.
    Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.
    Submit a consolidated Word document with the screenshot and the DDL for all tables (text only, no screenshots).

    Learn More

3 Item(s)

per page

Grid  List 

Set Ascending Direction