Question

Create a database with information about products in a catalog. As you plan, keep in mind that later you will want to sort this data by product number and retrieve a list of products with a quantity of less than one hundred. You will also need to look up the price and product description.
Create the database and populate the database with ten records about any type of products. Save your database.

Answer 1

Auto  Quan- Price  Description

Parts   tity

01            2   100.00   Intake Manifold

02           45   12.00    Windshield Wiper

03           21    9.00     Tire Pressure Gauge

04           14    5.00     Oil Filter

05           98   1.00     Screws

06           89   1.20     Nuts

07            6   21.00     Air Filter

08           102   4.50    Plastic Fastner

09             21    31.25   Brake Pad

10               9    91.00    Rotor

Answer 2

pro.no. Qty  Price  Description

1            23   1.00     Apple

2           90   1.00     Banana

3           16    1.00     Orange

4           124  1.00     Pear

5           98   1.00     Blue Berry

6           25   1.00     Raspberry

7           76   1.00     Black Berry

8           00   1.00     Pineapple

9           231  1.00     Green Grape

10          689 1.00     Red Grape

11           2      1.00     Watermellon