Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Provide a list of supply orders, including contact information for the vendor, the name of the clerk who submitted the order, the order date, the receipt date.
Write PL/SQL script that uses a trigger that converts to upper case of the customer name, city, street and Province for Customer table during INSERT OR UPDATE.
Differentiate between an OLTP and a data warehouse. How would you distinguish between two-tier and three-tier client/server architectures?
What are the aggregates that the analyst would start with, and what are the relevant drill-down operations that the analyst would need to execute?
Create the database in the actual database application as indicated by your professor (i.e Microsoft Access, MySQL or Oracle, etc.).
Create a new table to store car maintenance types. Create a new table to store maintenance operations. Create an INDEX to search for driver information.
List every step in the order of application and describe the process of accomplishing the refactoring requests by including the following.
Which suppliers provide more products than the average for all suppliers {who provide products; do not include suppliers who do not provide any products}?
list of all customers who have made a purchase to a total value of more than 100 pounds at same occasion, giving for each name, address, average purchase value.
Create a procedure to insert a row into the product table with appropriate values. Use an anonymous to call the procedure and output the result.
List the average age of the students for each course. As well as the number of students enrolled in the course.
Write an SQL statement to create a view named ProjectHoursToDateView that shows the values of PROJECT.ProjectID, PROJECT.ProjectName, PROJECT.Max-Hours as Proje
Write and execute a query that returns the maximum or highest list price value in the Production.Product table (Adventureworks2019)
Create a procedure that accepts a customer id and retrieves the id of the products and quantities that the customer ordered.
List of employee last names and the department name they work for using ON clause. Listing of countries and the names of the departments located there.
Write server-side code that returns the information from the flights table needed to analyze the relationship between flight delays and day of week.
How to connect my MySQL workbench with another? As in, how can another person using his MySQL workbench on another server can access my MySQL database.
Write an SQL statement that uses the vPersonNames view. Write an SQL statement that uses spEmployeeByID using 12 as the ID (again, no need for the output).
Show the DDL to create the objects, be sure to have referential integrity and surrogate keys. Show the DML to load the data. Show the queries of some results.
What fields, primary key and datatypes including field lengths would you need? What reason did you select the field name and datatype for the primary key?
Which tables will be updated by this transaction? Using SQL, write each database request that is needed to complete the transactions.
How many pairs of red sandals are for sale? What is the average price of shoes for each brand? List all details of shoes that cost more than $200.
List the homeowner's name (first and last) for the policy from 2022 that has the smallest premium. List the total number of policies per year.
What are brand names of ALL teal cars? Names of dealers who sell some purple car OR are in Dallas? Names of dealers who sell some green car AND are in Atlanta?
Write a query to show all the names of regions, names of countries and number of locations in them (including regions/countries with 0 locations).