VINCE'S VINYLIt is time to test Vince's database to see if it truly meets hisneeds. It is time to look back at the business rules and testthem with some SQL. Look at the business rules you devel-oped previously, and design some SQL queries to test them.Documentation: Set up a test plan. List the rule, the SQL youwrote, and the results. Also note whether the database passesor 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

Similar questions

Do not plagarise the answer Guarenteed Upvoted for correct and detailed answer. Thanks
# For this assignment, use the university database use university; # This assignment involves more than one table. # It would be very helpful to review the content in each table so you know how they are related. select * from instructor; select * from teaches; select * from course; select * from department; select * from student; select * from takes; # Write SQL statement to complete the following tasks # 1. Find the lowest salary of any instructor # 2. Find the names of all instructors earning the lowest salary (there may be more than one with the same salary). # 3. Find all instructors whose salary information is not null # 4. List the instructor names and the course title that an instructor has taught. # Remove duplicate. Sort by instructor name alphabetically. # Hint: you need the data from three tables: instructor, teaches, course. Expect 14 rows. # 5. Using the IN keyword, list all course titles that are taught by Mozart and Srinivasan. # Hint: you need the data from three…
Thank you for helping! Write the SQL code to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table. The result is shown as below. Write the SQL code to display the information of employees who are working as either programmer or system analyst. Write the SQL code to produce job_descriptions(job_title) of employees who are working at project ‘Evergreen’.
I want to write the SQL to create the tables for the ERD attached, but I also want to add this to the tables: rental date, due date, and return date so that I can support overdue queries. I also want it so each table has primary keys and foreign keys. I want it so the tables have at least 4 rows of data. How can I do this? Thank you for your help as I learn more about SQL and table creation.
How would you alter the structure of a table with SQL? What kinds of changes are conceivable in general? Which commands are used to make these modifications?
Code SQL (Screenshot code and output) Create three tables for a company that sells computer software, the tables are employees, department, and product. You can specify the attributes for each table based on what you see fit. Then, Link the three tables together. Note : Work on Oracle SQL live, take a screenshots of you work.
What are some data types and operators available in SQL? Give examples. What are subqueries? When are they used? Give an example. What are joins? How do joins compare with subqueries? Give an example.
Describe the role of CASE and DECODE functions in SQL? Also explain what structures we use in PL/SQL programming to have more complicated and sophisticated versions of CASE/DECODE?
Describe how you would fix the SQL error depicted below. A good idea would be to copy the code exactly and paste it into SQL developer and see if you can make the changes necessary to get it to run correctly. 2 Start Page O MidTerm Exam.sql A Mid Term Exam a - E E / ö A | 2.43400002 seconds Worksheet Query Builder :-Comment: Build the Puddles Table DROP TABLE PUDDLES CASCADE CONSTRAINTS; a CREATE TABLE Puddles Puddle ID NUMBER(4), Puddle Name VARCHAR2 (15), Puddle Desc VARCHAR2 ( 75), Script Output x Task completed in 2.434 seconds Table PUDDLES dropped. Error starting at line :5 in command - CREATE TABLE Puddles Puddle_ID NUMBER (4), Puddle Name VARCHAR2 (15), Puddle Desc VARCHAR2 (75), Error report - SQL Error: 0RA-00904: : invalid identifier 00904. 00000 - "$s: invalid identifier" +Cause: *Action:
LAB 2: SUBTASK 1: Fill in the following tables: as preliminary lab work (some are filled for your guidance) SUBTASK 2: Build the tables in Oracle Live SQL with your account according to the tables above. SUBTASK 3: Build the relations among the tables. Addresses Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry address_id V NO 1234567890 Customers Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry customer id V number NO Good_groups Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry good_group_id V number varchar2(10) NO