Database Help Now Please (1 Viewer)

[annieclassof06]

Im taking IPT by Distance Education and external circumstances mean I am one week behind already. I have to have this in today can someone help me pleaseeeeeeeeeeeeeeeeeeeeeeeeeee????????????????????


What is a query?
What is the usual form of a simple query?
List three methods of entering a simple query.
What is a query language?
What are the advantages of using a query language?
Describe two common wildcard characters.
Explain the difference between the AND operator and the OR operator.
What is the main problem encountered when sorting data?
Using the table answer the following questions

The following table represents the data, stored in a database used by U-Prang-Em panel beaters, of the cars which are currently being repaired.

NAME ADDRESS TOWN REGO TYPE DATE QUOTE
Smith,W 15 West St Ryde BAH111 Dat. 180b 15/07/94 $864
Adams, R 1/12 Hill Ave Penrith GPA298 Hol. VB 18/07/94 $1340
Guild, W 23 Karman St Manly HQT102 Mit. Sigma 20/07/94 $895
Bush, R 9 Hall Pde Mosman KLR587 Dat. Skyline 20/07/94 $1545
Rowe, D 45 Phillip St Cronulla JFD904 Maz. 626 23/07/94 $1234
Mon, S 8 John St Cabramatta GHT351 For. Falcon 24/07/94 $986
Wise, I 24 Hunter Rd Hillston LKM102 Hol. Camira 25/07/94 $325
Tait, L 186 Main St Lakeside HQX967 For. TX5 30/07/94 $742


8. How many records would be found as the result of the following searches;

