ITS113 : Database Design - Entity Relationship Model - Engineering Assignment Help

Assignment Task :

Assignment – Social media 

This assignment puts the students in a hypothetical, but realistic, scenario where they design a database intended to support a web site with a social media platform as illustrated . The assignment is divided into two parts which are intended to reinforce the iterative methodology used in a typical project. Part A requires each student to use business rules to develop the first draft of the design. Part B builds on part A to refine the model and deliver a MySQL implementation of the database. 

Anyone should be able to view the contents of the site. Users can create an account and this will give them the ability to create a post with a picture, title and a description. Users with valid accounts can add comments to any post. Valid users should also be able to rate posts and comments, with positive, neutral (default) or negative sentiment. All posts and comments should be time stamped. Deleting a post should also delete all comments associated with it. 

Deliverables 

Part A 

This part of the assignment should be delivered as one component: 

• Entity relationship model document – This component should be uploaded to Moodle as a single file. The preferred format is PDF, however Libre Office or Microsoft Office files are also acceptable. 

Entity Relationship Model Document 

This document should capture the business rules, based the provided information. Students will need to identify the entities involved and create external model(s) that show their relationships, then combine these into a unified conceptual model that represents the logical view of the entire database. A combination of entity relationship diagrams and a data dictionary should be used. Students should document the assumptions they make and provide reasoning when faced with design choices that are not straight forward. 

The information provided in the scenario is far from exhaustive and a process of discovery will be required to gain a better understanding. Students will have the opportunity to ask questions during tutorials and should also perform their own research to discover how real world organisations operate. The documentation should capture this discovery process and provide proper attribution for the sources of information in the form of references. 

Part B 

This part of the assignment should be delivered as two components: 

• Entity relationship model document – This component should be uploaded to Moodle as the first file. The preferred format is PDF, however Libre Office or Microsoft Office files are also acceptable. 

• MySQL database – This component should be uploaded to Moodle as the second file. It should be a MySQL dump file, exported from your database.

This Engineering Assignment  has been solved by our Engineering  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.