Reference no: EM132388792
Assignment: CSIT115 Data Management and Security, University of Wollongong
Task 1 - Requirements
A) The business requirements described in the earlier "Task 1 - Description" section represents the latest (in on-going efforts) to document the user's needs. Whether you think it is complete or not, you are not allowed to add or change requirements / attributes to the specification given above!
B) The 'journey' in analyzing business requirements can sometimes be a subjective effort, depending on factors like language proficiency, various statement interpretations and different perspectives / points of view. Therefore, apart from the final diagram model, it is very important that you are able to document the process of coming up with your final diagram!
C) For conceptual modeling, the process should be similar to the "6 steps methodology" described in the slides from lecture file : (4) Conceptual Modeling.
D) You are to submit a softcopy report that explains the process in analyzing the requirements and deriving the model. EACH STEP should have the following sub- sections :
i) explanation and evidence (of requirements). You may quote, copy-paste 'partial' sentences / paragraphs from the business requirements, to support your explanation for areas like :
- why certain classes / objects are included, OR
- why a certain class should have certain identifiers / attributes / qualifications OR
- why you should have link attributes between classes 'A' and 'B'
- etc.
ii) diagrammatic fragments of the conceptual schema, (i.e. screen-captures from UMLet)
E) In your report, you may include a new section "Assumptions and Justifications" - for special situations where:
i) you are unable to find actual wordings / (direct) sentences in business requirements BUT ...
ii) you feel there is strong, indirect evidence to include certain elements / aspects / characteristics of your conceptual schema.
Note: It is up to your tutor's discretion to assess the accuracy of your assumptions/explanations. You cannot assume your tutor must fully agree with all your statements simply because you added them in!
F) You are required to use UMLet diagramming tool to design/draw all your conceptual models. For your final conceptual model, you are required to save it as a *.bmp file (via File | Export As ... function in UMLet)
G) Please refer to Appendix A, for details on deliverables & file naming conventions for this task.
H) Please refer to Appendix B, for details on submission procedures and when to submit, for this assignment.
I) Please refer to Appendix C, which describes the assessment / grading guidelines for this assignment
Task 2 - Requirements
A) Please make use of the conceptual schema (shown in the earlier "Task 2 - Description" section) only. You are not allowed to add or modify classes / attributes in the model given above!
B) There are many considerations to be addressed, in order to produce a set of coherent relational schemas. Therefore, it is very important that you are able to document the process of undergoing various transformations to arrive at your final output!
C) For logical design, the process should be similar to the descriptions & examples found in the lecture slides : (6) Logical Design.
D) You are to submit a softcopy report that explains the process in analyzing / transforming the conceptual. EACH TRANSFORMATION should have the following sub-sections :
i) Type and explanation of transformation applied. You may include the following points, to support your explanation. For example :
- Type of transformation (e.g. multi-valued attribute)
- Affected Class(es) / Attribute(s) / Associations (e.g. 'Book', 'author-name', etc)
- Description of how you applied the transformation to the affected elements in the conceptual model
ii) "Before" and "After" diagrammatic fragments of the conceptual model, (i.e. screen- captures from UMLet), to contrast pictorially, the differences prior to, and just after you applied the transformation
E) For all diagrammatic fragments in this task, you are required to use UMLet diagramming tool.
F) For your final set of relational schemas, save it into a text file. The schemas must be presented in a format described in the last few slides of the lecture file : (6) Logical Design
G) Please refer to Appendix A, for details on deliverables & file naming conventions for this task.
H) Please refer to Appendix B, for details on the submission procedures and when to submit, for this assignment.
I) Please refer to Appendix C, which describes the assessment / grading guidelines for this assignment
Information related to above question is enclosed below:
Attachment:- CSIT115_Assn1.rar