The goal of the project is to implement a “prototype” database system application / ERD diagram for an eCommerce social-network system called UCOnline where users can explore information about books/music/software, rate your purchase, identify purchase price and see ratings of their friends. The project will require you to complete the assignment individually. Below you will find the ERD deliverable requirements. There are two parts to the assignment. You must create a diagram using a diagramming tool AND provide a written text-based document explaining your relationship mapping (systems analysis use case document). The assignment is worth 350 points. See rubric for grading scheme. BUSINESS REQUIREMENTS ACROSS ALL ASSIGNMENTS You will work with book/music/media information, user information, ratings of books, and users’ social network UCOnline needs to keep track of user ratings for each item sold in the online store (e.g., 1-5 and 1 for ‘Dislike’, to 5, for ‘Awesome!’). A particular user rates a particular item at a given time. A user CANNOT rate the same multiple times unless there are multiple editions of the item. Each edition can be rated separately. Each user who submits a rating will be identified by a unique id and has a name, gender, age, and location. Nothing is anonymous.

The goal of this project is to implement a prototype database system application for an eCommerce social-network system called UCOnline. This application will allow users to explore information about books, music, and software, rate their purchases, identify purchase price, and see the ratings of their friends. It is important to note that this project should be completed individually.

The first part of the assignment requires you to create an Entity-Relationship Diagram (ERD) using a diagramming tool. The ERD will serve as a visual representation of the database schema and the relationships between entities. It will provide a clear view of how data is organized and connected within the system.

The second part of the assignment entails providing a written text-based document explaining your relationship mapping, which falls under systems analysis use case document. This document will explain how different entities in the system are related to each other and how they work together to fulfill the system’s requirements. It will also describe the various use cases and functionalities of the system.

The assignment is worth 350 points and a rubric is provided to guide the grading process. It is crucial to understand the business requirements for this assignment. UCOnline needs to keep track of user ratings for each item sold in the online store. The ratings range from 1 to 5, with 1 representing ‘Dislike’ and 5 representing ‘Awesome!’. Each user can rate a particular item only once, unless there are multiple editions of the item. In that case, each edition can be rated separately. Each user who submits a rating will be identified by a unique id and will have additional information such as name, gender, age, and location. It is important to note that the system does not support anonymous ratings, meaning that all ratings will be linked to a specific user.

By following these guidelines, you will be able to design and implement a prototype database system application for UCOnline. The ERD will provide a visual representation of the database schema and the system’s relationships, while the written text-based document will explain the relationship mapping and provide a comprehensive understanding of the system’s functionalities. As a result, you will gain practical knowledge and experience in database design and implementation, as well as system analysis and requirements gathering.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer