Management Information Systems - Microsoft Access Assignment

ismilazimdegil
AYK28.accdb
Home>Information Systems homework help>Management Information Systems - Microsoft Access Assignment
Customer NumberID Customer Name Phone Number Street City State Zip
1 Amanda Smith 8604526355 7697 Temple Road Greenville NC 27834
2 Anita Zimmerman 4559325562 77 Purple Finch Dr. Amarillo TX 79106
3 Barbara Williamson 4599586245 80 Pulaski Lane Eastlake OH 44095
4 Betsy Walsh 7859352610 13 E. Liberty Dr. Brandon FL 33510
5 John Williamson 8356496622 29 Bank Ave. Pleasanton CA 94566
6 Mike Philips 1214598425 73 Broad Lane Hempstead NY 11550
7 Peter Prentice 9955586213 8988 South Buttonwood Street Oakland Gardens NY 11364
8 Gokcenur Aslan 7856569833 1200 Buttrey Drive Havre MT 59501
Field1
Pet Number Pet Name Type of Animal Birth date CUSTOMER NUMBER
1 Indigo Cat 5/7/2017 1
2 Midnight Cat 7/9/2015 2
3 Hoppi Dog 4/5/2018 3
4 Ren Dog 12/4/2014 4
5 Stimpy Cat 9/25/2016 4
6 Barney Dog 5/5/2015 5
7 Micro Cat 11/8/2018 6
8 Buck Dog 9/7/2014 7
9 Cookie Dog 8/15/2018 8
Description Price CODE
Eye/Ear Examination 20.00 303
Lab Work - Blood 50.00 1000
General Exam 50.00 300
Tetrinious Shot 10.00 100
Flea Spray 25.00 2003
Other Not Listed 10.00 9999
VISIT NUMBER PET NUMBER DAY
1 1 08/15/2018
2 2 09/20/2018
3 3 12/1/2018
4 4 12/1/2018
5 5 12/1/2018
6 5 12/5/2018
7 6 12/7/2018
8 7 10/19/2018
9 8 4/5/2018
10 8 5/9/2018
11 9 10/4/2018
VISIT NUMBER LINE NUMBER TREATMENT CODE
1 1 303
2 2 1000
3 3 300
4 4 300
5 5 300
6 6 100
7 7 2003
8 8 300
9 9 303
10 10 1000
11 11 9999
Date Pet Number VISIT NUMBER
08/15/2018 1 1
09/20/2018 2 2
12/1/2018 3 3
11/13/2018 4 4
11/13/2018 4 4
11/13/2018 4 4
12/5/2018 5 5
12/7/2018 6 6
10/19/2018 7 7
4/5/2018 8 8
4/5/2018 8 8
9/7/2018 9 9
Line NumberID
Description Price
Eye/Ear Examination $20.00
Lab Work - Blood $50.00
General Exam $50.00
General Exam $50.00
General Exam $50.00
Tetrinious Shot $10.00
Flea Spray $25.00
General Exam $50.00
Eye/Ear Examination $20.00
Lab Work - Blood $50.00
Treatment Code
VISIT NUMBER PET NUMBER DAY
1 1
2 2
3 3
4 4
5 4
6 4
7 5
8 6
9 7
CODE
1000
300
TREATMENT CODE
303
1000
300
300
100
300
303
300
SELECT Customers.[Customer Name], Pet.[Pet Name], Pet.[Type of Animal], Treatment.Description, Treatment.Price FROM ((Customers INNER JOIN Pet ON Customers.[Customer NumberID] = Pet.[CUSTOMER NUMBER]) INNER JOIN Visit ON Pet.[Pet Number] = Visit.[Pet Number]) INNER JOIN (Treatment INNER JOIN [Visit Detail] ON Treatment.CODE = [Visit Detail].[Treatment Code]) ON Visit.[VISIT NUMBER] = [Visit Detail].[VISIT NUMBER];
SELECT Customers.[Customer Name], Pet.[Pet Name], Pet.[Type of Animal], Treatment.Description, Treatment.Price FROM ((Customers INNER JOIN Pet ON Customers.[Customer NumberID] = Pet.[CUSTOMER NUMBER]) INNER JOIN Visit ON Pet.[Pet Number] = Visit.[PET NUMBER]) INNER JOIN (Treatment INNER JOIN [Visit Detail] ON Treatment.CODE = [Visit Detail].[TREATMENT CODE]) ON Visit.[VISIT NUMBER] = [Visit Detail].[VISIT NUMBER];