Analyzing of Egg database 2 조 : 김종민 ( ) 강윤 ( ) 김유정 ( )
Contents Object of Presentation Sample Database Analyzing Database Conclusion Relation of Data Table Entity – Relation Diagram
Sample Database
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
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
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
Graph by Place
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
Graph by Foods
Conclusion 1.Jeju 와 Sweden 의 1,2 등급의 계란수는 같 고, 3 등급의 계란이 Jeju 가 높음으로, Jeju 의 생산성이 높다 2.1,2,3 등급의 계란의 평균적인 생산력은 Red seed> Ground nut> Floxine 순이다. 고온다습 기후에서 Red seed 를 먹이는 경우가 가장 높은 생산력을 지닌다.
Relation of Data Table
Entity – Relation Diagram