MIS602 Data Modelling and Database Design
|Subject Code and Title||MIS602 Data Modelling and Database Design|
|Learning Outcomes||The Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Examine the role of data in an organisation, and develop solutions related to the creation, storage and management of organisational data. c) Apply contemporary database modelling to identify and address anomalies in data and recommend solutions.|
|Submission||For 12-week Duration: Due by 11:55 pm AEST Sunday end of Module 2 (Week 4) For 6-week Duration: Due by 11:55 pm AEST Sunday end of Module 2 (Week 2)|
|Total Marks||100 Marks|
This assessment requires you to prepare a modelling report that demonstrates your ability to assess business requirements along with a logical design that could be implemented in a relational database management system.
When preparing to implement a new information system, it is essential that the initial design is well thought out from the outset. Modifying the database after implementation can often be an expensive process in terms of time, effort and cost. Often the first engagement step is to conduct interviews and workshops with end users and business subject matter experts to get a better understand of how the business runs. The output of these workshops becomes the foundation for the database design.
Please read the attached MIS602_Assessment 1_Case Study.
Based on the information provided in the case study, prepare a modelling report to answer the following tasks:
Task 1: An entity relationship diagram including all the significant entities, attributes and their relationships. Use Crow’s foot notation.
Task 2: A relational model showing all fields, primary keys, foreign keys and concatenated keys. Your relational model should be in third normal form. List any assumptions/business rules you have made.
Task 3: A sample dummy input screen of scheduling an interview for one of the shortlisted candidates. You have to make sure all the data requirements are being captured.
You may use any tool you like to create this sample screen. Write a brief paragraph of about 200 words discussing the following:
- Does your database design allow the storage of all the required information?
- What changes, if any, did you make to your initial ER diagram and relational model after you created the sample input screen?
The front-end or user interface design enables accessing the data stored in a database. Prototyping the interface also enables capturing initial system and data requirements.
Please compile all the three tasks into a single word document and submit via the Assessment 1 section found in the main navigation menu of the subject’s Blackboard site. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
|When submitting their assessment task, students will be asked to declare the academic integrity of their assessment by completing and signing an assignment cover sheet. You can find the assignment cover sheet here|
All students are responsible for ensuring that all work submitted is their own and is appropriately referenced and academically written according to the Academic Writing Guide.
Students also need to have read and be aware of Torrens University Australia Academic Integrity Policy and Procedure and subsequent penalties for academic misconduct. These are available at https://www.torrens.edu.au/policies-and-forms.
Students also must keep a copy of all submitted material and any assessment drafts.
To apply for special consideration for a modification to an assessment or exam due to unexpected or extenuating circumstances, please consult the Assessment Policy for Higher Education Coursework and ELICOS and, if applicable to your circumstance, submit a completed Application for Assessment Special Consideration Form to your Learning Facilitator. These documents are available at https://www.torrens.edu.au/policies-and- forms