| Course Description |
|
| Course Name |
: |
Databases and Computerized Herd Management |
|
| Course Code |
: |
ZO-588 |
|
| Course Type |
: |
Optional |
|
| Level of Course |
: |
Second Cycle |
|
| Year of Study |
: |
1 |
|
| Course Semester |
: |
Spring (16 Weeks) |
|
| ECTS |
: |
6 |
|
| Name of Lecturer(s) |
: |
Prof.Dr. ZEYNEL CEBECİ
|
|
| Learning Outcomes of the Course |
: |
At the end of this course, the students learn the fundamentals of databases
Create and manage relational databases
Develop software applications for herd management
Analyse data in databases
Generate decision support and herd management reports based on the data acquired from the databases
|
|
| Mode of Delivery |
: |
Face-to-Face |
|
| Prerequisites and Co-Prerequisites |
: |
None |
|
| Recommended Optional Programme Components |
: |
None |
|
| Aim(s) of Course |
: |
This course aims to introduce databases for herd management; to create databases and develop database applications for a specific animal production activity. |
|
| Course Contents |
: |
The content of this course includes databases in herd managament, creating databases, reporting and querying databases. |
|
| Language of Instruction |
: |
Turkish |
|
| Work Place |
: |
Classroom |
|
|
Course Outline /Schedule (Weekly) Planned Learning Activities |
| Week | Subject | Student's Preliminary Work | Learning Activities and Teaching Methods |
|
1 |
Databases: Definitions and basic concepts |
None |
None |
|
2 |
Types of databases and database management software |
None |
None |
|
3 |
Introduction to database programming and administration |
Installing and configuring MS Access |
Practice |
|
4 |
Programming for queries and data processing |
Determining the necessary information and reports for a small scale dairy farm. |
Reporting |
|
5 |
Databases in animal husbandry |
Creating a database and building tables |
Practice |
|
6 |
Introduction to databases in animal breeding and existing applications |
None |
None |
|
7 |
Midterm exam |
None |
None |
|
8 |
Creating artificial populations by simulation |
Finding and downloading a simulation programme on the internet |
Internet/Computer study |
|
9 |
Creating a database, defining tables and relations |
None |
None |
|
10 |
Entering and editing data |
None |
None |
|
11 |
Introduction to query language (SQL) |
Project work 1 |
Practice |
|
12 |
Reporting |
Project work 2 |
Practice |
|
13 |
Evaluation of herd and analysis of breeding data |
Project work 3 |
Practice |
|
14 |
Pedigrees and genetic analysis |
None |
None |
|
15 |
Preparation for the Final exam |
None |
None |
|
16/17 |
Final exam |
None |
None |
|
|
| Contribution of the Course to Key Learning Outcomes |
| # | Key Learning Outcome | Contribution* |
|
1 |
At the end of this programme, the students improve and deepen their knowledge in the field of Animal Science by building on the knowledge and competence acquired at the undergraduate level and can employ interdisciplinary interaction in their field of study. |
3 |
|
2 |
The students interpret and generate new information and theories in specific fields related to Animal Science using the theoretical and practical knowledge at masters level. Also, they can reveal the cause-effect relationship regarding the problems in their field of study and employ scientific research methods to generate possible solutions. |
2 |
|
3 |
The students independently identify potential problems and carry out research studies aiming at solutions in the field of Animal Science. Also, they investigate and develop strategic approaches for potential problems that may arise related to the particular studies. |
3 |
|
4 |
The students access and compile information about the latest developments and fundamental sources in the particular field and reach a new synthesis by evaluating and interpreting the existing research. They can make use of this acquired knowledge to practice the profession effectively and follow the improving implementations in the field. |
4 |
|
5 |
The students use information in the field of Animal Science, through compiling, interpreting and synthesising it, in order to make social contributions. They make evaluations by creating a plan and framework and taking specific total quality criteria into consideration. They use the skills and knowledge acquired in the field of Animal Science in joint projects with other disciplines. |
5 |
|
6 |
The students discuss and pass on the acquired knowledge based on their work in the field by making written and oral presentations. They have speaking and writing competence in at least one foreign language at a level that enables them to keep up with the requirements of the age. They express their ideas clearly using the tools of information and communication technologies. |
0 |
| * Contribution levels are between 0 (not) and 5 (maximum). |
|
|