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
Why do databases need redesigning?
Describe the default rules for enforcing referential integrity constraints. Explain how referential integrity actions can be used to override the default referential integrity constraints. Please explain thoroughly.
What is the role of a database in business intelligence systems? What are some of the key requirements for databases to provide meaningful data patterns?
Describe the default rules for enforcing referential integrity constraints. Explain how referential integrity actions can be used to override the default referential integrity constraints.
Develop a hierarchy chart that shows the modules, the pseudo code, and a flowchart to illustrate your solution to this problem You are a manager for a small service organization. You need to develop a application/database that includes the name, address, city, state, zip code, phone number, and blood type for your staff. What
Explain the concepts of "transaction"(unit of works)? Can you give me an example of a transaction in DBMS?
How many types of DBMS in computer industry since IBM started its first commercial computer equipment?
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'
Using the database attached to Lecture 2, let's say you are interested (let's say as the business owner) to see how old the books are that people order (going by their publication date). First, you'd need to create a query that would convert the order year into a decade and count the orders: SELECT books.title, CInt
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?
What is a view? What does it have to do with querying? Why would you use a view?
Read these two web articles and answer these questions: http://www.opensource.org/docs/definition.php http://searchenterpriselinux.techtarget.com/originalContent/0,289142,sid39_gci1069685,00.html * What is an open source database? * Why would a company want to use an open sourced database?
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
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?
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";
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;
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 -------------------------------------
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
Why is Structured Query Language (SQL) such an important tool? Explain Structured Query Language's role in the database world. http://databases.about.com/od/sql/a/sqlbasics.htm.
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
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
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*;
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";
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
San Juan Sailboat Charters is an agent that leases sailboats to customers for a fee. San Juan does not own any sailboats; it leases boats on behalf of the owners who wish to earn income when they are not using their boats. San Juan charges a fee for its service. San Juan specializes in boats that can be used for multi-day or wee
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
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
For this assignment, you will create a Visual Basic.NET application to extend IP2 into a more complete music collection manager. In this exercise, you will create a solution that works with two tables having a Master/Detail relationship. The first table contains music category records, and the second table contains album detail records for each category.
For this project you will use the following database schema, which has two tables. Table 1 -- Schema for the tblCategories table Column Name Data Type ldCategoryID Integer fldCategoryDesc String Table 2 -- Schema for table named tblAlbums Column Name Data Type fldAlbumID Integer fldCategoryI
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