The goal of the projects throughout this semester is to implement a “prototype” database system application for a 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 your teams (see attached for group member breakout) to complete the assignment. Below you will find the ERD deliverable requirements. Each assignment has a specific grading rubric (scheme) associated with the assignment. 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 the projects this semester is to implement a prototype database system application for an eCommerce social-network system called UCOnline. UCOnline allows users to explore information about books, music, and software, rate their purchases, identify purchase prices, and see the ratings of their friends. In order to complete the assignment, your team will need to work on the assigned tasks and deliverables.

One of the main requirements for the UCOnline system is the ability to keep track of user ratings for each item sold in the online store. Users can rate items on a scale of 1 to 5, with 1 representing “Dislike” and 5 representing “Awesome!” A particular user can only rate a particular item 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 also have a name, gender, age, and location. It is important to note that nothing is anonymous in UCOnline, meaning that all user information will be stored and associated with the ratings they submit.

To implement the UCOnline system, you will need to design and create an Entity-Relationship Diagram (ERD) that reflects the relationships between the different entities involved. The ERD will serve as a blueprint for creating the database schema and implementing the necessary tables and relationships.

Additionally, you will also need to develop the necessary code and functionality to allow users to rate items, explore information about books/music/software, identify purchase prices, and view the ratings of their friends. This may involve creating user interfaces, implementing data retrieval and storage functionalities, and ensuring data integrity and security.

Throughout the semester, you will be required to submit various deliverables related to the development of the UCOnline system. Each assignment will have a specific grading rubric associated with it, which will outline the expectations and criteria for evaluation. It is important to carefully review and follow the requirements of each assignment to ensure your team’s success.

In summary, the goal of the semester projects is to implement a prototype database system application for UCOnline, an eCommerce social-network system. This application will allow users to explore information about books/music/software, rate their purchases, identify purchase prices, and view the ratings of their friends. The development process will involve designing an ERD, creating a database schema, implementing necessary functionalities, and submitting various deliverables throughout the semester. It is crucial to adhere to the requirements and grading rubrics for each assignment to achieve successful completion.