Share
Explore BrainMass

SQL

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

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

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

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

Choosing/Designing a Database

You have been tasked to design a database system to store all of the relevant information for a student alumni association for a large university. Which database product would you choose and what design considerations would you examine to arrive at that decision?

SQL/MS Access Problem

Using Microsoft Sql*server 2000/2005 or MS Access, create and link the tables for the inventory model from the attached inventory systems file.

Systems Analyst

1. As a System Analyst, after you gathered systems requirement, how are you going to analyze these data? Are you starting with business process first or start with data directly? Explain each approach and why or why not? 2. Once the data analysis is complete, how are you going to start with design portion? What kind of tools

Differences between ROLAP and MOLAP

Please help with the following problem. What is the difference between ROLAP and MOLAP? This web site should help: http://www.dmreview.com/article_sub.cfm?articleId=1330

Questions 1-7 answers provided need SQL's for each.

With the file attached please answer in SQL form the following. Thanks... 1. Which employees (by name) have degrees? (the "answer" is Smith, Johnson and Williams) SELECT at least the employee first and last names - SELECT other columns you think would be meaningful. HINT: do a JOIN between the employees and degrees t

Write sql for access database

Using the week 2 attachment database attached here with this posting, I need to come up with the proper SQL to answer these six questions which are within the word document: I suppose each of the visuals is the actual answer and I need the SQL for each?

SQL Database Columns

If you have TABLE A with these columns (I put the data type in parenthesis, they are not actually part of the table name): LAST_NAME(TEXT), FIRST_NAME(TEXT), MIDDLE_NAME(TEXT), DATE_OF_BIRTH(DATE), and TABLE B with these columns: LAST_NAME(TEXT), FIRST_NAME(TEXT), MIDDLE_NAME(TEXT), DATE_O

Database Coding

1. Using the order_lines table from the database from lecture 2, write the SQL that will give the Min and Max values of the column "cost_each" 2. Using the week 2 homework database, show each customer number and count the instances of each customer_numb in the table orders. Hint: follow this pattern (where the words TAB

SQL Server Database for Kudler Fine Foods/Service

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 the field as the Primary Key. In the Job Title table, you will need to

Running a Query

Why wont this query run and how would you write it correctly? Major hint: try and run the query (use the database attached to Week 2's lecture) ... you'll get an error message that should explain: SELECT isbn FROM books INNER JOIN order_lines ON books.isbn = order_lines.isbn;

SQL Database Design

Use SQL Management Studio to create a database called ITD410_P1.MDF. Be sure to store the database in a location you will remember. Add the tables and data shown below to the database. Use appropriate field types and lengths. Be sure to detach your database and create a zip file called ITD410_P1.ZIP with your database and the

ACCESS 2000

(Note: cut and paste the SQL answers for questions 1 and 2 into a word document. 1. Write the SELECT FROM WHERE code that will select the row from the authors table in the attached WEEK1_Q1_Q2_ACCESS2000 database that has "twain, mark" NOTE: You can use: SELECT *

Queries in Access

I notice when writing queries that Access will add in a semicolon at the end of my query. Its just one of those Access things right? We don't have to remember to write the semicolon, as Access adds it in for us correct. The only time this is significant to know is in a situation like this - in a UNION query We may end up cu

SQL 2005 stored procedures, sub query and join general question.

1. Stored procedures in SQL 2005 can be written in a variety of languages. Why is this important in the development of database systems? Provide an example of a stored procedure that a database designer might write to demonstrate why this capability is important. Please include references. 2. Which is better to use, a sub

Oracle Deletion of Fields

Question: Does this statement still hold true? Does Oracle not allow the deletion of fields and if so, how do you handle this? If so why? Seems like not having this ability would make modifications of a database more challenging. Also... the same question, "For example, some systems, including Oracle, do not allow you to red