Explore BrainMass
Share

SQL

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

Sql Server Database

SQL Server database for Kudler Fine Foods/Service Request SR-kf-009 Create the following two tables using the following fields: Note: Supply the appropriate SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate t

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

Writing SQL statements

I'm not grasping the full concept of these problems, I've completed most successfully. I've tried to get them, but I am have a hard time reworking these. (This is the table referenced for the following questions) INVENTORY (SKU, Description, QuantityOnHand, QuantityOnOrder, Warehouse) 1. Write a SQL statement to displ

Modifiy SQL statement for aircraft fuel

See attachment Modify the query in Problem 1 above to include the computed (derived) attribute "fuel per hour." (Hint: It is possible to use SQL to produce computed "attributes" that are not stored in any table. For example, the following SQL query is perfectly acceptable: SELECT CHAR_DISTANCE, CHAR_FUEL_GALLONS/CHAR_DISTAN

Writing Code in SQL

Download, unzip, and attach the sample database ITD640_A from the link below. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time. zip file i

Database Systems using SQL

Think about the various components of a school environment and then respond to the following questions in a post to the discussion below: - What computed fields could be created from data in a student database? - What aggregate functions would be useful and why?

Database Concept for a Single User

Help with this question? Microsoft Access is a Single User database system that is often viewed as having limited application. Discuss how Access can be integrated into a larger database system or used as an adjunct to a large application system.

Master-Detail Relationship

Explain the concept of a Master-Detail relationship. Specifically describe how a master-detail relationship is configured within a database. What are some examples that would use a master-detail relationship? Can you think of any master-detail relationships that would go deeper than one level?

SQL tools vs. Access tools & Data Quality

1. One of the purposes of database tools is to ensure the quality of the Data. What are some trends in Data Quality management that vendors need to pay attention to? 2. Compare the tools that are available for products like SQL Server with what is available in a single user Database such as Access.

create views using SQL scripts

Using the ITD410_P1 database attached, I need to write scripts in a file called ITD410_P3.SQL to create the following views. I must have a uses clause at the top of the script file to use the ITD410_P1 database. Also include code that checks if the view already exists. If it does, I am supposed to drop it and recreate it. The

Outer Join

I have attached a Word document defining the dbo.Orders and dbo.Employees tables (Northwind database). The needed query is: List the EmployeeID, LastName, and FirstName of all employees who did not take an order between March 1 and March 7, 1997. USe an outer join. You must include the condition on OrderDate in the ON clause o

A SQL Query to List Customers

A SQL query to list customers who did not have an order between 03/01/97 and 03/07/97 I have attached the two tables to be used. The query needs to output only those employees (employeeID, FirstName, LastName) if there is not an order date bewtween 03/01/1997 and 03/07/97.I need a sub-query used and no joins. I need the emplo

Need a SQL UPDATE statement

Looking for a SQL UPDATE statement written for the following issue: A table was created, Whse.IStock. This table contains a column, SKU which holds stock numbers. The SKU column was created as a data type char(20) and right-justified the stock numbers with leading blanks. Currently, to search stock numbers, a LIKE search

Create a query that puts 2 tables together

Create a query with the kudler_team_c database I attached. This query should pull at least two tables together. So it needs to have the following: USE SELECT FROM GROUP BY You can decide what tables to put together and what fields to pull out.

DDL and DML

Hi, See attached file for assignment problems. Thank you DDL and DML 1. For emp table, set the constraint that Hiredate is later than Jan. 1, 1980. 2. Modify Dept table so that dname column can contain up to 20 characters. 3. Define ProdId+StartDate as the primary key for Price table. 4. Insert this row of

Query Statement for to query DATA

Use only one SQL statement for each task. Submit the SQL statement(s) that you would use to accomplish each task. 1.Find all employees whose name starts with either an S, s, A, a, T, or t. List all information about each employee in the output. (Though our table does not contain lower cases, your SQL should work even if ther

Create SQL statements using current database- check and correct please

If you could check statements in the sql and make correction I would be happy. I added the statements that you helped me with at the end. These statements are located in the middle. (3.1) Using the database and tables from Week Two, write SQL statements and enter the records into the employee table for the workers identifie

Create SQL Statements using Current SQL Database

Using the database and tables from Week Three, write queries to the specifications listed below. Note: Verify that the updates in the next three statements (4.1 - 4.3) are completed correctly by displaying the relevant columns before and after the updates run. (4.1) Choose an EEO-1 Classification: Increase all employees' salar

Relational Database Management Systems

Using the Internet, research two of four commercial relational database management systems listed below: Oracle 9i DB2 Universal Database (IBM) SQL Server 2000 (Microsoft) Sybase Adaptive Server IQ Multiplex. In 2 to 3 paragraphs, compare and contrast the features of both and choose which one you would use for your

JDBC and ODBC

The purpose of this 3 page paper is to discuss JDBC with interfacing to ODBC. JDBC is a Java API (Application Programming Interface) that documents a standard framework for dealing with tabular and, generally, relational data A database is essentially a smart container for tables. A table is a container compris