Animal id uniquely identifies each individual animal at the zoo. If you know an animal id, you know the animal type, feeding time, location, animal food, cleaning time, medicines, and vet.

computer science

Description

Assignment 6: Normalization ([email protected] = 24 pts)

 

Place the following tables in BCNF / 4NF

1)

c3 → c4
c2 → c7
 c1 → → c5
(c1,c2) → c6

 

c1

c2

c3

c4

c5

c6

c7

a

1

cc

red

5

up

8

b

2

cc

red

13

left

7

b

3

cc

red

14

right

6

c

4

dd

blue

3

down

5

c

5

dd

blue

6

east

4

c

5

dd

blue

7

east

4

d

6

ee

green

9

west

3

d

7

ee

green

8

west

2

e

8

ee

green

1

south

1

 


2) Zoo database

Animal id uniquely identifies each individual animal at the zoo.
If you know an animal id, you know the animal type, feeding time, location, animal food, cleaning time, medicines, and vet.
Cleaning time and feeding times are done by location.
Each type of animal has its own assigned vet and assigned food.
Medicines, of course, are individualized by specific animal.

animalId

AnimalType

FeedingTime

Location

AnimalFood

CleaningTime

Medicines

Vet

26964

African Lion

9am

1

beef

2pm

Vitamin

Dr. Linch

26964

African Lion

9am

1

beef

2pm

Penicillin

Dr. Linch

26964

African Lion

9am

1

beef

2pm

Ketoconazole

Dr. Linch

72235

African Lion

9am

1

beef

2pm

Vitamin

Dr. Linch

54575

Bengal Tiger

9am

1

beef

2pm

Metronidazole

Dr. Linch

99382

Penguin

11am

2

fish

9am

Ketoconazole

Dr. Sidney

70387

Rhinoceros

1pm

4

grass

3pm

Ivermectin

Dr. Snow

70387

Rhinoceros

1pm

4

grass

3pm

Ketoconazole

Dr. Snow

38481

Rhinoceros

1pm

4

grass

3pm

Prednisone

Dr. Snow

47374

Hippopotamus

1pm

4

grass

3pm

Tramadol

Dr. Snow

47374

Hippopotamus

1pm

4

grass

3pm

Doxycycline

Dr. Snow

29189

Ostrich

1pm

4

insects

3pm

null

Dr. Sidney

74445

Spider Monkey

3pm

3

fruit

1pm

Instruction Files

Related Questions in computer science category

Get Higher Grades Now
254 Tutors Online
Description

Cookies Use

We use cookies to ensure a smooth browsing experience. By continuing we assume you accept the use of cookies.

Okay