IM501 Agricultural Data and Information Management

DESCRIPTION

This unit focuses on data and information management in the context of agriculture. It considers the main steps involved in addressing organisational needs using commonly employed data management techniques. The unit covers data modelling, relational databases, SQL programming, data normalisation, entity relationship diagrams, data security, and data ethics. Students will have an opportunity to explore contemporary approaches to information and knowledge management in the context agriculture.

RELEVANT COURSES

Master of Agricultural Information Management*

Master of Business Administration (Agribusiness)

*Core unit

Elective unit

CREDIT POINTS

10

DELIVERY MODE

On campus

Mixed mode

Online

Intensive

Extensive

PREREQUISITE OR CO-REQUISITE

Nil

UNIT LEARNING OUTCOMES

LO1 Explain the key concepts underlying database management systems (DBMS) and their significance in agriculture

LO2 Critically evaluate contemporary data and information management techniques in terms of their application in agriculture

LO3 Collaboratively design and implement databases to address organisational needs in an agricultural setting

LO4 Apply database solutions and effectively communicate them to stakeholders

LO5 Critically evaluate and discuss DBMS with respect to data ethics and data security

CONTENT

• Introduction to database systems

• Data models

• Relational database models

• Relational algebra and its role in DBMS

• Entity-relationship diagrams

• Advanced data modelling

• Normalisation of database tables

• Introduction to SQL

• Database design

• Business intelligence and data warehouses

• Data ethics and security

• Advanced topics: Big data, smart farming 5.0

ASSESSMENT METHODS

1. Quizzes - 20%

2. Report - 40%

3. Group project and oral presentation - 50% (20% is allocated for individual reflection + presentation)

PRESCRIBED READINGS

Nil

Check with the lecturer each semester before purchasing any textbooks.