s one of them.....i started it but dont think im doing it correctly

 

11/14/2014Prepared By Valerie Farmer, Assistant Professor CISPage 1 of 2Using the following E-R Diagram - Create an Access DatabaseBusiness Rules:1. TheDelivery Ratesare based upon theRateCategory.2. Thenumberofpackagesdeliveredperdaybyeachmessengermust be calculated.3. Thenumberofpackagesdelivered foreachcustomerperdaymust be calculated.4. Foreachpackagetheweight,locationandRateID(category used to determine delivery rate) must be tracked.5. A Messengermustattend a 2 weekunpaidtraining sessionBEFOREbeing assigned a delivery.During this period of time, hours do NOT need to be tracked.6. Thenumber of hoursamessengerworksdailymust be calculated.7. Apackagemust haveonlyoneDeliveryassociatedwith it.E-R Diagram Speedy Messenger Service Database – Final ProjecttblDeliveriesDeliveryIDCOUNTERDeliveryDateDATETIMEWeightNUMERIC(10,2)DeliveryAddress1TEXT(30)DeliveryAddress2 (O)TEXT(30)DeliveryCityTEXT(20)DeliveryStateTEXT(2)DeliveryZipTEXT(5)RateID (FK)LONGMsgrID (FK)LONGCustID (FK)LONGtblCustomersCustIDCOUNTERCustFirstNameTEXT(20)CustLastNameTEXT(20)CustAddress1TEXT(30)CustAddress2 (O)TEXT(30)CustCityTEXT(20)CustStateTEXT(2)CustZipTEXT(5)CustPhoneTEXT(10)CustEmail (O)TEXT(20)tblRatesRateIDCOUNTERRateCategoryTEXT(30)PriceCURRENCYtblMessengersMsgrIDCOUNTERMsgrFirstNameTEXT(20)MsgrLastNameTEXT(20)MsgrAddress1TEXT(30)MsgrAddress2 (O)TEXT(30)MsgrCityTEXT(20)MsgrStateTEXT(2)MsgrZipTEXT(5)MsgrPhoneTEXT(10)MsgrEmail (O)TEXT(20)PayRateCURRENCYtblHoursWorkedWorkedDateDATETIMEMsgrID (FK)LONGHoursNUMERIC(4,2)workData Type ConversionsVisioAccessCounterAutoNumber (Long)TextTextCurrencyCurrencyNumericNumberLong NumberDateTimeDateTimeNUMERIC (4,2)means aNumberwith alength of 4with2decimal places.In Access useNumberData Type.No need to enter a length just thedecimal places.are assignedare assignedrequests

Attachments:

• 1495600356-FinalProject.pdf