**Vince's Vinyl: Database Testing**It is time to test Vince's database to see if it truly meets his needs. Review the business rules and test them with some SQL. Look at the business rules you developed previously, and design some SQL queries to test them.**Documentation:** Set up a test plan. List the rule, the SQL you wrote, and the results. Also, note whether the database passes or fails the test. Your queries should include the following:- Two or three simple SELECTs with various WHERE criteria.- Two or three queries using aggregate functions.- At least two queries that use joins.- Two or three INSERT statements.- One or two UPDATEs and/or a DELETE.

Answer is explained below in detail

VINCE'S VINYL It is time to test Vince's database to see if it truly meets needs. It is time to look back at the business rules and them with some SQL. Look at the business rules you de- oped previously, and design some SQL queries to test th Documentation: Set up a test plan. List the rule, the SQL wrote, and the results. Also note whether the database pa or fails the test. Your queries should include the followin Two or three simple SELECTS with various WHERE crit Two or three queries using aggregate functions. At least two queries that use joins. Two or three INSERT statements. One or two UPDATES and/or a DELETE.

VINCE'S VINYL It is time to test Vince's database to see if it truly meets needs. It is time to look back at the business rules and them with some SQL. Look at the business rules you de- oped previously, and design some SQL queries to test th Documentation: Set up a test plan. List the rule, the SQL wrote, and the results. Also note whether the database pa or fails the test. Your queries should include the followin Two or three simple SELECTS with various WHERE crit Two or three queries using aggregate functions. At least two queries that use joins. Two or three INSERT statements. One or two UPDATES and/or a DELETE.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: For each order, report order number, order date, and discount percent.

A: we are asked to find ot for each other. This means we need to find use the total quoted price and…

Q: Find the title name of the latest published book, the name of its author, and the publisher's name.…

A: 5. SELECT T.title_name, A.au_fname, A.au_lname, P.pub_name FROM Titles T, Authors A, Publishers P,…

Q: I need help with the SQL query for the following question: 1. Get top 5 list of products liked in…

