Question #1 is too complicated for this automatic grading system, so we are omit

Question

Question #1 is too complicated for this automatic grading system, so we are omitting it and re-scaling question #2 to be 20 points. the following sample database table Part Number 1024 1132 6743 Identifier Price Number In Stock Multifrequency Field Coils Polymorphic Transhrer Arrays Starboard Power Couplings Noncortirmus Injector Poirts Plasma Contamment Shiells Phased Array Sensor Modules $31,000.78 Artimatter Buffer Interfaces Hamburger withh a side ot Fies $14,774.00 $9,703.33 $479.12 $47,067.99 15 5146 1001 1108 2094 $76,144.00 $2.37 38 each numeric answer without commas or extra blanks. How many fields are currently in the table Sloppy (use both interpretations of "field")? recise How many records are currently in the table? art Number Identifier C. What are the data types of all fields? ?? umber in Stock

Explanation / Answer

Lets begin with answer:

A. The sloppy definition is that a field is a column of table. > 4 columns => 4

=> The precise definition is that a field is a component of a record. > 4 columns * 8 rows => 32.

B. Records mean the number of rows in table => 8 rows => 8.

C. Part Number => Number

Identifier => Text

Price => Currency

Number of Stocks => Number

D. Ans = least value => 1001.

E. Least price is $2.73 => Ans. => 2994

F. Last in descending order => least number in stock = 0 => Ans => 5146

G. Only those records will be left which have Number in Stock > 3 => 1132, 6743, 9999, 2994. => Number = 4.

This completes the answer for any queries post in commnets.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---