IFB105 – Assignment 3A – Information Modelling with ORM (Semester 1, 2021)Page 1IFB105Modelling Information SystemsAssignment 3A Handout– Information Modelling with ORM –Semester 1, 2021Due date: 23 April 2021 (11:59pm)Weight: 20%Assignment DeclarationBy submitting this assignment, I am/We are aware of the University rule that a student must not act in amanner which constitutes academic dishonesty as … Continue reading “Information Modelling with ORM | My Assignment Tutor”
IFB105 – Assignment 3A – Information Modelling with ORM (Semester 1, 2021)Page 1IFB105Modelling Information SystemsAssignment 3A Handout– Information Modelling with ORM –Semester 1, 2021Due date: 23 April 2021 (11:59pm)Weight: 20%Assignment DeclarationBy submitting this assignment, I am/We are aware of the University rule that a student must not act in amanner which constitutes academic dishonesty as stated and explained in the QUT Manual of Policies andProcedures. I/We confirm that this work represents my individual/our team’s effort. I/we have viewed thefinal version and declare that it does not contain plagiarized material. Full NameStudent No.Signature IFB105 – Assignment 3A – Information Modelling with ORM (Semester 1, 2021)Page 2SCENARIOUse the data as shown in Table 1 and Table 2 to come up an ORM information/data model for Task 1requirements.IFB105 – Assignment 3A – Information Modelling with ORM (Semester 1, 2021)Page 3TASK 1 (15 Marks)Your task is to design an information (data) model that suggests an effective and efficient way for storingdata of an Australian government agency working in the health area. As you are an expert in ORM, youdecide to develop an ORM model.Complete the drawing of the ORM conceptual schema for the universe of discourse as specified in the tablesas shown in scenario above by performing steps 1-5 as described below of the Conceptual Schema DesignProcedure.CSDP Step 1: Transform familiar examples into elementary facts and apply quality checks.CSDP Step 2: Draw the fact types and apply a population check.CSDP Step 3: Check for entity types to be combined and note any arithmetic derivations.CSDP Step 4: Add uniqueness constraints and check the arity (length) of fact types.CSDP Step 5: Add mandatory role constraints.Note: Refer to the Assessment 3A Template for a complete solution and understand how you/yourteam is required to submit the working of each CSDP steps.IFB105 – Assignment 3A – Information Modelling with ORM (Semester 1, 2021)Page 4TASK 2 (5 Marks)Map the following ORM schema to a relational database schema.
