Scribd Logo
Upload

Welcome to Scribd!

    • 114 views

    Assessment 1 Brief: Subject Code and Title Assessment Individual/Group Length Learning Outcomes

    Uploaded by

    Muntaha Zyan
    This assessment requires students to prepare a modelling report that demonstrates their ability to assess business requirements and design a logical database structure. Students must create an entity relationship diagram, relational model in third normal form, and sample input screen. They must also discuss whether the database design can store all required information and any changes made from the initial ER diagram. The report is worth 30% of the student's grade and is due by the end of Module 2.2.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Assessment 1 Brief: Subject Code and Title Assessment Individual/Group Length Learning Outcomes

    Uploaded by

    Muntaha Zyan
    114 views5 pages
    This assessment requires students to prepare a modelling report that demonstrates their ability to assess business requirements and design a logical database structure. Students must create an entity relationship diagram, relational model in third normal form, and sample input screen. They must also discuss whether the database design can store all required information and any changes made from the initial ER diagram. The report is worth 30% of the student's grade and is due by the end of Module 2.2.

    Original Title

    Document

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This assessment requires students to prepare a modelling report that demonstrates their ability to assess business requirements and design a logical database structure. Students must create an entity relationship diagram, relational model in third normal form, and sample input screen. They must also discuss whether the database design can store all required information and any changes made from the initial ER diagram. The report is worth 30% of the student's grade and is due by the end of Module 2.2.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    114 views5 pages

    Assessment 1 Brief: Subject Code and Title Assessment Individual/Group Length Learning Outcomes

    Uploaded by

    Muntaha Zyan
    This assessment requires students to prepare a modelling report that demonstrates their ability to assess business requirements and design a logical database structure. Students must create an entity relationship diagram, relational model in third normal form, and sample input screen. They must also discuss whether the database design can store all required information and any changes made from the initial ER diagram. The report is worth 30% of the student's grade and is due by the end of Module 2.2.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    ASSESSMENT 1 BRIEF

    Subject Code and Title MIS602 Data Modelling and Database Design

    Assessment Modelling Report

    Individual/Group Individual

    Length N/A

    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 Due by 11:55pm AEST/AEDT Sunday end of Module 2.2

    Weighting 30%

    Total Marks 100 Marks

    Task Summary
    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.

    Context
    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.

    Task Instructions
    1. Please read the attached MIS602_Assessment 1_Case Study.

    2. Based on the information provided in the case study, prepare a modelling report to answer the
    following questions:

    • An entity relationship diagram including significant attributes against each entity.

    • 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.

    • A sample screen of what you think your online order form might look like. You may use any tool
    you like to create this sample screen. Write a brief paragraph discussing the following:
    o Does your database design allow the storage of all the required information?
    o What changes, if any, did you make to your initial ER diagram and relational model after
    you created the sample input screen?

    MIS602_Assessment 1_Brief_Modelling Report_Module 2.2 Page 1 of 3

    Referencing
    It is essential that you use appropriate APA style for citing and referencing research. Please see more
    information on referencing here http://library.laureate.net.au/research_skills/referencing

    Submission Instructions
    Submit Assessment 1 via the Assessment link in the main navigation menu in MIS602 Database Modelling and
    Database Design. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal.
    Feedback can be viewed in My Grades.

    Academic Integrity Declaration


    I declare that except where I have referenced, the work I am submitting for this assessment task is my own
    work. I have read and am aware of Torrens University Australia Academic Integrity Policy and Procedure
    viewable online at http://www.torrens.edu.au/policies-and-forms
    I am aware that I need to keep a copy of all submitted material and their drafts, and I will do so accordingly.
    MIS602_Assessment 1_Brief_Modelling Report_Module 2.2 Page 2 of 3
    Assessment Rubric
    Assessment Attributes Fail Pass Credit Distinction High Distinction
    (Unacceptable) 0-49% (Functional) (Proficient) 65-74% (Advanced) (Exceptional)
    50-64% 75 -84% 85-100%
    Entity relationship diagram Only a few entities Most entities identified All entities identified and All Relationships Primary keys labelled for
    identified and labelled. and labelled. Most labelled. meaningfully labelled. many-to-many
    The ER diagram does not have to be No relationships relationships All relationships identified. Primary key labelled for relationships. Some
    in 3NF. i.e. it can contain many identified. identified. Most cardinality is correct. entities. non-key fields
    to many relationships Most Participation is correct. All cardinality is correct. labelled.
    All participation is correct. Overall, a well-presented
    40% entity relationship
    diagram.

    Relational model Only a few entities Most entities converted All entities converted to All many-to-many Any multi-valued
    converted to tables. to tables. Most fields tables. All fields listed. relationships attributes deconstructed
    The relational model needs to be in Design is not in third listed. Design is in third Most many-to-many deconstructed into new into new tables. Any
    3NF and free from anomalies normal form. normal form. List of relationships deconstructed tables. Foreign key selfjoins identified. A
    No list of assumptions/ assumptions/business into new tables. Primary correctly underlined. wellpresented relational
    business rules. rules provided. keys correctly underlined.
    40% model.

    Sample screen Sample screen does not Screen captures most of Screen captures all of the All screen fields correctly All screen fields correctly
    capture the the requirements for the requirements for the order. mapped to a field in the and accurately map to a
    Sample screen of the online order requirements of the order. Discussion paragraph is relational model. field in the relational
    form. order. Discussion paragraph provided. Discussion paragraph is model.
    Discuss how the database design No discussion paragraph does not address the key well written and addresses Well-presented sample
    allow the storage of all the required provided. points. the key points. screen along with a
    information and the changes made discussion paragraph that
    to the initial ER addresses the key points
    diagram and relational model with clarity and detail.

    20%
    MIS602_Assessment 1_ Brief_Modelling Report_Module 2.2 Page 3 of 3

    You might also like