Share
Explore BrainMass

SQL

Create the following SQL queries.

Create the following queries on the attached ITD640_B database and save them all in a file called ITD640_P5.SQL . Remember to define what database to use with a USE statement. - Using a join, get the full details of all the employees who are working on the Harvest Ball promotion. - Get the promotion names (duplicates elimi

If Else then, parameter queries, object priveleges: Perform the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command).

L_lunches table LUNCH_ID LUNCH_DATE EMPLOYEE_ID DATE_ENTERED 1 16-NOV-05 201 13-OCT-05 2 16-NOV-05 207 13-OCT-05 3 16-NOV-05 203 13-OCT-05 4 16-NOV-05 204 13-OCT-05 6 16-NOV-05 202 13-OCT-05 7 16-NOV-05 210 13-OCT-05 8 25-NOV-05 201 14-OCT-05 9 25-NOV-05 208 14-OCT-05 12 25-NOV-05 204 14-OCT-05 13 25-NOV-05

Tables, Forms, and Reports

Word document, SQL Statement (zipped) Start Access, and then open the FirmPays database located in the LE4 folder extracted from the zip file in IP3. Open the query named "June 2". View the query in SQL, and answer the following questions: 1. Which tables are used in the query? 2. Which fields are displayed in the query

Writing query for SQL using NESTED-SELECT statement

I have a list of incomes (in column labeled Income) in a table labeled Jobs. I need to find the second highest number in the income column. I know that the MAX function finds the highest, but how would I find the second highest income using a NESTED-SELECT statement???

Improvements to SQL queries for Student data

I have tried there two queries, but I am told that I am not doing something right. Here are the criteria I used to write the queries and my current answers. 1. Write a SELECT statement that lists the StudentID, FirstName, LastName, and GPA of freshman (FR) whose GPA is 3.5 or higher. Use only the Student table. My query: SEL

Sql Queries for Employees, Salary, Job tables

Need help quickly with some SQL queries. I am using SQL 2005 express. Please help. Using the database, tables, and data, write SQL statements to: ? Calculate the average salary for employees for each state. ? Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees. ? Calculat

SQL Database Needed

please use SQL server 2008 to create the database, below is the URL or website for the Kudler Fine Foods. https://ecampus.phoenix.edu/secure/aapd/cist/vop/Business/Kudler/Internet/KudlerPort.htm Individual Assignment: Table Creation ? Create an SQL server database for the Kudler Fine Foods Virtual Organization. ? Cr

SQL

Start Access, and then open the FirmPays database located in the LE4 folder extracted from the zip file in IP3. Open the query named "June 2". View the query in SQL, and answer the following questions: Which tables are used in the query? Which fields are displayed in the query results What type of join is used between th

SQL Table Client Creation

