Data base system Case Study – “process modelling” and “data modelling”

[ad_1]

Assessment Type Case Study
Assessment Number 3
Assessment
Weighting Case Study
20%

Alignment with Unit and Course Unit Learning Outcome Graduate Attributes Assessed
ULO 1: Describe and discuss concepts and principals of systems analysis and design
ULO 2: Examine the stages of the systems development life cycle
ULO 3: Apply basic diagrammatic modelling tools to systems analysis and design
GA 1: Communication
GA 4: Critical Thinking and Problem Solving
GA 6: Flexibility
Due Date/Time Week 10
4th October 2019 via Moodle before 9 PM
Assessment Description You are required to design a system that can perform the above activities and maintain a database containing data relevant to those activities. Carry out “process modelling” and “data modelling” to achieve this purpose.

Content and Structure:
You are required to submit a report of at least 800 words excluding references.

Detailed
Submission Requirements You may choose a case study from the prescribed text book.
You will need to get an approval from the lecturer before they proceed.

Tasks

• Provide a justification of why this system needs to be developed and ensure that you are professionally convincing to senior management.
• Provide a description of the business case and justification about the business benefits from implementing this system.
• Describe the project scope and provide a brief cost and schedule analysis.

• Create a Use Case diagram to show the actors and a sequence diagram for at least one of the processes
• Develop data flow diagram (DFD level 0 and Context Diagram with at least 1 process exploded).
• Prepare entity relationship diagram, to model the data requirement relevant to this system. Make use of Crow’s foot notations in ER diagram. Indicate Primary and Foreign keys clearly. Make sure the data is in 2nd Normal Form.
• Create 3 screen interfaces a (main menu, an input screen and a report).
• Create a Gantt chart to show the project schedule in Excel or MS Project

The marking will be based on the design; it is not necessary to implement the system.

Misconduct • The assessment will be submitted through Turnitin via your unit page on Moodle.
• Turnitin is plagiarism software, which will identify if you have copied information and included it in your assessment.
• Copying information from others (i.e. websites, partner company information, or other students etc.) without the acknowledging the author is classified as misconduct.
• Engaging someone else to write any part of your assessment for you outside of the group work arrangement is classified as misconduct.
• To avoid being charged with Misconduct, students need to submit their own work and be able to explain the program logic and its working.

Late Submission • Any assessment submitted past the specific due date and time will be classified as Late.
• Any Late submission will be subject to a reduction of the mark allocated for the assessment item by 5% per day (or part thereof) of the total marks available for the assessment item. A ‘day’ for this purpose is defined as any day of the week including weekends. Assignments submitted later than one (1) week after the due date will not be accepted, unless special consideration is approved as per the formal process.

Rubrics Marking Criteria
HD D C P F

ULO 1: Describe and discuss concepts and principals of systems analysis and design
ULO 2: Examine the stages of the systems development life cycle
ULO 3: Apply basic diagrammatic modelling tools to systems analysis and design
All tasks are correct

Student provides explanation and details for all tasks

(16 – 20 marks)
All tasks are done and are correct

(13 – 16 marks)

Tasks are partially correct

(10 – 13 marks)
Some of the tasks specified above are not accurate or incorrect

(10 marks)
All tasks specified above are not done correctly

Only some tasks may have been attempted or done properly

(0 – 10 marks)

The post Data base system Case Study – “process modelling” and “data modelling” appeared first on mynursinghomeworks.

[ad_2]

Source link