TWHI – Nonprofit Online Farming Education Institute

TWHI – An Overview

TWHI stands for Torrens We help Inc which is known to be a non-profit private institute in the domain of organization. The organization is involved in providing online education in the domain of farming in various places of the globe. The student of this organization are mainly from various areas like Australia, New Zealand and Papua New Guinea. The organization mainly focus to engage and work to with partnership with various bodies like industries and business.

It aims to provide multiple number of learning experiences and opportunities for improving learning journey of the students. It comes up with the pride of being an inclusive provider that aims to provide education to people. The people might have not gain any kind of opportunity for experiencing it. Many of the student have already paid the fees in fully or advance by Australian or New Zealand Government.

In the coming pages of the report a proper justification for the use of database, E-R diagram and IT controls has been discussed in details.

Discussion  

Justification of Database 

TWIH makes use of spreadsheet which is needed for maintaining and monitoring the employee information. The present human resource (HR) is totally involved in struggling and getting required information for the entire academic and administrative staff. Spreadsheet are known to be best tool which is needed for crunching. As the organization has many kind of data for its consumer and inventory then it can easily provide benefit for efficient management tool. A database system is mainly needed for various benefits like

Centralized System: With the passage of time, the business is growing at much faster rate and number of employees in the organization are increasing. So, it can tough for managing huge amount of data of employee and organization data. A proper database system can be helpful in managing essential data of business. Apart from this, it can maintain the safety and security of the data which is needed for overall success of the organization.

Better Management of Human Resources: Making use of HR database can be considered to be helpful in managing the staff records. A database system can easily save time and money of the organization. It will ultimately make streamline for the flow of task related to HR, automating the flow of jobs and lastly speed of data processing. It can also affect the processing of data like benefits and payroll. It can easily provide much more amount of time which focus on growing the business.  

Use of Database and IT Controls in TWHI

Managing customer data and relationship: As the students are considered to be lifeline of this TWHI. Then a proper kind of customer relationship management database are taken to be a part of growth plan. A proper database for CRM are properly powered so that can easily have enough amount of space for storing and processing. It can vary from administrative details and interaction details with the students. It can easily range from new prospectus details and new kind of business opportunities. If some of the situation it is observed that CRM system can be considered to be helpful for keeping a track of marketing campaign.

Proper Inventory Tracking: Proper management of inventory can be considered to be important balancing the whole act. It is generally taken to be very much easy for focusing on shelf risking weightage. An improper managed inventory can easily lead to disappointment and damage of staff reputation. If the individual is allowed for managing the inventory in manually which can easily lead to miscount, errors in spreadsheet. By the help of proper database which is along the electronic data interchange and barcode scan, then it can easily remove various risk. It will reduce lost sales which is needed for improving the growth opportunities.

Planning for growth: A large number of database capabilities come up with reporting based capabilities like calculating input data and tracking of production. It mainly helps in understanding the input data and tracking the production. It is mainly needed for understanding the future trends along with customer requirements. Database system can be considered to be important factor in growth strategy of the organization.

IT controls needed 

Database Management System can be stated a set of some complex programs which is needed for controlling the organization. It generally helps in storing and retrieval of data in database. Apart from this, it helps in proper control of security and integrity of database.

Database Control: It mainly relates to the class of database management system which is needed for ensuring that transaction can easily proceed in ACID way. ACID generally stands for Atomic, Isolated, Durable and Consistent. It generally focuses on serial and recoverable schedules which are permitted and committed for transactions. It is generally not discarded at the time of aborted schedule.

Conclusion 

From the above pages, it can be easily stated that this report is all about TWHI named non-profit organization. The organization provides online farming education to various famers of the world. There are mainly three requirement of TWHI HR like forms, reports and tables. HR manager of this organization which is needed for information about AusED employees. HR managers need to provide information about the allocation of proper subject to Academic staff. HR manager can easily view all the detail of the employees. In the table section on large number of things like creating database, normalizing database, updating SQL statements.

Agarwal, A., 2018. MS Access Tutorial For Beginners: Learn MS Access From Scratch Learn MS Access Step By Step.

Ceri, S., 2017. Distributed databases. Tata McGraw-Hill Education.

Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management. Cengage Learning.

Davie, B., Koponen, T., Pettit, J., Pfaff, B., Casado, M., Gude, N., Padmanabhan, A., Petty, T., Duda, K. and Chanda, A., 2017. A database approach to sdn control plane design. ACM SIGCOMM Computer Communication Review, 47(1), pp.15-26.

Elmasri, R. and Navathe, S., 2016. Fundamentals of database systems. London: Pearson.

Harrington, J.L., 2016. Relational database design and implementation. Morgan Kaufmann.

Hogan, R., 2018. A Practical Guide to Database Design. Chapman and Hall/CRC.