A: QUERY: Creating table: CREATE TABLE Reviews( ProductModelName text, ProductCategory text,…

Q: In SQL: Explicit Cursors also have Attributes. Name one of the four explicit cursor attributes and…

A: Indeed, Explicit cursors in database systems have attributes that will describe the behavior of the…

Q: Create the following table in your database with the following schema: Table: Sales | Column Name |…

A: Create a table Sales: CREATE TABLE Sales ( sale_id int, product_name varchar(255),…

Q: How would one start this? Bank SQL Using a procedure and trigger) System should be able to…

A: Answer: I have done code and also I have attached code as well as code screenshot.

Q: Write an SQL statement to list LastName and FirstName of customers who have purchase an item that…

A: we need to write Write an SQL statement to list LastName and FirstName of customers who have…

Q: Please help with the following: Using oracle sql live or sql developer what sql statements could be…

A: part 1: Here we need to find the number of patients who don't have a phone number, so for this, I…

Q: Hi really need help with this assignment Oracle 12c: SQL Chapter 8 Question 3 and 5. 3. List the…

A: The queries for the given questions are as follows.

Q: SELECT, FROM, and WHERE statements. What happens if we do not report the attributes exactly as they…

A: The SELECT and FROM clauses come first, and the WHERE clause comes next. The WHERE clause provides…

Q: Report the names of the male students who are older than all female students. 2.Report the…

A: The solution to both parts are given in the below steps with OUTPUT screenshot Happy to help you ?

Q: Create the SQL code necessary to create an entity that reflects the following table. Make the ID a…

A: In SQL, tables are defined with CREATE TABLE command. When a table is created, its fields name, data…

Q: what sql statements could be use to find the following: A simple database composed of the following…

A: 1. SELECT DRUG_CODE , ROUND(DRUG_PRICE, 1) AS PRICE_ROUNDED FROM DRUG; OUTPUT : Selects the column…

Q: Could you explain SQL in more detail?

A: Explanation:This topic covers how to increase the size of a SQL Server database using Transact-SQL…

Q: abel each question beginning 1 to match the numbers below. I Primary Keys / Foreign Keys / Default…

Q: To perform these activities, refer to the JustLee database tables. During an afternoon at work, you…

A: 1. Explanation: In the books table, there are two columns cost and retail which specify the cost…

Q: How do you optimize user-defined functions that access large data sets in SQL?

A: In SQL, user-defined functions (UDFs) can be very useful for encapsulating logic that is used over…

Q: Choosing rows from the table Recall that the WHERE clause in an SQL statement specifies conditions…

A: To modify the select query to filter the result where LastName as Kay in the Employees table using…

Q: The faculty and students (we refer to them in our system as clients) can electronically check out…

A: ANS 1. The ERD has 3 entity which are : book, client, author. -- The ERD and Relational is given…

Q: Write an SQL statement to list the LastName and FirstName of customers who have made at least one…

A: Given that, Write an SQL statement to list the LastName and FirstName of customers who have made at…

Q: Please give a detailed answer and code examples for all the questions. What are the types of SQL…

A: What is a SQL join A SQL Join is a special form of generating a meaningful data by combining…

Q: Illustrate with an example how the CASE function can be used in SQL queries.

A: In SQL queries, the CASE function is a powerful tool that allows you to perform conditional logic…

Q: Hello I need help with the question for SQL developer for my Database Management class 5. For each…

A: SQL Statement:-

Concept explainers

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.

Question

**Vince's Vinyl: Database Testing**

It is time to test Vince's database to see if it truly meets his needs. Review the business rules and test them with some SQL. Look at the business rules you developed previously, and design some SQL queries to test them.

**Documentation:**

Set up a test plan. List the rule, the SQL you wrote, and the results. Also, note whether the database passes or fails the test. Your queries should include the following:

- Two or three simple SELECTs with various WHERE criteria.
- Two or three queries using aggregate functions.
- At least two queries that use joins.
- Two or three INSERT statements.
- One or two UPDATEs and/or a DELETE.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Given

VIEW

Step 2: Test Plan for Vince's Vinyl Database

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

lease help with the below regarding VBA and Access SQL
You are querying a database that contains data about music. Each musical genre is given an ID number. You are only interested in data related to the genre with ID number 7. The genre IDs are listed in the genre_id column. You write the SQL query below. Add a WHERE clause that will return only data about the genre with Id number 7. Who's the composer?
Task 2: The Driver Relationship team wants to arrange workshops and education materials to the drivers. However, the team wants to create clusters of the drivers based on their experience in InstantStay. To collect these detail, you will need to create a SQL function called DRIVER_STATUS to determine the level of the driver as follows: MASTER: more than 4 travels PRO: more than 2 travels ROOKIE: 2 or less travels In addition, run the function to verify it works as expected and send them back the driver levels. SQL Database Test: SELECT DRIVER_ID, DRIVER_STATUS(DRIVER_ID) FROM DRIVERS Create the DRIVER_STATUS function Expected Results: DRIVER_ID DRIVER_STATUS(DRIVER_ID) 2001 MASTER 2002 ROOKIE 2003 PRO 2004 ROOKIE 2005 ROOKIE
I need help with understanding how to do the SQL code for the following question (attached is the CSV database file): These are the header titles from the picture: ProductModelName, ProductCategory, ProductPrice, RetailerName, RetailerZip, RetailerCity, RetailerState, ProductOnSale, ManufacturerName, ManufacturerRebate, UserID, UserAge, UserGender, UserOccupation, ReviewRating, ReviewDate, Review Text 1. Get the total number of products reviewed and got Rating 5 in Every City
Please help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION, is now loaded with this assignment and you are ready to start. Please explore the database and then write the appropriate SQL command. 1. List all the rows in which the prescription dates occur on or after November 14. 2. How many doctors provide prescriptions with 30 tablets in total? Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR VALUES('29827','Sanchez','Julio','J','Dermatology');INSERT INTO DOCTOR…
Please do NOT answer the question, just tell me what I would put in the SQL querey for each question based on the table in blue. It should go something like SELECT FROM WHERE for each, but I am not sure what to put for each one
please use sql to answer the following question and erd and code from the last test (tesk 2) have been provide and it connect to task 3 as well Task 3: Create(Enter) new product by using a Procedure with IN Parameters Follow these steps to create a procedure that allows a company employee to add a new product to the database. This procedure needs only IN parameters. In SQL Developer, create a procedure namedPROD_ADD_SPthat adds a row for a new product in the BB_PRODUCT table. Keep in mind that the user provides values for the product name, description, image filename (use same template for file name as ‘roasted.jpg’ or ‘double-roasted.jpg’ ) , price, and active status. Address the input values or parameters in the same order as in the preceding sentence. Call the procedure with these parameter values:('Roasted Blend', 'Well-balanced mix of roasted beans, a medium body', 'roasted.jpg',9.50,1). Check whether the update was successful by querying the BB_PRODUCT table.…
Go to https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all (Links to an external site.) to start working on your assignment. Your goal: Demonstrate each function using the database provided. Make sure you make a screenshot of the results and present the SQL statement you used to obtain the results. Create a document that contains the 10 queries and corresponding results in the following order: SELECT, WHERE, AND (OR, NOT) - use any one function you like, ORDER BY, INSERT INTO, UPDATE, DELETE, MIN and MAX - use any one function you like, BETWEEN, JOINS and UNION - use any one function you like.
SQL Question~ Write SQL expression to list flight_no and airline_code of all the bookings for customers with first name Sam and city Chicago
Please answer as many questions as you can!
What are the potential issues with over-relying on the COALESCE function in SQL?
I need help with the SQL query for the following question: 1. Get a list of 5 reviews for shoppers in Chicago Here is the information on the field names: The table name is: Reviews Review Form Fields Product/ModelName: Product/Category: Product/Price: Retailer/Name: Retailer/ZipCode: Retailer/City: Retailer/State: Product/On Sale: Manufacturer/Name: Manufacturer/Rebate: Review/UserId: Review/Rating: Review/Date: Review/Text: Example of Review Form Filled out ProductModelName: Galaxy S4 ProductCategory: Smart Phone ProductPrice: 499 RetailerName: Bestbuy RetailerZipCode: 44114 RetailerCity: Cleveland RetailerState: OH ProductOnSale: No ManufacturerName: Samsung ManufacturerRebate: No ReviewUserId: xmm473 ReviewRating: 3 ReviewDate: 6/10/2012 ReviewText: overheats after 2 hours