User Account

All Pages

Discuss the basic categories of nosql databases

Assignment Help PL-SQL Programming
Reference no: EM132310352

Assessment - Research and SQL Queries

Assessment Part A:

NOTES

- This assignment requires you to use SQL Workbench to complete the tasks.
Instruction sheet on how to install SQL Workbench will be placed under ‘student resources' on Interact2.
- You will need to download and use the file ‘Assignment5', from Interact2 Student Resources in the ‘Assignment 5 - SQL DB' folder.
- Queries need to have the correct syntax and must show the results after execution:

Typing the SQL statements or the results is NOT acceptable.

Write and run SQL statements to complete the following tasks

1. List the names and codes of vendors and the number of products each vendor has supplied, i.e. vendor AA has supplied xxx products, and vendor BB has supplied yyy products etc.

2. Show the total value of invoices for each customer with the customer the Last Name, and a column heading showing ‘Total_invoice_value' in the results.

3. List the names of the customers and how many times a customer generated an invoice: make sure the new column heading reads "Num_Of_Invoices".

4. Through a calculation, show the Total unit price (aliased column) for the units and line price.

5. Show the details of the invoice that has the minimum subtotal.

6. List all the purchases made by customer Orlando. (use a natural join).

7. Add a new vendor row/record in the vendor table and use your teacher's name and your choice of other details. (1m)

8. Add a new row/record to the `customer` table to include your actual student_ID in the CUS_CODE, your last_name as the CUS_LNAME` and your first name as CUS_FNAME. Add any other details of your choice in all the other fields.

9. Add a new attribute (field) ‘Customer_rating' with data type and length ‘VARCHAR(14) to the vendor table.

10. Update ‘Customer_rating' for the Customer that has ‘your student ID and name' from point 2, to show ‘GREAT'.

Assessment Part B (approx. 500-550 words):

Note: you are expected to conduct research about current and future Database technologies by answering the below question:

Research Question: List and discuss the four basic categories of NoSQL databases: outline the differences between these categories and give examples where these are used.

Note: Use proper references in the APA style.

Attachment:- SQLite A5 guide.rar

Verified Expert

This is regarding the queries designed to answer few questions regarding customer and products in sqlite.A brief description of the no sql database is also provided and how they are different from sql databases.Various types are described and advantages of no SQL databases is also provided.

Reference no: EM132310352

Questions Cloud

Which kinds of inflation do you show : Use the AS/AD model for describing different unemployment-inflation scenarios. Which kinds of inflation do you show, thereby? Based on these scenarios.
Develop a web application : ITAP2003 Introduction To Web Application Development Assignment - Victorian Institute of Technology, Australia. Develop a web application
Discuss at least two challenges public administrator : Discuss at least two challenges an public administrator should consider when preparing a trend analysis over a five-year period.
Research the company you have chosen in detail : Research the company you have chosen in detail regarding their CSR (Corporate social responsibility) programs.
Discuss the basic categories of nosql databases : ITC556 - Database Systems - Charles Sturt University - discuss the four basic categories of NoSQL databases: outline the differences between these categories
Create loyalty toward their products or services : Explain marketing message Sara Lee Incorporated is using to get their message or idea out to customers and to create loyalty toward their products or services
Develop an initial scope document and proposal : For this assignment, you will develop an initial scope document and proposal for deploying an Enterprise Security Infrastructure Project.
Identify boundary value cases related to the student answers : Software Testing Assignment - Case Study - MTEST Multiple choice study program. Identify boundary value cases related to the student's answers
Construct an integrated strategic cybersecurity approach : Using the organization that you selected for Week 7, the resources for Week 8, and extended exploration for this assignment, construct an integrated strategic.

Reviews

len2310352

5/22/2019 10:56:13 PM

Criteria HD PART A: be able to use complex SQL commands to query a database. PART B: be able to research a recent development in the field of database technology. PART A:SQL syntax returns all attributes that meet the business requirement from the tables that hold the data and applies the correct restrictions to retrieve the required information. PART B: Demonstrates an excellent ability at researching recent developments in the field of database technology with all the responses supported by examples and use correct terminology.

len2310352

5/22/2019 10:56:06 PM

You are required to submit the following file: A Word document with 2 parts – Part A: the SQL statements for each query (should be copied from your Workbench software into your Word assignment file): The screenshots of the results of the SQL statements copied and pasted into your submission file immediately after you execute the SQL query and under the SQL statements for the question. Part B: Your researched answer in about 500-550 words on NoSQL database technologies. This assessment task will assess the following learning outcome/s: • be able to use complex SQL commands to query a database. • be able to research a recent development in the field of database technology.

len2310352

5/22/2019 10:55:51 PM

Read the file SQL carefully there are resources at the end and also link for SQL software. • This assignment requires you to use SQL Workbench to complete the tasks. Instruction sheet on how to install SQL Workbench will be placed under ‘student resources’ on Interact2. • You will need to download and use the file ‘Assignment5’, from Interact2 Student Resources in the ‘Assignment 5 - SQL DB’ folder. • Queries need to have the correct syntax and must show the results after execution: Typing the SQL statements or the results is NOT acceptable.

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd