Need Help With The SQL Server Database

profileHeidi21
NormalizationTableAnimalHospital1.xlsx
Home>Computer Science homework help>Need Help With The SQL Server Database

Sheet1

1NF
invoice date saluation first_name last_name street city state zip pet_type pet_name procedure total tax bill
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Iguana ROVER RABIES VACCINATION 78.00 0.08 84.24
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Cat MORRIS RABIES VACCINATION (Cat) 78.00 0.08 84.24
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Cat MORRIS FLEA BATH 78.00 0.08 84.24
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Iguana ROVER NAILS TRIMMED 78.00 0.08 84.24
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351 dog BELLA RABIES VACCINATION 84.00 0.08 90.72
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351 dog MOOSE RABIES VACCINATION 84.00 0.08 90.72
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351 dog APOLLO FLEA BATH 84.00 0.08 90.72
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351 dog ROVER NAILS TRIMMED 84.00 0.08 90.72
1987 1-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan NY 56214 cat Luke Hair Ball 5400.00 0.08 5832.00
1987 1-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan NY 56214 dog Hans Hip Dysplasia Surgery 5400.00 0.08 5832.00
1988 11-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan NY 56214 dog Hans Surgery follow up 0 0.08 0
2NF
invoice date saluation first_name last_name street city state zip pet_type pet_name
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Iguana ROVER
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Cat MORRIS
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Cat MORRIS
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Iguana ROVER
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351 dog BELLA
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351 dog MOOSE
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351 dog APOLLO
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351 dog ROVER
1987 1-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan NY 56214 cat Luke
1987 1-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan NY 56214 dog Hans
1988 11-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan NY 56214 dog Hans
Procedure_id procedure cost
101 RABIES VACCINATION 30.00
102 RABIES VACCINATION(Cat) 24.00
103 FLEA BATH 21.00
104 NAILS TRIMMED 3.00
105 Hair Ball 300.00
106 Hip Dysplasia Surgery 2400.00
107 Surgery follow up 0
invoice total tax bill
987 78.00 0.08 84.24
987 78.00 0.08 84.24
987 78.00 0.08 84.24
987 78.00 0.08 84.24
988 84.00 0.08 90.72
988 84.00 0.08 90.72
988 84.00 0.08 90.72
988 84.00 0.08 90.72
1987 5400.00 0.08 5832.00
1987 5400.00 0.08 5832.00
1988 0 0.08 0
3NF
cust_ID saluation first_name last_name street city state zip
201 Mr. Richard Cook 123 This Street My City CT 12345
202 Mr. Charles Gabor 1234 Main Street Anytown NJ 02351
203 Ms. Leia Organa 666 Star Wars Avenue Alderaan NY 56214
Procedure_id procedure cost
101 RABIES VACCINATION 30.00
102 RABIES VACCINATION(Cat) 24.00
103 FLEA BATH 21.00
104 NAILS TRIMMED 3.00
105 Hair Ball 300.00
106 Hip Dysplasia Surgery 2400.00
107 Surgery follow up 0
Pet_type_id pet_type
1 Iguana
2 Cat
3 dog
pet_Id pet_name cust_id Pet_Type_id
301 ROVER 201 1
302 MORRIS 201 2
305 BELLA 202 3
306 MOOSE 202 3
307 APOLLO 202 3
308 ROVER 202 3
309 Luke 203 2
310 Hans 203 3
invoice_num pet_id Procedure_id
987 301 101
987 302 102
987 302 103
987 301 104
988 305 101
988 306 101
988 307 103
988 308 104
1987 309 105
1987 310 106
1988 310 107
invoice_num date
987 19-Jun-19
988 13-Jan-20
1987 1-Feb-20
1988 11-Feb-20
tax_id tax_amount
1001 0.08

Sheet2

1NF
invoice date saluation first_name last_name street city state zip pet_type pet_name procedure
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Iguana ROVER RABIES VACCINATION
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Cat MORRIS RABIES VACCINATION (Cat)
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Cat MORRIS FLEA BATH
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Iguana ROVER NAILS TRIMMED
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7 dog BELLA RABIES VACCINATION
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7 dog MOOSE RABIES VACCINATION
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7 dog APOLLO FLEA BATH
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7 dog ROVER NAILS TRIMMED
1987 1-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan MW 2351 cat Luke Hair Ball
1987 1-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan MW 2351 dog Hans Hip Dysplasia Surgery
1988 11-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan MW 2351 dog Hans Surgery follow up
2NF
invoice date saluation first_name last_name street city state zip pet_type pet_name
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Iguana ROVER
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Cat MORRIS
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Cat MORRIS
987 19-Jun-19 Mr. Richard Cook 123 This Street My City CT 12345 Iguana ROVER
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7 dog BELLA
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7 dog MOOSE
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7 dog APOLLO
988 13-Jan-20 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7 dog ROVER
1987 1-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan MW 2351 cat Luke
1987 1-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan MW 2351 dog Hans
1988 11-Feb-20 Ms. Leia Organa 666 Star Wars Avenue Alderaan MW 2351 dog Hans
Procedure_id procedure cost
101 RABIES VACCINATION 30.00
102 RABIES VACCINATION(Cat) 24.00
103 FLEA BATH 21.00
104 NAILS TRIMMED 3.00
105 Hair Ball 300.00
106 Hip Dysplasia Surgery 2400.00
107 Surgery follow up 0
invoice total tax bill
987 78.00 0.08 84.24
987 78.00 0.08 84.24
987 78.00 0.08 84.24
987 78.00 0.08 84.24
988 84.00 0.08 90.72
988 84.00 0.08 90.72
988 84.00 0.08 90.72
988 84.00 0.08 90.72
1987 5400.00 0.08 5832.00
1987 5400.00 0.08 5832.00
1988 0 0.08 0
3NF
cust_ID saluation first_name last_name street city state zip
201 Mr. Richard Cook 123 This Street My City CT 12345
202 Mr. Charles Gabor 1234 Main Street Anytown Ontario Z5Z 6G7
203 Ms. Leia Organa 666 Star Wars Avenue Alderaan MW 02351
Procedure_id procedure cost
101 RABIES VACCINATION 30.00
102 RABIES VACCINATION(Cat) 24.00
103 FLEA BATH 21.00
104 NAILS TRIMMED 3.00
105 Hair Ball 300.00
106 Hip Dysplasia Surgery 2400.00
107 Surgery follow up 0
Pet_type_id pet_type
1 Iguana
2 Cat
3 dog
pet_Id pet_name cust_id Pet_Type_id
301 ROVER 201 1
302 MORRIS 201 2
305 BELLA 202 3
306 MOOSE 202 3
307 APOLLO 202 3
308 ROVER 202 3
309 Luke 203 2
310 Hans 203 3
invoice_num pet_id Procedure_id
987 301 101
987 302 102
987 302 103
987 301 104
988 305 101
988 306 101
988 307 103
988 308 104
1987 309 105
1987 310 106
1988 310 107
invoice_num date
987 19-Jun-19
988 13-Jan-20
1987 1-Feb-20
1988 11-Feb-20
tax_id tax_amount
1001 0.08