Draw ERD using crowfoot notation, create a table including an identity, creat a foreign key constraint

 

i Treatment invoice Bay Animal Clinic P.O.Box 649 Montrose, AL 36559 For: Suzanne Pardue 34 Hannon Ave Mobile, Al 36604 Services rendered by Babette Dixon, DVM Type Description Procedure Annual Exam Injection Feline Leukemia Booster Fvrcp Booster Injection Urinalysis with Sedimenta Lab work 7 Qty 1. 1 1 Reminders for: Echo (Weight 12.2 lbs - age 4 years) 09-15-10 Rabies Booster 09-15-10 Feline Leukemia Booster Echo Price 39.90 22.05 20.85 13.20 Date: 09-15-09 Account: 8010 Invoice: 175528 Discount Price 31.04 17.15 16.22 10.27 8.86 4.90 4.63 2.93 Total 74.68