University of Australia is interested in a new Student record management
system. This system needs a database to manage students enrolled, courses students
enrolled in and staff facilitating the course. You will need to store and manage the data for
the enrolled students, courses and the staff assigned to the courses. The system is intended
to be built in-house. The university has a very strong information systems suite of programs
and the students of that program are showing great insight and promise. It has signalled its
intention to seek input from those students in a consulting arrangement. The system should allow the staff to add, update and delete the records of students, staff
allocated to course and courses. In addition, University staff should be able to see the list of
students enrolled in a particular course facilitated by a particular learning facilitator.
Based on this scenario, you should identify key data objects and their attributes and define them as
columns in the spreadsheet. Create multiple versions of the spreadsheet file as per below
• Version 1 (V1.0) with all possible database objects and attributes and create 30 rows of data.
• Version 2 (V1.1) of the file should update last 2 records and add 5 additional records
• Version 3 (V1.2) of the file should add 2 new attributes
• Version 4 (V1.3) of the file should remove 5 existing attribute and add 5 more rows of data
When you are finished this, combine the four versions of the Excel database solution with a
document that in more than 1000 words, describing your experience.