ITEC200: Data and Information Management - IT Assignment Help

Assignment Task:

Task:

Context
Australian Department of Social Services has developed a data collection and reporting system called Data Exchange.
The Data Exchange provides flexible ways for community service providers (e.g. charities, NGOs, ...) to submit performance information to the department. In return, the Data Exchange delivers two-way data sharing between funding agencies and organisations in a range of engaging reports. This data helps them find smarter and more efficient ways of improving service delivery and understanding the outcomes being achieved for vulnerable individuals, families and their communities.
The concepts and terminology associated with collecting and reporting client level data from Australian Department of Social Services’ Data Exchange is provided the “Data Exchange Protocols” document.
 

Instructions
Read the “Data Exchange Protocols” document (Pages 4-10, 16-27 and 46-57).

Based on the information provided about the data requirement of the Data Exchange system, develop the logical- level database design by creating an Entity Relationship (ER) diagram.

The ER diagram should include Entities, Attributes and keys, and Relationships. Model relationships in this assignment using Chen Notation.

To develop a well-designed ER diagram:
1. Identify all Entities, their Attributes and relationships between the entities.
2. Use ERDPlus (https://erdplus.com) to draw ER diagram.
3. Add connectivity, cardinality, and constraints to the diagram.
4. Resolve any many-many relationships and one-to-one relationships.
5. Specify the appropriate Primary keys and Foreign keys on the ERD.
6. Apply normalisation to resolve any anomalies. Your tables must be at least in the third normal form (3NF).
7. Using ERDPlus convert the ERD to Relational Schema.
8. Create a word document, with a title page including your student ID, name, unit name & title, assignment number. Paste the ER diagram and Relational Schema in a Word document. Also, clearly state any assumptions that you make.

9. Write the SQL Code for creating the database tables. You can manually write the SQL code in a text file or use ERDPlus to generate the SQL code. The SQL code generated by ERDPlus may need some tweaks depending on how detailed is your ERD diagram. For example, if you have not added some constraints on the ERD, they will not be included in the generated SQL code and you will need to add them manually.

10. Using MySQL Workbench, create a new blank database.
11. Record a short presentation (2 to 3 minutes):
o Use Zoom to record a short presentation.
o Share your screen and have your webcam open so your face appears on the corner of the screen.
o In your presentation first open the ERDPlus website, login to your account, open the ER diagram explain the main relationships in the ERD.
o Then, run MySQL workbench, and run the SQL scripts you have written to generate the tables.

12. In your report, write a short paragraph (max 250 words) to answer the following question: With regard to respect for the human dignity, what measures have been considered in the design and implementation of the Data Exchange? Is there any risk of disrespecting of human dignity in this database? If yes, how can those risk be mitigated? Hint: Read section 4 of “Data Exchange Protocols” document (Protecting a client’s personal information, page 11-15).

This ITEC200 IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.