Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Solved Assignments
Asked Questions
Answered Questions
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).
Design and develop a database of your choice that includes Four to five regular strong entities. Draw an EER diagram, as per the above specifications.
Define the four techniques. Describe their roles in maintaining a right database. Write the SQL code to implement them.
Design and refine a database to record and manage information relating to a company's premises, as well as human resources and ongoing projects.
Propose measures (including specific Azure security tools/features) to protect data against security threats and handle data ethically.
List all products (productcode, product description) supplied by Gomez Bros. Find the total value of the product inventory.
Write SELECT statement that lists all of the orders that included the Fender Precision. SELECT the order_id, product_id, product_name, and order_date.
Explain how you would apply vertical partitioning to this table and write a SQL query to reconstruct the complete table after partitioning.
Create a blank SQL database in Azure. Write SQL queries to create the database tables and relationships.
Identify the main entities involved. Identify the main relationship involved. Identify the relationship and explain how you obtained it.
Create an SQL query that returns the average price and variance per product. The products and prices are of your own creation.
Write SQL and choose result that corresponds to your SQL. The ranking is based on number of movies actor has participated in that answer criteria above.