CREATE TABLE CLIENT ( CLIENT_NO CHAR(8) PRIMARY KEY, CLIENT_COMPANY VARCHAR(35) NOT NULL, CLIENT_NAME VARCHAR(35) NOT NULL, CLIENT_EMAIL VARCHAR(35), CLIENT_PROGRAM CHAR(3) NOT NULL, CLIENT_SCORE NUMBER NOT NULL); CREATE TABLE COURSE ( COURSE_CODE CHAR(8)PRIMARY KEY, COURSE_NAME VARCHAR(35) NOT NULL,

Five SQL queries explained

4.1) Consider the insurance database below, where the primary keys are underlines. Construct the following SQL queries for this relational database. INSURANCE DATABASE Person ( ss#, name, address) Car (license, year, model) Accident (data, driver, damage - amount) Owns (ss#, license) Log (license, date, driver) I

MUST USE SQL CREATE TWO TABLES.

I tried posting this question once already and I paid pretty much for nothing! This has to be done in MS SQL. Using SQL coding, create two tables using the following fields: (Note: Supply the SQL Server data types when creating the tables. Apply the primary keys to the tables.)Create database and two tables (Employee & Job

Movie Rental Database - Part-2 This is the second part of the Movie Rental Database set of questions answered using Oracle. The set of queries primarily deals with triggers and exception handling.

Submit all of your codes, Oracle responses, and listing of your testing session in a single text or Microsoft Word document. please see attached file Now that business is becoming strong and the movie stock is growing for More Movie Rentals, the manager wants to do more inventory evaluations. One item of interest concerns

SQL Database

Ramesh, I'm having trouble with my coding. Could you please look over my SQL Statement. Also I'm unsure how to use the GROUP Coding. Instructions are down below and PLEASE USE SQL SERVER 2008 Use the database and tables from last week's assignment to write SQL queries using Between, Like, and Union: - Write a SQL query tha

Writing SQL Queries Using a Database and Tables

Write SQL queries (SELECT statements) using BETWEEN, LIKE, UNION, and GROUP. Using the database and tables (see attachment) write SQL INSERT statements to insert records into the employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check your results by selec

SQL Accounting Database

PLEASE USE SQL 2008 ATTACHED FOR ALL SQL DATABASE CREATION Design an SQL database that contains the fields found in the company's Chart of Accounts. Add a balance field to the database. Create a query that will display all of the fields of the database and run a report totaling the balance field using test data added to the d

Creating a databse using Microsoft SQL Server

Using Microsoft SQL Server CREATE DATABASE, CREATE TABLE, and SQL INSERT statements. Use the CREATE DATABASE statement to create a SQL Server database for Kudler Fine Foods. In the Kudler Fine Foods Database, use the CREATE TABLE statement to create the following two tables with the fields identified below: Note: Spe

Write SQL queries using BETWEEN, LIKE and UNION

Using the database and tables from the attached file, write SQL queries using BETWEEN, LIKE and UNION: Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use salary to restrict the data.) Write a SQL query that joins two tables in the example database and uses B

SQL Code - Working with Additional Database Objects

See attached. Please show both the SQL code and results. Working with Additional Database Objects Deliverables: • SQL code and the results (7 queries and 1 explanation in it). 1. Create a simple view named CUST_VIEW using the book_customer table that will display the customer number, first and last name, and t

SQL Command Code

CREATE TABLE contacts (Con_id NUMBER(4), Company_name VARCHAR2(30) not null, E_mail VARCHAR2(30), Last_date DATE DEFAULT SYSDATE, Con_cnt NUMBER(3) CHECK (Con_cnt > 0), PRIMARY KEY (Con_id)); 1. Write a code to add two rows of data to the table that was created using the command above. Ensure the default option on the

SQL Statement for Grades

See the attached file. 8. Consider the following tables: Customers CustomerID LastName FirstName State 1 Cohen Mike CO 2 Highley Michelle MI 3 Cohen Margot MI Orders OrderID CustomerID Ordered_Item D

Database Request for Product ABC

Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. And each time the product ABC is created, the parts inventory, using PART_QOH in a table named PART, must be reduc

SQL statements and query

(3.7) Write a SQL query that uses UNION of the two tables. Be creative. Using the updated database, write the following queries using the SQL GROUP BY statement and appropriate aggregate statements (when needed): (3.8) Write a SQL query that displays the average salary / hourly wage grouped by job_title. (3.9) Write a

A detailed example of a SQL select statement using GROUP BY

The schema of the DB is as follows: Department(DeptNum, Descrip, Instname, DeptName, State, Postcode) Academic(AcNum, *DeptNum, FamName, GiveName, Initials, Title) Paper(PaNum, Title) Author(*PaNum, *AcNum) Field(FieldNum, ID, Title) Interest(*FieldNum, *AcNum, Descrip) Question 6: Which fields have interests share

Database - Privacy - Internet

I need assistance in preparing an essay of 600 words with referencing please. Problem details: There is much concern about a person's privacy as the Internet captures increasingly more information about users. The CEO of Sun recently was quoted as saying, "Privacy? You have lost it now get over it!" (or there's a saying "On t

SQL Statements for Library Database

E. Given the database schema on the relations as follows: LIBRARY(LNO, LNAME, LOCATION) AUTHOR(ANO, ANAME) BOOK(BNO, TITLE, ANO) COPY(CNO, LNO, BNO) PATRON(PNO, PNAME, ADDRESS) LOAN(LOANNO, PNO, CNO) LNO - Library Number LNAME - Library Name ANO - Author Number BNO - Book Number CNO - Copy Number PNO - Patron Num