ITE 397 Activity

 1. Create a database and name it db_your_family_name (proceed to #2 if it already exist).
2. Create the table tblproducts
    prod_id        int        auto increment primary key
    prod_name    varchar        150
    prod_line    varchar        100    not null
    prod_vendor    varchar        100
    prod_price    decimal        10,2
    prod_qty    int
3. Insert the ff. records

 

4. Change the prive of 1968 Ford Mustang to 102.5
5. Change the quantity on hand of 2003 Harley-Davidson Eagle Drag Bike to 5000 and its price to 95.00
6. Change the vendor of 1969 Harley Davidson Ultimate Chopper to Kulas Motorcycle Philippines
7. Remove 1958 Setra Bus from the table
8. Add the record 
    name - 2025 Habal-Habal X, 
    line - Motorcycles, 
    vendor - Pitok Race Bikes, 
    price - 90.00, 
    qty - 1000

9. Display all records arranged according to Product Name.