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 ...continues

Create an ER Diagram

The scenario is that the Public Affairs Office at Highline University receives requests for speakers on particular topics. To be able to respond to such request, that office wants to build a database. In particular, it wants to keep track of topics, speakers, speeches, and organizations to which someone from Highline has spoken. ...continues

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 ...continues

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 ...continues

Create an ER Diagram for the San Juan Boat Company

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 ...continues

SQL Server Express Edition

What are some of the maintenance tools available in MS SQL 2005, and how are they used?

PQ#1 Why wont this query give me any results?

Why wont this query give me any results? SELECT author_name FROM authors WHERE author_name = "*Twain, Mark*"; After all, the text string Twain, Mark does exist in the author_name table.... (try it out using the database "WEEK1_Q1_Q2_ACCESS2000.mdb" attached here.

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 ...continues

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

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*;