Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Write an efficient relational algebra expression for the following SQL query:
Microsoft changed the management interface of SQL 2008 to the same user interface (UI) used for Visual Studio 2008. Why do you think Microsoft made that change, and why is it important to database dev
Input names of students from the user, terminated by ZZZ, and create a data file GRADES with records of the form:student (string), test1 (integer), test2 (integer), test3 (integer) In this f
Henry Magruder made a mistake-he left a CD at the coffee station. Later, when Iris Majwubu was topping off her mug with fresh tea, hoping to wrap up her work on the current SQL code module before it w
Only return those rows with a balance due greater than 1000. Sort the result set by InvoiceTotal,with the largest invoice first.
Create a report using the wizard or based on an SQL query that shows courses instructors are approved to teach.
Select customer_id, order_id, order_date, and ship_date from the demo.sales_order table. For each record also provide the days from order to ship and use an alias name for the column heading.
Write an SQL query that retrieves data from the COURSE table for courses that cost 1195, and whose descriptions do not start with 'Intro', sorted by their prerequisites in descending order.
You will be developing SQL PL procedures that demonstrate basic flow of control statements, such as conditionals (decisions) and looping (repetition).
List name(s) of employee(s) who works(work) on exactly all projects located in 'Houston.
Write a join query that for every order placed on September 5, 1998, (use '05-SEP-1998') will list the order number and order date along with the customer number, last name, and first name of the cust
What are triggers used for, and why are they important in database systems? Provide an example of a situation where a trigger would be appropriate. What would the implementation of this trigger look l
Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance), write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.
Modify Oracle table data using the correct SQL statements. You must create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-
Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column. Group the result set by VendorName. Return only 10 rows, corr
If an employee works on every project except the one(s) controlled by the department that has no location in Houston, then list the employees social security number and name.
Will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables. The lab will utilize a set of tables found in the script file (LeeBooks.sql)
Review EMPLOYEE table structure file within the course document (CSCI 507 - EMPLOYEE table structure - Final Exam -Section C Question.doc), design a relational schema to manage employee payroll (just
Advanced SQL. Define the various types of outer joins and define when each would be used. Provide scenarios when each would be used.
Write an UPDATE statement that modifies the VendorCopy table. Change the default account number to 403 for each vendor that has a default account number 400
Write an INSERT statement that adds a row to the VendorCopy table for each non-California vendor in the Vendors Table. (This will result in duplicate vendors in the VendoCopy Table).
Write an SQL CREATE TABLE statement to create the PET table without a referential integrity constraint on OwnerID in PET. Justify your choices of column properties. Why not make every column NOT NULL?
Select a specific author and list all books for that author. Include the title, year and ISBN number. Order the information alphabetically by title.
Given the table CUSTOMER (custID, Name, PhonNumber,AccountBalance), write the standard SQL query to retrives the Name and Phone Number of customers with a balance greater than 50