Reference no: EM132551059
MIS602 - Data Modelling and Database Design - Reflective Research Report - Laureate International Universities
Assessment of File-based Database Design
Instructions:
There is an imperative requirement in this assessment; The data in the files should be composed based on the following scenario:
Torrens University Australia (TUA) 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 instruction:
• 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. On the morning following submission, the learning facilitator will allocate you another student's spreadsheets and summary document to assess. It is then your turn to assess another student's work. You will have three days to assess the other student's work and to upload your response to Blackboard.
In no more than 500 words, provide a critique of that student's work to them. You can choose whether to identify yourself but you should provide constructive feedback, balancing good points and points where the student can improve. You should use the scenario and provide feedback to the other student on their list of data objects, data attributes and summary document. You are free to use whatever framework you like and the following should be minimum inclusions:
• Comment on the overall suitability of the data objects and attributes as an input for database design and the summary document
• Provide constructive criticism on how the other student can improve their data objects and attributes in future
• Provide some useful readings the other student may peruse that helps them develop their understanding of data and data attributes
Attachment:- Data Modelling and Database Design.rar
Retailing assignment
: How might a hypermarket located in India appeal to consumers and orient them to shopping in larger stores? Many of the stats quoted in this case are 2012, 2014.
|
What would be its operating income for the month
: Spotless, Inc., Assuming that direct labor cost can be reduced by $2 per unit, what would the maximum operating income be per month?
|
What would be the total overhead cost per customer
: What would be the total overhead cost per customer according to the activity-based costing system, rounded to the nearest whole dollar?
|
What is relationship between self-esteem and esteem needs
: Read the article, "A Theory of Human Motivation." Based on the information presented in the article, discuss the elements of self-esteem, esteem needs.
|
Understanding of data and data attributes
: Assessment of File-based Database Design - identify yourself but you should provide constructive feedback, balancing good points and points where the student
|
What would be its operating income for the month
: Spotless, Inc., Assuming that direct labor cost can be reduced by $2 per unit, what would the maximum operating income be per month?
|
Borrow or pay cash
: Calculate the cash down payment for the loan. Calculate the initial cash outlay under the cash purchase option.
|
What would be the minimum unit price that burns industries
: Assuming only criteria in accepting such offer is short term financial gain or loss, what would be the minimum unit price that Burns Industries would accept
|
What would be the total overhead cost per order
: What would be the total overhead cost per order according to the activity-based costing system, rounded to the nearest whole cent?
|