Question

4. Referring to the database table below, answer the following questions. a. How many records are there? b. How many fields are there? c. How many records would be listed for a query with the STATE ZIP BALANCE CUSTOMER NAME NUMBER 810 STREET CITY John T. Smith 31 Cedarcrest Boulder CO80302 Sally Jones 725 Agua Fria William Holmes 3269 Fast Lane Boulder CO80302 10.00 0 150.35 3.50 criteria State is "CO" and the 775 Sally Jones 725 Agua Fria Santa F NM 87501 Balance is less than $10? 690 Artis Smith 2332 Alameda Lakewood Co 80218 840

Answer 1

Hi

The table depicts information about a customers

An answer to a:

There are total 4 records in this table. One record means one row. Like this:

810

John T. Smith

31 Cedarcrest

Boulder

CO

80302

10.00

An answer to b:

There are total 28 fields in a table. A table shows each record has 7 fields (attributes). So there are 4 records and each record have 7 fields. Therefore, 4*7 (n(records) * fields per record) fields are there in a table.

An answer to c:

Let's write a query for it.

SQL syntax:

select * from table where state = CO and balance < 10

If we look at a table there are 3 records with state CO but only 1 records with balance < $10. Therefore, the result will be

840

Artis Smith

2332 Alameda

Lakewood

CO

80215

3.50

More Info:

Following row is a table schema, not a record

CUSTOMER NUMBER

NAME

STREET

CITY

STATE

ZIP

BALANCE

Hope you Like...