Share
Explore BrainMass

Databases

Query Results

How come I get so many Smiths in this query (using the Week 2 lecture database)? There's only 26 orders and 4 customers named Smith. Yet I get 104 rows as a result? SELECT orders.order_numb, customers.customer_last_name FROM orders, customers WHERE customers.customer_last_name like "smith";

Query Results

Why wont this query give any results (using the week 2 lecture database)? SELECT orders.order_numb, customers.customer_last_name FROM customers INNER JOIN orders ON customers.customer_numb = customers.customer_last_name;

Access 2000 Database

Use the attached WEEK2_ACCESS2000.mdb database I just need the SQL code, which can be cut and pasted into a word document. 1. Perform an inner join between the BOOKS table and the ORDER_LINES table. Show the titles from the BOOK table and quantity column from the ORDER_LINES table -------------------------------------

Information Systems for Decision Making

A twenty year old company, SewWorld, comprised of six locations in three states, sells sewing machines, sewing related software, and accessories. Each store sells between 3-5 different brands of sewing machines. Currently the stores run independently with separate inventory databases, budgets, and expenses. Because the stores ru

Query Return Results

I attached a database. In it is a table named Table1 with these values: COLUMN 1 COLUMN 2 E 5 F 6 G 7 H 8 I 9 J 10 K 11 L 12 A

How would I have to modify this query to get it to run correctly?

Let's say my author name column in the table "authors" (in the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here) was named: author name (not author_name, as it is currently named) This is OK to do (to use "whitespace" in a column or table name), but how would I have to modify this query to get it to

The answer to Query

Using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here Why wont this query run? SELECT authors.author_name FROM authors WHERE authors.author_name Like *twain*;

Why wont this query run?

OK, why wont this query run (using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here)? SELECT author_name FROM author WHERE author_name like "Twain, Mark";

Query in Access 2000

You can use the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached to Lecture 1 if you want to play around with this query before answering: OK, I'm writing a query in Access 2000: SELECT author_name FROM authors WHERE author_name like "%Twain, Mark%"; ... but it wont give me result

Construct an IDEF1X Diagram to track statistics

The Metropolitan Housing Agency (MHA) is a non-profit organization that advocates the development and improvement of low-income housing. The MHA operates in a metropolitan area of approximately 2.2 million people in a midwestern city. The MHA maintains data about the location, availability, and condition of low-income housing in

Create an IDEF1X digram

The Jefferson Dance Club teaches social dancing and offers both private and group lessons. Jefferson charges $45 per hour per student (or couple) for a private lesson and charges $6 per hour per student for a group lesson. Private lessons are offered six days per week (from noon until 10 p.m.). Group lessons are offered in the e

ER Diagram Developed

Develop an ER diagram for the following: A database used in an order-entry system is to contain information about customers, items, and orders. The following information is to be included: ? For each customer: Customer number (unique) "Ship-to" addresses (several per customer) Balance Credit Limit Discount ? For ea

Database Normalization

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to reduce this table to third normal form. Prepare a Word document showing the original and final tables. Include a

CSCI Excel 2003

CSCI Excel 2003. See attached file for full problem description.

Relations in the 3NF.

For each of the following relations, indicate the normal form of the relation. Put each relation in the 3NF. a. COURSE (course_id, lab_id, equipment_type), primary key = {course_id, lab_id}. b. COURSE (course_id, lab_id, equipment_type, software_type), primary key = {course_id, Lab_id}, eq

Which type of database (distributed, centralized or decentralized) to use?

Consider the following normalized relations for a database in a large retail store chain: EMPLOYEE(Emp_Id, Work_Location, Name, Address) STORE(Store_ID, Region, Manager_ID, Square_Feet) DEPARTMENT(Dep_ID, Manager_ID, Sales, Goal) SCHEDULE(Dep_ID, Emp_ID, Date) Assume that a data communications network links a computer

Oracle 10g

Figures 1-24 and 1-25 (attached) display the data and relationships within the Clearwater Traders database. Reference these figures when completing the following cases. 1. Based on the description of the Clearwater Traders database, determine the appropriate constraints for each table. Make certain you consider the following

Oracle 10g

Which of the data dictionary views are most useful, and why?

Database Concept

What can be identified in the users' work environment, something that the users want to track.

Database Concept

What are the three types of binary HAS-A relationships in the E-R model?

Three levels of concurrency

Could someone please explain to me what are the three levels of concurrency in programs? What level of concurrency is best supported by SIMD computers? What level of concurrency is best supported by MIMD computers?

Database Concept

Provide a real world example that demonstrates one of the normal forms.

Implement key types and maintain referential integrity of the database.

Using the final table list you created for Learning Event 3, select the Primary Keys for each table in your list. Then, select one of your tables and complete field specifications for each field. Use the field specifications sheet located on page 286 (Figure 9-1) of your textbook. Note: Your field specifications sheet does n

Database in Access and a Visual Studio Application

Create a database with a table called "tblMenu." This table has the following columns: ID -This is the Primary Key. It has a type of Autonumber. Font:- Text (Set this to unique value.) Add at least five fonts ("Arial", etc) to the "Font" column. Create a Visual Studio.NET 2005 web application with two aspx forms. Add a