Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
SQL statement to display the First and Last name of students who live in the Zip code 88888 and have the major of Biology.
Supply SQL server data types when creating tables. In the Employee table, create an Employee ID field that generates a unique number for each employee and designate the field as the Primary Key. In th
Create a report using the wizard or based on an SQL query that that shows Courses that instructors are approved to teach. Show Course Number, First Name, and Last Name of Instructor.
Choose an index for each of the following SELECT statements. Specify whether your choice is clustered or unclustered and whether it is a hash index or a B+ tree.
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