a. NAME CONTAINS “u”
b. TOWN BEGINS WITH “M”
c. TYPE ENDS WITH “e”
d. DATE = 20/*
e. REGO ENDS “7” OR QUOTE < $400
f. ADDRESS CONTAINS “a” AND TYPE BEGINS WITH “Dat”

9. Write a statement in query language to locate records to suit the following conditions;

a. the car with the rego of KLR587.
b. all cars with a quote of more than $1000 and the car was a Holden.
c. all clients who live in Manly or Mosman.
d. all clients who do not live in a street and who drive a holden.

10. Who is the client of the second record when the file is sorted by

a. name.
b. cost.
c. address.
d. type.

Using the table answer the following questions

A chain of music stores, Boptil Udrop, maintains a database of the albums it stocks.

An extract is shown below:

Title Artist Rec. Price Category Medium Stock
Rise Daryl Braithwaite $26 Popular CD 12
Fantasy Bach $16 Classical LP 30
Tusk Fleetwood Mac $20 Rock LP 5
Bat Out Of Hell Meatloaf $13 Rock Cass 1
Travelling Wilburys Travelling Wilburys $27 Rock CD 17
Premier Collection Andrew Lloyd Webber $18 Popular CD 20
Serious Hits- Live Phil Collins $23 Rock CD 14
Fantasy Bach $18 Classical CD 50
Jupiter Mozart $24 Classical CD 2
Cats London Cast $22 Popular CD 10
Rumours Fleetwood Mac $11 Rock Cas 8
No! No! No! Indecent Obsession $15 Rock Cas 12
Trash the Planet SPY V SPY $21 Rock CD 10
All or Nothing Milli Vanilli $17 Rock LP 5
PUMP Aerosmith $12 Rock LP 11

11. How many records would be found as the result of the following searches;

a. TITLE ENDS WITH “y”
b. ARTIST = M*
c. STOCK > 20
d. REC. PRICE < $20 AND REC. PRICE > $13
e. ARTIST > L OR MEDIUM = LP.
f. TITLE < M AND CATEGORY = Rock

12. Write a statement in query language to locate records to suit the following conditions;

a. the category equals rock.
b. all artists who have stock in excess of 15 CDs.
c. all artists whose music is classical and recordings cost more than $20.
d. all titles which are cassettes or are rock music.

13. Who is the client of the second record when the file is sorted by

a. artist.
b. medium.
c. category and then artist.
d. category, title and then medium.


ANY HELP I WOULD BE SO OBLIGED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[melsc]

What is a query language? - SQL (structured query language)

Describe two common wildcard characters. ? (one character) * (Multiple characters)

Explain the difference between the AND operator and the OR operator. AND - both criteria must be met...OR one of the has to be met

When u are asked to write a query this is what you have to do
SELECT (Name of fields you want displayed)
FROM (which tables)
WHERE (The crtiera 4 the query)
ORDER BY (Asc desc order etc)

 

[goan_crazy]

heres answers 4 u

is this an asessment?
thats so easy
u can get all the answers from a textbook
but anyway
ill help

What is a query?
A QUERY is a search of a database for records that meet a certain condition.


the usual form of a simple query is
SQL-structured query language

List three methods of entering a simple query.
address
name
subarb

What is a query language?
the language in which querys are based


Describe two common wildcard characters.
asterisk (*) for any number of characters, and a question mark (?) for one character.

Explain the difference between the AND operator and the OR operator.
both criteria must be met...OR one of the has to be met

What is the main problem encountered when sorting data?
it could be sorted in the wrong way causing errors

Using the table answer the following questions
The following table represents the data, stored in a database used by U-Prang-Em panel beaters, of the cars which are currently being repaired.

NAME ADDRESS TOWN REGO TYPE DATE QUOTE
Smith,W 15 West St Ryde BAH111 Dat. 180b 15/07/94 $864
Adams, R 1/12 Hill Ave Penrith GPA298 Hol. VB 18/07/94 $1340
Guild, W 23 Karman St Manly HQT102 Mit. Sigma 20/07/94 $895
Bush, R 9 Hall Pde Mosman KLR587 Dat. Skyline 20/07/94 $1545
Rowe, D 45 Phillip St Cronulla JFD904 Maz. 626 23/07/94 $1234
Mon, S 8 John St Cabramatta GHT351 For. Falcon 24/07/94 $986
Wise, I 24 Hunter Rd Hillston LKM102 Hol. Camira 25/07/94 $325
Tait, L 186 Main St Lakeside HQX967 For. TX5 30/07/94 $742


8. How many records would be found as the result of the following searches;

a. NAME CONTAINS “u”
b. TOWN BEGINS WITH “M”
c. TYPE ENDS WITH “e”
d. DATE = 20/*
e. REGO ENDS “7” OR QUOTE < $400
f. ADDRESS CONTAINS “a” AND TYPE BEGINS WITH “Dat”

9. Write a statement in query language to locate records to suit the following conditions;

a. the car with the rego of KLR587.
b. all cars with a quote of more than $1000 and the car was a Holden.
c. all clients who live in Manly or Mosman.
d. all clients who do not live in a street and who drive a holden.

10. Who is the client of the second record when the file is sorted by

a. name.
b. cost.
c. address.
d. type.

Using the table answer the following questions

A chain of music stores, Boptil Udrop, maintains a database of the albums it stocks.

An extract is shown below:

Title Artist Rec. Price Category Medium Stock
Rise Daryl Braithwaite $26 Popular CD 12
Fantasy Bach $16 Classical LP 30
Tusk Fleetwood Mac $20 Rock LP 5
Bat Out Of Hell Meatloaf $13 Rock Cass 1
Travelling Wilburys Travelling Wilburys $27 Rock CD 17
Premier Collection Andrew Lloyd Webber $18 Popular CD 20
Serious Hits- Live Phil Collins $23 Rock CD 14
Fantasy Bach $18 Classical CD 50
Jupiter Mozart $24 Classical CD 2
Cats London Cast $22 Popular CD 10
Rumours Fleetwood Mac $11 Rock Cas 8
No! No! No! Indecent Obsession $15 Rock Cas 12
Trash the Planet SPY V SPY $21 Rock CD 10
All or Nothing Milli Vanilli $17 Rock LP 5
PUMP Aerosmith $12 Rock LP 11

11. How many records would be found as the result of the following searches;

a. TITLE ENDS WITH “y”
b. ARTIST = M*
c. STOCK > 20
d. REC. PRICE < $20 AND REC. PRICE > $13
e. ARTIST > L OR MEDIUM = LP.
f. TITLE < M AND CATEGORY = Rock

12. Write a statement in query language to locate records to suit the following conditions;

a. the category equals rock.
b. all artists who have stock in excess of 15 CDs.
c. all artists whose music is classical and recordings cost more than $20.
d. all titles which are cassettes or are rock music.

13. Who is the client of the second record when the file is sorted by

a. artist.
b. medium.
c. category and then artist.
d. category, title and then medium.
all that stuff needs to be done urself
thats practical work u need to do in a table using a program like access or something
good luck!
hope this helped u