ERD diagrams

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 200 points. See rubric for grading scheme.

BUSINESS REQUIREMENTS ACROSS ALL ASSIGNMENTS

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

You will work with book/music/media information, user information, ratings of books, and users’ social network
Each book has an id, title, publication date, publisher, ISBN, functional category, page count, price (publisher), and product description
There are 3 categories of book: fiction, non-fiction, and specialty
There are 2 categories of music: digital and media-based
An author can write one or more books.
A musician can be a solo artist, part of a group, or both
An author can also be associated with one or more publishers.
A musician/group/act can be associated with one or more music houses
An author’s book can have one or more editions.
A song and or album can have more than one version/edition (i.e. EP, LP, CD, DVD etc)
A publisher can have many authors and many books.

 

 

The post ERD diagrams first appeared on COMPLIANT PAPERS.