SQL
Need Help in SQL Assignment?
We can help you if you are having difficulty with your SQL Assignment. Just email your SQL Assignment at admin@assignmentcache.com.
We provide help for students all over the world in SQL Assignment.
-
DBM 502 Week 1 Individual Assignment Small Database and Paper
$15.00Build a small, simple database for your personal use. Some suggestions might be an address book, tax deduction tracking, or automotive history. You must use a relational database management system (RDBMS). You may use any RDBMS you wish (e.g. Access, SQL Server, Oracle, DB2, MySQL, etc.), although if you’re unfamiliar with any product, then you will probably find Access to be the easiest to use. Your database must have at least 2 related tables. All of your tables should be fully normalized, such that redundant data is removed. You must show how your tables were created (i.e. Design Views or SQL). You must include all applicable integrity constraints (i.e. primary keys, foreign keys, required/NOT NULL, unique, and validation rules/CHECK constraints). Submit for grading a single Word or .pdf file with screen snapshots showing all steps in the creation of your database, the creation of your tables, the population of your tables with at least 3 rows of data each, and at least 3 queries of your data. Do not submit your actual database. Include at the end of your Word or .pdf file a 200- to 350-word write-up to respond to the following: • As you built your database, what challenges did you encounter? What tips do you have for your fellow students? Learn More -
CS362 Structured Query Language for Data Management Week 4 IP Extend the Design
$20.00CS362 Structured Query Language for Data Management Week 4 IP Extend the Design
Learn More
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. -
CS362 Structured Query Language for Data Management Week 5 IP Functions Stored Procedure and Indexes
$20.00CS362 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 -
ITCO231 Unit 4 Individual Project Database SQL Server
$20.00Unit 4 Individual Project: Database SQL Server
Learn More
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. -
ITCO231 Unit 5 Individual Project Database SQL Server
$20.00Unit 5 Individual Project Database SQL Server
Learn More
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 -
ITCO630 Unit 3 Individual Project SQL Script
$20.00ITCO630 Unit 3 Individual Project SQL Script
Learn More
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. -
INF322 DATABASE MANAGEMENT Week 5 Final Project Customer Service Database
$20.00INF322 DATABASE MANAGEMENT Week 5 Final Project Customer Service Database
Learn More
The Final Project consists of building a customer service database to be submitted by the final day of the course.
Focus of the Project
1. Use the Access database you created in Week 3: Customer Service Database
2. Output 3 queries using SQL code and not the standard access view:
A query on all contacts in the customers table showing first name, last name, address, e-mail address and three additional fields from the table.
An update query that changes one or more customer records but not all records.
A delete query that removes one or more customer records but not all records.
3. Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.
4. Report on Customers in Database showing Names, State, and Phone Numbers.
5. Create a report showing contact name and birthdays. Do not show records without a birthday.
6. Analyze the data populated in the Database to show referential integrity. This includes a statement showing what the affected tables in each dataset are and how they are impacted in the case of an addition of data or a deletion of data.
7. All data and screen shots should be included in a Word document with a brief explanation of the actions you performed. -
COM 330 Chapter 11 Assignment
$20.00COM 330 Chapter 11 Assignment
Learn More
Find the solutions to Problems 1 and 2 based on the following query:
SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX
FROM EMPLOYEE
WHERE EMP_SEX = ‘F’ AND EMP_AREACODE = ‘615’
ORDER BY EMP_LNAME, EMP_FNAME;
1. What is the likely data sparsity of the emp_sex column?
2. What indexes should you create? Write the required sql commands.
Problems 4-6 are based on the following query:
SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, YEAR(EMP_DOB) AS YEAR
FROM EMPLOYEE
WHERE YEAR(EMP_DOB) = 1966;
4. What is likely data spatsity of the EMP_DOB column?
5. Should you create an index on EMP_DOB?
6. What type of database I/O operations will likely be used by the query? -
Home Warrany Corporation HWC CUBE and GROUPING SETS SQL Statements
$15.00You 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.
Learn More
2. Use the GROUPING SETS extension to show the same data. -
CS362 Structured Query Language for Data Management Week 3 IP Select Statements
$20.00CS362 Structured Query Language for Data Management Week 3 IP Select Statements:
Learn More
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.