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

Nelson mandela leadership style - Introduction to political theory john hoffman paul graham pdf - Brivis evaporative cooling for sale - Melting point of urea and cinnamic acid - Italian musical terms quiz - Student will produce a 6 page research paper based on the question of their choice from the approved topics below. - MG401 Unit 2 Assignment - Course Assignment (course - Bussiness Continuation Plan & Disaster Recovery Plan ) - Public policy 2 3 chapter assignments - William cleveland a history of the modern middle east pdf - Discussion 3 Japan - Effect of roughness on frictional force - Nestle reduced cream substitute - Desiree's baby reading thinking guide answers - Nursing care plan for homicidal ideation - Titanic case study ethics - Need 5+ pages with no plagiarism and 2+ scholarly references in Apa format. - 7/9 as a recurring decimal - It's the economy stupid fallacy - What is an entreprenuer - Cu otf 2 py 4 - Expert in Embedded system - Sweatt v painter definition - Sigma urgent care west lafayette in - Michigan organizational assessment questionnaire pdf - Uncle benny's face cream vitamin e - Todaiji temple ap art history - Week 10 - 5/33-37 st georges road bexley - Ellis issues 6.5 five year bonds dated - Writing assignment - Topographic map scale conversion - Margaret atwood happy endings essay - Approximate value of the golden ratio to the nearest thousandth - Attached vs detached earlobes percentage - Speed torque relation of bldc motor - Do plants grow better in sunlight or artificial light hypothesis - Order entry sales oe s process - Kathmandu annual report 2020 - Kaylee's Sweets - Reasons for the seasons lab answers - Megamart a retailer of consumer goods - The ________ rule specifies that an entity can be a member of only one subtype at a time. - Samsung unethical business practices 2016 - 3 meaning in texting - Reaserch paper - Health Organ Paper1 - New deal relief poster - Which of the following best describes the trial balance - Borland's Brave Beginning - Term paper - For Guru Olivia Only - Epicardial pacing wires nursing - Acecqa self assessment tool - Accounting Financial statements - Church view surgery collingham - How to calculate mcg kg min - Analyzing and Visualizing data - Sustainbility Essay - Right and wrong basic readings in ethics christina hoff sommers - Financial reporting problem part 2 - Dulux texture medium cover - Healthcare gov project management case study - How to get logger pro for free - Quotes from the crucible - Religion and Ethics APA need done ASAP! - Merv irvine nursing home - Informative Speech - Leader/Context Interaction and Theory Applicability - Discussion Question - Measures a module’s scope and processing characteristics. - How to find out volume of a cuboid - Medical practice problem - Bishop tufnell primary school - Front squat jeff nippard - First disis - Cisco mds 9710 end of life - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Kadapa - How to do adjustments in accounting worksheet - How to end diary entry - Taboo esl game cards - The ____ shortcut keys remove character formatting - A series rlc circuit consists of a 50 ohm resistor - Elle demasi jermaine lewis - 7 non price determinants of demand - Master of physiotherapy griffith - Restricted cos points calculator - Bhopal disaster ethics - Week 7 discussion - Finanance and blockchain - Alfa romeo usp - Cell defense worksheet answers - Tips for facilitating group discussion - Cal g to kcal g - Tvm solver ti nspire - Ethical autobiography example - In 8 hours - Dunkin donuts duties and responsibilities - What is the market portfolio beta - A doll's house rolf fjelde pdf