Analyzing of Egg database 2 조 : 김종민 (05111201) 강윤 ( ) 김유정 (08100016)

Presentation on theme: "Analyzing of Egg database 2 조 : 김종민 (05111201) 강윤 ( ) 김유정 (08100016)"— Presentation transcript:

1 Analyzing of Egg database 2 조 : 김종민 (05111201) 강윤 ( ) 김유정 (08100016)

2 Contents Object of Presentation Sample Database Analyzing Database Conclusion Relation of Data Table Entity – Relation Diagram

3 Sample Database

4 Object of Presentation How to increase the productivity. –what effect temperature and humidity have on egg production. Sweden Jeju –what effect different kinds of food have on the hens. Groundnut Floxine Red Seed

5 Analyzing Database 1 Regroup for knowing effect of place or food Jeju Groundnut Jeju Groundnut Jeju Floxine Jeju Floxine Jeju Red Seed Jeju Red Seed Sweden Groundnut Sweden Groundnut Sweden Floxine Sweden Floxine Sweden Red Seed Sweden Red Seed

6 Analyzing Database 2 Know effects of ONLY Environment Jeju Groundnut Jeju Groundnut Jeju Floxine Jeju Floxine Jeju Red Seed Jeju Red Seed Sweden Groundnut Sweden Groundnut Sweden Floxine Sweden Floxine Sweden Red Seed Sweden Red Seed A B

7 Graph by Place

8 Analyzing Database 3 Know effects of ONLY foods Jeju Groundnut Jeju Groundnut Jeju Floxine Jeju Floxine Jeju Red Seed Jeju Red Seed Sweden Groundnut Sweden Groundnut Sweden Floxine Sweden Floxine Sweden Red Seed Sweden Red Seed ABC

9 Graph by Foods

10 Conclusion 1.Jeju 와 Sweden 의 1,2 등급의 계란수는 같 고, 3 등급의 계란이 Jeju 가 높음으로, Jeju 의 생산성이 높다 2.1,2,3 등급의 계란의 평균적인 생산력은 Red seed> Ground nut> Floxine 순이다. 고온다습 기후에서 Red seed 를 먹이는 경우가 가장 높은 생산력을 지닌다.

11 Relation of Data Table

12 Entity – Relation Diagram

13