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.

Items 21 to 30 of 30 total

per page
Page:
  1. 1
  2. 2
  3. 3

Grid  List 

Set Ascending Direction
  1. Murachs SQL Chapter 10 Membership Database

    Murachs SQL for SQL Server Chapter 10 How to create and maintain databases and tables with SQL statements

    Regular Price: $12.00

    Special Price: $10.00

    Murach’s SQL for SQL Server Chapter 10 How to create and maintain databases and tables with SQL statements
    Exercises
    1. Create a new database named Membership.
    2. Write the CREATE TABLE statements needed to implement the following design in the Membership database. Include reference constraints. Define IndividualID and GroupID with the IDENTITY keyword. Decide which columns should allow null values, if any, and explain your decisions. Define the Dues column with a default of zero and a check constraint to allow only positive values.
    3. Write the CREATE INDEX statements to create a clustered index on the GroupID column and a nonclustered index on the IndividualID column of the GroupMembership table.
    4. Write an ALTER TABLE statement that adds a new column, DuesPaid, to the Individuals table. Use the bit data type, disallow null values, and assign a default Boolean value of False.
    5. Write an ALTER TABLE statement that adds two new check constraints to the Invoices table of the AP database. The first should allow (1) PaymentDate to be null only if PaymentTotal is zero and (2) PaymentDate to be not null only if PaymentTotal is greater than zero. The second constraint should prevent the sum of PaymentTotal and CreditTotal from being greater than InvoiceTotal.
    6. Delete the GroupMembership table from the Membership database. Then write a CREATE TABLE statement that recreates the table, this time with a unique constraint that prevents an individual from being a member in the same group twice.

    Learn More
  2. CS362 Structured Query Language for Data Management Week 2 IP

    CS362 Structured Query Language for Data Management Week 2 IP

    Regular Price: $20.00

    Special Price: $15.00

    CS362 Structured Query Language for Data Management Week 2 IP

    After creating the database schema, use Insert, Update, and Delete commands to populate the tables with the following information.

    1. Insert the following classes' records:
    Code     Name     Description
    ACCT306     Accounting 1     This course introduces accounting concepts and explores the accounting environment. It covers the basic structure of accounting, how to maintain accounts, use account balances to prepare financial statements, and complete the accounting cycle. It also introduces the concept of internal control and how to account for assets.
    CS362     Structured Query Language for Data Management     This course gives complete coverage of SQL, with an emphasis on storage, retrieval, and manipulation of data.
    ENG115     English Composition     In this course, students focus on developing writing skills through practice and revision. Students will examine expository, critical, and persuasive essay techniques.
    FIN322     Investments     This course focuses on investments and investment strategies. Various investment vehicles such as stocks, bonds, and commodities are examined. Students will explore the principles of security analysis and valuation.

    2. Insert the following advisors' records:
    Name     Email
    Fred Stone     fred@college.edu
    Bob Gordon     bob@college.edu
    Jack Simpson     jack@college.edu

    3. Insert the following students' records:
    Name     Birthdate     Gender     StartDate     GPA     IsActive     AdvisorID
    Craig Franklin     1970-03-15     Male     2010-05-30     3.10     Yes     3
    Harriet Smith     1982-04-15     Female     2010-05-30     3.22     Yes     1
    George David     1984-11-05     Male     2010-10-01     0.00     Yes     3
    Ben Jefferson     1976-09-25     Male     2009-02-21     1.80     No, the student has gone on temporary leave to pursue other opportunities but plans on returning in 1 year.     3

    4. Delete the course named Investments from the system.

    5. Change Harriet Smith’s birthdate to April 25, 1982 and her GPA to 3.25.

    Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Provide an introduction explaining the important of these commands in relation to your overall Key Assignment.

    Learn More
  3. CS362 Structured Query Language for Data Management Week 3 IP Select statements

    CS362 Structured Query Language for Data Management Week 3 IP Select Statements

    Regular Price: $20.00

    Special Price: $15.00

    CS362 Structured Query Language for Data Management Week 3 IP Select Statements:

    Provide select statements to satisfy the following data requests:
    1. List all active male students assigned to Advisors 1 or 3 (Fred Stone or Jack Simpson). (Where Clause - Filtering 3 different things: Active, Male Students, Adivsors)
    2. Provide a list of all students without a biography. (focusing Null Biography)
    3. What classes are in the English department? (Where Clause)
    4. Create a list of all students and their advisors. Sort by the advisor’s name and then the student’s name. Include the student’s birth date, gender, and GPA. (join's statement combine the two tables students and class tables: Order by clause like birthday, gpa,etc)
    5. How many students were born in the 1980s? (Aggregate using count expression)
    6. Write a query to show the average GPA by gender. (Aggregate using count expression)
    7. Provide a list of all advisors and the number of active students assigned to each. Filter out any advisors with more than 1 student. (Combine lines 4-6)

    Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Include an explanation as to how and where these queries or others like them can be used in your final system. Upload your document to the Submitted Tasks.

    Learn More
  4. CS362 Structured Query Language for Data Management Week 4 IP Extended Design SQL Server

    CS362 Structured Query Language for Data Management Week 4 IP Extend the Design

    Regular Price: $20.00

    Special Price: $15.00

    CS362 Structured Query Language for Data Management Week 4 IP Extend the Design

    Using your Week 1 IP as a starting point, extend the design to accommodate degree programs. The new design should incorporate the following functionalities:

    1. A degree has a name and description.
    2. What degree is the student working towards? A student can only work on one degree at a time.
    3. What classes are necessary to obtain a specific degree?
    4. Provide the DDL script to add the tables for the new design changes. Include an updated diagram that shows all the tables in the system.
    5. Write the DML script to insert 3 test records in each of the tables in the system. This data will be necessary to write the queries in the next assignment.

    Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks section.

    Learn More
  5. CS362 Structured Query Language for Data Management Week 5 IP Functions MySQL

    CS362 Structured Query Language for Data Management Week 5 IP Functions Stored Procedure and Indexes

    Regular Price: $20.00

    Special Price: $15.00

    CS362 Structured Query Language for Data Management Week 5 IP Functions Stored Procedure and Indexes

    This assignment requires you to take your extended design from Week 4 IP and add proper indexes, a function, and a stored procedure. Your changes will provide functionality used by the teachers for screens such as a grade book. Be sure any code is properly formatted and has appropriate comments.

    Part 1: Function
    Write a user-defined function (UDF) that calculates a student's GPA for a given time frame. Inputs are StudentId int, ClassStartDateStart datetime, and ClassStartDateEnd datetime. The output should be the student's GPA for all classes that were taken between ClassStartDateStart and ClassStartDateEnd. Also, supply the script to call this new function, passing it parameter values of your choice.

    Part 2: Stored Procedure
    Write the DDL script to make a stored procedure that returns data needed to display a grade book screen for a professor. The only input for the stored procedure is a ClassId. Outputs need to include student names and grades for all assignments as well as a calculated overall grade for the class for each student. Provide an example calling this new stored procedure, passing it parameter values of your choice. Include a screenshot of the output.

    Part 3: Indexes
    Provide a list of suggested indexes and the DDL script to create them. Include an explanation of the purpose of indexes and how you made your decision for the fields to include in your list of suggested indexes.


    Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks.

    Learn More
  6. Unit 4 Individual Project ddl

    ITCO231 Unit 4 Individual Project Database SQL Server

    Regular Price: $20.00

    Special Price: $15.00

    Unit 4 Individual Project: Database SQL Server

    Deliverable Length:
    1 Database Diagram; DDL for 7 Tables

    Details:
    The following is the same database diagram from Unit 3:

    Using this diagram, address the following:
    Establish the relationships between the tables in the SQL server environment.
    Ensure that all primary keys are properly created and that the foreign key columns are defined correctly.
    Make sure that the 3 additional tables you added in Unit 3 are also shown and have established primary and foreign keys to appropriate tables.
    Update the database diagram, and generate the data definition language (DDL) for the new tables.
     Describe what changed in the DDL for each table.
     Describe any changes that were needed from the original model to create the relationships.
    Submit a consolidated Word document with all screenshots and the DDL.

    Learn More
  7. Unit 5 Individual Project Database SQL

    ITCO231 Unit 5 Individual Project Database SQL Server

    Regular Price: $20.00

    Special Price: $15.00

    Unit 5 Individual Project Database SQL Server

    Deliverable Length: 7 SELECT statements; 3 SQL JOIN statements

    At this point, you will add data to your database and validate that they 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 30 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 30 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 10 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, first_name, last_name, and department_name for all employees.
    Rows returned
    Display the employee id, first_name, last_name, and job title_name for all employees.
    Rows returned
    Display the employee id, first_name, last_name, department_name, and job title_name for all employees.
    Rows returned

    Combine all of the SQL statements (text only) and screenshots into a single Word document, and submit it for grading

    Learn More
  8. ITCO630 Unit 3 Individual Project SQL Script

    ITCO630 Unit 3 Individual Project SQL Script

    Regular Price: $20.00

    Special Price: $15.00

    ITCO630 Unit 3 Individual Project SQL Script

    Deliverable Length: SQL Script

    Unzip, and attach the sample database ITCO630_A. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time.
    The following are the tables and data in the ITCO630_A database:

    Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITCO630_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.

    1. Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker."
    2. Create a view called v_no_points with all the columns of the assignment table except the points column.
    3. Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.

    Learn More
  9. Home Warrany Corporation HWC CUBE and GROUPING SETS SQL Statements

    Home Warrany Corporation HWC CUBE and GROUPING SETS SQL Statements

    Regular Price: $15.00

    Special Price: $12.00

    You designed an OLAP database for Home Warrany Corporation. Based on that design, submit the following two SQL statements.


    1. Use the CUBE extension to show the sum of costs aggregated by all permutations of appliance serial,  employee id, customer id, and year.
    2. Use the GROUPING SETS extension to show the same data.

    Learn More
  10. DBM/502 Week 3 sql statements and screenchot

    DBM 502 Week 3 Data Population, Manipulation, and Retrieval

    Regular Price: $15.00

    Special Price: $12.00

    Individual Assignment Database Creation and Reporting

    Resources: The entity relationship diagram and normalized table specifications from the Week Two individual assignment, SQL Server® and Reporting Services on the Toolwire® site, and Beginning Microsoft® SQL Server® 2008 Programming

    Based on your Week #2 IA’s table design metadata, program your own SQL statements using SQL Server’s Management Studio to create, populate, and query a relational database for the Huffman Trucking’s fleet truck maintenance application.

    (3 points) Use CREATE TABLE statements to create a table for each entity for Huffman Trucking’s fleet truck maintenance database.

    (2 points) Use INSERT statements to populate the tables with realistic sample data. Include at least 2 rows for each table.

    (2.5 points; 0.5 point each) Use a separate SELECT statement to create each of the following queries:

    • A simple query for each table that returns all of the columns and all of the rows for each table.

    • A query that displays each part that has been purchased by Huffman Trucking Company. For each part, also retrieve its parts catalog information from the parts catalog table and vendor information from the vendor table.

    • A query that displays all of the rows in the vehicle maintenance table. For each vehicle maintenance row, join the corresponding information from the maintenance descriptions table and vehicles table.

    • A query that displays each row in the maintenance work order table. For each row in the maintenance work order table, join the corresponding information from the maintenance description table.

    • A query that counts the number of maintenance work orders for each vehicle in the maintenance work order table. Display the vehicle column and the corresponding count of work orders for each vehicle.

    (2.5 points) Create a report using the SQL Server Business Intelligence Reporting Services of the parts purchasing history for Huffman Trucking Company. The report should display all parts purchasing history including manufacturer and vendor information, parts catalog information, and associated parts inventory issues, and all parts inventory purchases.

    Format the report to present to senior management at Huffman Trucking.

    Place screen snapshots of all of the above SQL statements as they executed in SQL Server Management Studio showing the SQL statements and the results returned, as well as a screen snapshot of your Reporting Services report, showing your actual data, into a single Word or .pdf file Learn More

Items 21 to 30 of 30 total

per page
Page:
  1. 1
  2. 2
  3. 3

Grid  List 

Set Ascending Direction