I guess that the asterisk indicates a primary key... So what's the other field?
Is there any need for you to prefix fields in the orders table with the word "order"?
Order date and order time appear to be separated... What datatype were you going to use for each field? Generally a single datetime field should sort you out. Do you need to store the grand total, considering it is just a calculation based on the other information available to you? Some may consider this redundant.
Same goes for number of items.
What's an order type? Are you using the same type table for both item and order types?
what you may consider changing is the orderitme tabels
they are a couple of things you can looks at.. does the homework assignment allow the same product to be ordered more than once... if not make porderid & productID the primary key
alternativley you coudl ook at having orderitemno as an intger or byte filed ranging from 1......whatever.. and make orderIF & itemNo the PK.
I wouldn't normally expect order time and order date separate items.. but I suppose it depends on the db this is being implemented in, most dbs these days seem to support a composite date and time datatype
I don't think you need numberofitems, as it can be derived from the orderitems table