Am in a hurry, Very nice bonus if this is answered within 5 hours, at least $50!

So following are 5 SQL related questions I would like answered, quick and easy!


1. Given that a customer can place many orders, but each order can
only be placed by one customer and each order has many items. Data to
store about the customer includes customer number, name, address and
zip code. Data to store about the order are order number, order date
and customer number. Data to store about the order item should be
order number, item number and quantity of each item ordered.
Produce a Table Notation for each entity based on the above.


2. Provide an SQL statement that will display the value of the
inventory for all products with a quantity over 100, given:
Product (Product-ID, Product-DESC, Product-Cost, Quantity)


3. Compute the total inventory value by category and list it by
highest value first, given:
Customer (_CID_, Name, Address, City, State, Zip, Category)
Inventory (_ItemID_, Description, ListPrice, Cost, QuantityOnHand, Category)
Order (_OrderID_, OrderDate, CID)
OrderItem (_OrderID_, _ItenID_, Quantity, SalePrice)


4. List customer accounts who have a penicillin allergy and have the
drug penicillin prescribed, given:
Customer (_Account#_, Name, Address, City, State, Zip, Phone)
Allergies (_Allergy_, _Account#_, Level)
Prescriptions (_Prescription#_, Account#, Physician, Phy-Phone, Drug,
Size, Quantity, Date)


5. Using the data in the image (link below), write SQL statements for
the following:
i. How many animals have we ordered from suppliers in Kentucky?
ii. Which category of animals provides the most profit (ignore shipping)

(when I use the underscore "_" it means Primary Key)

Here is the image: 
http://www.gnaunited.com/modules/My_Uploads/user_folders/thanksmate/LEFT-RIGHT.jpg

Am in a hurry, Very nice bonus if this is answered within 5 hours, at least $50!