Need help with ERD diagram

 The ambition of the projects throughout this semester is to apparatus a “prototype” database arrangement appliance for a eCommerce social-network arrangement alleged UCOnline area users can analyze advice about books/music/software, amount your purchase, analyze acquirement amount and see ratings of their friends.The activity will crave your teams (same accumulation as address weekend) to complete the assignment. Below you will acquisition the ERD deliverable requirements. Anniversary appointment has a specific allocation explanation (scheme) associated with the assignment. BUSINESS REQUIREMENTS ACROSS ALL ASSIGNMENTS. You will assignment with book/music/media information, user information, ratings of books, and users’ amusing network Anniversary book has an id, title, advertisement date, publisher, ISBN, anatomic category, folio count, amount (publisher), and artefact description There are 3 categories of book: fiction, non-fiction, and specialty There are 2 categories of music: agenda and media-based An columnist can address one or added books. A artisan can be a abandoned artist, allotment of a group, or both An columnist can additionally be associated with one or added publishers. A musician/group/act can be associated with one or added music houses An author’s book can accept one or added editions. A song and or anthology can accept added than one version/edition (i.e. EP, LP, CD, DVD etc) A administrator can accept abounding authors and abounding books. A almanac aggregation can accept abounding artists associated and abounding albums associated with it.  A almanac aggregation can additionally be the publishing aggregation (i.e. self-publishing) Abounding ISBNs can additionally be associated with a accustomed administrator but alone one ISBN per anatomy of average (ie the ISBN is the PK no amount what). An columnist can address abounding books. An artisan can address abounding songs, albums etc. UCOnline needs to accumulate clue of user ratings for anniversary account awash in the online store (e.g., 1-5 and 1 for ‘Dislike’, to 5, for ‘Awesome!’). A accurate user ante a accurate account at a accustomed time. A user CANNOT amount the aforementioned assorted times unless there are assorted editions of the item. Anniversary copy can be rated separately. Anniversary user who submits a appraisement will be articular by a different id and has a name, gender, age, and location. Nothing is anonymous. There is additionally a amusing arrangement amid users. Users can accelerate advice requests (i.e. burning messages/emails) to alternative users. Such requests can be accustomed or ignored. Once accepted, the two users are advised ‘book buddies.’ If ignored, the user can accelerate the appeal again. We appetite to add a abundance back the requests were beatific (timestamp), the aftereffect of the requests and back the appeal was answered (timestamp).

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
Top Academic Writers Ready to Help
with Your Research Proposal
error: Content is protected !!
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code COURSEGUY