Explore BrainMass


SQL Queries - What is the capacity of a particular airplane type?

A small airport: We require a data base for a small airport. The data base should track airplanes, pilots, hangars, airplane types, mechanics and airplane owners. The airport maintains the usual data, on airplanes: registration number, on airplane types: model, capacity and weight , on hangars: hanger number, location

Use of Enterprise wide database applications

Analyze the use of databases in your organization. Include what database applications are used (Microsoft Access, DB2, Oracle, etc.). Conclude by proposing improvements. For large organizations, restrict the scope to the department in which you work. If you are not employed, consider the use of databases and the benefits the

Entity Relationship Diagrams: Distribution Companies

Develop an entity relationship diagram (ERD) for your project database based on the initial data requirements. The company that we are working on distributes many products, like secure bolts and screws, to many different construction companies. In order for the company to be successful it is important for them to keep a rel

MS Excel Advance Filtering Criteria

I am having a problem with criteria range. I do not know how to set two different criterias in one column. I need to ADVANCE FILTER all of the Clerks (1 and 2) and the Sect. 1 workers who make more than $5.50/hr. I do not understand how to set the title criteria for more than one title. It HAS to be advanced filtered, not auto-f

DVD Club: Database Design Methodology

1. Ray wants to start a DVD rental program at his stores that he plans to call Henry's DVD Club. He refers to each of his customers as "members." Each member in the club is assigned a number. He also stores the members' names and addresses. In addition, he stores the number of rentals the member has made and the date the member

Database Design - one-to-one relationships - design methodology

Describe the different ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, buildings, and phone numbers) and faculty (numbers and names). No office house more than one faculty member; no faculty member is assigned more than one office. Illustrate the ways of implement

Relationships for any referential integrity violations.

Please answer the attached questions. Referential Integrity Check Question 1 - Given the following data types of some table fields and the simple schema of the relational database they are a part of, inspect its relationships for any referential integrity violations. If any exist, list what they are: Note: You can assum

Database Concepts

Can you discuss why these four concepts are important for you intellectually and/or professionally. UML and Data Modeling Generalization UML important for designing embedded systems How UML is used.

Distribution, Mean, Probability

Using our data set from Unit 1, compose an email to the head of the American Intellectual Union which discusses the following: Begin your email to AIU by first providing an overview of the database, i.e. a story. Be sure to include information about how you would use the concept of probabilities to apply to profiles for

FDD Diagram

Draw the FDD from the FD below FD 1) Student must be signed up for at least one Course i) Registration Code ->Course Name 2) Given student may have taken a given exam on a certain date, receiving a grade for it: i) StudentRegistrationNumber + Course code + Date ->Mark 3) A Course will be taught be only one Lecturer


Create an ER diagram based on the attachment that shows all of the tables, attributes, and relationships.

Access Database Problem

Create a database for a human resources group. List a few different tables and colums to store the HR information. State assumptions in creating the DB and underlying database objects. Use Access to create DB and tables.

Scope of Data Administration, Data Model Normalization, and Data Dictionary.

Please see attached file for full problem description. I need help answering the following database questions: 1. I'm to provide a concise, but complete, written description of what functions are included within the scope of data administration, and make a case why data administration is unique from traditional informati


Using the attached database WK5_DB_ACCESS2000.mdb write SQL queries to answer the following questions. 7. Show the employee (by name) that is shortest. 8. Determine the average number of years that the average employee has been working. Hint: here's how to get started: SELECT (Now()-[HIRE_DATE])/365 AS

Data Warehousing

The purpose of this 3 page paper is to discuss , views regarding data warehousing and data mining or knowledge discovery in databases. Discuss the role of the database administration and the issues of cost/benefit for these types of endeavors in organizations. A data warehouse is a repository storing integrated inf


How many types of DBMS in computer industry since IBM started its first commercial computer equipment?

Author and tittles

Using the week 2 lecture/homework database, show the author and titles of books that have never sold. Here is the SQL for my question, but what are the author and titles of the books that did not sell? select books.title ,books.author_name from books where books.isbn not in ( select isbn from order_lines where shipped='Y'

Databases - Index Tables

If you were to index the tables 1000_ROWS and 2000_ROWS and then run query1, would the table 20CHAR_TABLE be created faster than if the tables were not indexed (try it out)? Why?

Query Results - RIGHT Outer Join

Using the week 2 lecture database, if you wanted to see all the isbns from the books table and any matching isbns from the order_lines table, you'd want to do an outer join as such (because not every book stocked has been ordered): SELECT books.isbn, order_lines.isbn FROM books LEFT JOIN order_lines ON books.isbn = order_li

Rows from a Query

You can create your own Cartesian product - run this code in the database attached to Lecture Two: SELECT books.author_name, authors.author_name FROM books, authors; How many rows do you get as a result?

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;