Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

ERD Diagram / Prototype Assignment (Fund of data systems)

21/10/2020 Client: carolinb Deadline: 24 Hours

 ERD Diagram and Prototype Database


The goal of the project is to implement a “prototype” database system application and 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 as a group. You will compete the assignment in the same groups you are to complete your Database Research Papers


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



  • 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 record labels (consider this a possible type of publisher)

  • 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.

  • A record company can have many artists associated and many albums associated with it. 

  • A record company can also be the publishing company (i.e. self-publishing - i.e. think Amazon)

  • Many ISBNs can also be associated with a given publisher but only one ISBN per form of medium (i.e. the ISBN is the PK no matter what).

  • An author can write many books.

  • An artist can write many songs, albums etc.

  • 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 item 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.


For this assignment, you are to create the ERD diagram as well as a working database in either Azure SQL, Google Cloud Platform (Spanner or MySQL), or AWS (pick your version). You can get a free student license up for any of these vendors.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Online Assignment Help
Custom Coursework Service
Quality Homework Helper
Top Grade Essay
Essay Writing Help
Buy Coursework Help
Writer Writer Name Offer Chat
Online Assignment Help

ONLINE

Online Assignment Help

Hi dear, I am ready to do your homework in a reasonable price.

$55 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

Hey, Hope you are doing great :) I have read your project description. I am a high qualified writer. I will surely assist you in writing paper in which i will be explaining and analyzing the formulation and implementation of the strategy of Nestle. I will cover all the points which you have mentioned in your project details. I have a clear idea of what you are looking for. The work will be done according to your expectations. I will provide you Turnitin report as well to check the similarity. I am familiar with APA, MLA, Harvard, Chicago and Turabian referencing styles. I have more than 5 years’ experience in technical and academic writing. Please message me to discuss further details. I will be glad to assist you out.

$55 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

Working on this platform from a couple of time with exposure of dynamic writing skills gathered with years experience on different other websites.

$62 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am a qualified and experienced Writer, Researcher, Tutor, analyst and Consultant. I hold MBA (Strategic Management) (Finance and Marketing) & CPA.K (Accounting and Finance.)

$62 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Itms service desk dmu - Turn my way shane gamble chords - How are accounting policies defined in the literature - Urica - What does it mean when jamaicans say blood clot - Why were other european countries slower to industrialize than britain - Removing old wallpaper from plaster walls - Kg s to m3 hr - D3 - Tjs inc makes three nut mixes - Ash gourd juice tesco - Using anatomical language answers part b - Ba falcon slow to engage reverse - Dan brock voluntary active euthanasia - What percentage of gmat scores are or higher - Orsett hospital blood test - Contextos lección 2 la tecnología answers - Dis 8 - Insurance council of australia find an insurer - Elimination of unrealized profit on intercompany sales of inventory - WEEK6-ResearchPaper-Data Science & Big Data Analy - Firm protective structure gives cell its shape - Blue banded bee nest blocks - Responses - Issue brief template word - Conflict Managment Paper 5 - Wk 3 - College Communication Worksheet [due Mon] Wk 3 - College Communication Worksheet [due Mon] - The assessment of the external and internal environments is called - Continuous skills in badminton - Annotated bibliography - Shadow health chest pain assessment - Partial and transitive dependency - Mars inc revenue 2018 - Effect of ph and temperature on enzyme activity lab report - Marketing management 12th edition - Strawberry dna extraction lab report - Nursing interventions to prevent clabsi - Internal medicine personal statement pdf - Autoclave vent filter sterilization - Rhetorical Analysis - Commercial cookery course in perth - Campusweb myunion edu - How to write picot question - An ideal source of energy - Hassoun coffee roxburgh park - Wessex gold riding club - Discussion Due Tomorrow Morning - I WANT TO JOIN OCCULT FOR MONEY RITUAL ?.+2349022657119. ✔️ - Aasb 112 tax effect accounting - English Literature - Business is a poker game and we are all bluffing - Counseling Question - Radnor house surgery ascot - Human resources managment legal ethical. deliverable 07 - Hbo go error code 03 37 317 - The economic function of profits and losses is to - Automotive gaskets and sealants ppt - Dan gartrell theory and methods - Illuminating photosynthesis webquest part 2 answer key - A level biology specification - Gordon russell design museum - Mgp10 span tables ceiling joist - Brisbane city council duplex - Question - Combating fake news in the digital age joanna m burkhardt - They say i say essay format - Daksh gupta net worth - Eddie mabo major achievements - Portal runner ps2 cheats - Organelles and illness activity case - The Case Study: Opening Your New Dunkin’ Donuts Locations paper - Program development life cycle definition - Dvd rental database postgresql - Creation myth writing assignment - Hampton wick infant and nursery school uniform - The backchannel can present challenges for business presenters because - Learning in psychology ppt - North miami middle school - Ysl leather tote bag - Accounting - Project management lesson plan - 40 million dollar slave sparknotes - Examples of active publics - Restaurant ordering system project documentation - Electronics and communications apprenticeship wage - Heaven is paved with oreos summary - Barrhead travel gift vouchers - Openwhisk serverless environment - Interaction design 5th edition pdf - Weakness as a nurse practitioner - Higher biology course code - Aero automatic sprinkler company lawsuit - Dulux texture fine cover - Commedia dell arte features - Record the pairs of data for pressure and propane volume in the table below. - Https www youtube com watch v fvpakzqm3h8 - Bishop challoner basingstoke term dates - As3000 conduit depth under concrete - Problem 5 3a perpetual alternative cost flows lo p1 - Allusion in the scarlet ibis