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

3 types of financial management decisions - Geometry - Safety in the lab worksheet - Domestic causes of the great depression - Nonstop sql mx reference manual - Cham cham baje re payaliya shor machaye re - Tele fonika kable poland - Cite give me liberty eric foner - BUS-FP3050 Communication, Ethics, and a Command Decision - In 8 hours - Zinc and copper redox reaction equation - CT3 - Miles to kilometers conversions - Smiling bobs cape san blas - What is the strategic issue facing mystic monk coffee - Compressor burnout cleanup procedure - Problem 12 9a wileyplus - Psychology Discussion SUPER EASY AND FAST PLZ HELP - Ato tfn declaration form - How to add s - Response - Martins trailer parts catalogue - Cross sectional area of copper wire - Tool to generate sap fiori extension project - Allen cognitive levels scoring - Reclaim your heart singapore - Bex web application designer step by step - Hip hop timeline 1990 to present - Coates hire barossa valley - How many ml in a small styrofoam cup - Fire lieutenant interview questions and answers - Essays guru only - Borderlands 2 bloodshot stronghold couches - Graph for sin x cos y - Kaiser permanente vertical integration strategy - Central focus of economic perspective - Ministry of road transport and highways sarathi - Bpp icaew course dates - Discovering human sexuality 3rd edition ebook - Andy murray first serve percentage - University of cumberlands webmail - Duty of trust and confidence cipd - In the xy plane what is the slope - X bar chart minitab - Week 1 Discussion - A 1.00 kg glider attached to a spring - Answer below each 250 words with references and no plagarism, APA format. - Entry clearance officer islamabad - The three ethical principles discussed in the belmont report are - Glamox luxo lhh led - Eco 550 assignment 2 operations decision - Freezing temperature of corn syrup - Managing at camp bow wow - 300 words..APA format - Crankshaft balancing calculation pdf - Common information security threats involving ethical and legal concerns - Marine survey checklist pdf - Contribution margin per machine hour - Jb hi fi glendale - Health Care - Gc ms training courses - Modern essays by uma kant singh pdf - Engagement survey and action work plan - Resource acquisition plan template - Health assessment assignment - Topic 6 insolation and the seasons answers - Www homeserve com repairs - How big can aqua dragons grow - Uncertainty of 250 ml graduated cylinder - Locating the epicenter of an earthquake answer key - Chingford metal finishers slough - A 10000 kg rocket blasts off from earth - 25 50 75 a dollar song - Businesspeople who compose messages for mobile devices should - Technical English 7 - Pizza sweater key and peele - Cost to open jamba juice franchise - Project Plan - Tlmt 601 - Experiment 1: enzymes in food - Why is electrolysis used to extract aluminium but not iron - Knox park primary school - Real time physics lab 2 homework answers - Hfma point of service collections benchmark - History of nurse anesthesia - Cisco prime infrastructure license types - Supply chain - Dawn alcohol water ice melt snopes - What is hard engineering - Density determination pre lab answers - Pcs 7 training ppt - En 60204 1 wire colors - Double slit intensity graph - West end kennels stowmarket - Compare and Contrast - What approaches could have yielded additional valuable information - Six sigma data collection plan template - In crafting a company's strategy managers - Piaggio zip 70cc jetting - Transform plate boundary facts