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

Implement a “prototype” database system application / ERD diagram for an eCommerce social-network system

30/09/2020 Client: sathvik2009 Deadline: 24 Hours

 


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

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

  • Many ISBNs can also be associated with a given publisher but only one ISBN per form of medium (ie 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 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.


There is also a social network between users. Users can send communication requests (i.e. instant messages/emails) to other users. Such requests can be accepted or ignored. Once accepted, the two users are considered ‘book buddies.’ If ignored, the user can send the request again. We want to add a store when the requests were sent (timestamp), the result of the requests and when the request was answered (timestamp).

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:

Helping Hand
Top Academic Guru
University Coursework Help
Top Essay Tutor
Solution Provider
Essay & Assignment Help
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$35 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$62 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer
Solution Provider

ONLINE

Solution Provider

I am an experienced writer who will be able to create the quality articles/blogs that you require for your website. My work is compelling enough that I am immediately able to engage the interest of the reader. I do not need much in the way of assistance; all you have to do is give me a title or topic. I include embedded hyperlinks as a standard feature in all my articles/blogs. I can also use SEO keywords if provided without any extra cost. No matter what the topic is, your articles/blogs will be entertaining and immensely readable. I take immense pride in my professionalism and ghost-writing technique. Thank you,

$55 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I have a Master’s degree and experience of more than 5 years in this industry, I have worked on several similar projects of Research writing, Academic writing & Business writing and can deliver A+ quality writing even to Short Deadlines. I have successfully completed more than 2100+ projects on different websites for respective clients. I can generally write 10-15 pages daily. I am interested to hear more about the project and about the subject matter of the writing. I will deliver Premium quality work without Plagiarism at less price and time. Get quality work by awarding this project to me, I look forward to getting started for you as soon as possible. Thanks!

$55 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

4.3 Online Research Discussion - VT #3 - 351 - Is allium prokaryotic or eukaryotic - Social work skills resume - Jonathan livingston seagull part 4 - NUR495REPLY - Where does chemical digestion start - Walmart case study strategic management - Boxing sponsorship letter sample - Cat sat on mat - Name three substances found in perspiration - A trapezoid with no right angles - What does scroll lock do - Vmware horizon tunnel reconnection is not permitted - X 2 1 n reduction formula - Momentum bar chart - Reading Assignment - Bt vp1000 comms failure - Create dangerously the immigrant artist at work sparknotes - Trending tickers yahoo - The true confessions of charlotte doyle characters - Paper - Nonconsequentialists like ross believe that - Our origins discovering physical anthropology by clark spencer larsen - Skerne medical group sedgefield - Assessment Plan - Powerpoint - Health Information Technology - Patient Care - Quality Improvement - Autocad civil 3d cost - Gc 6 isopropyl alcohol - What does the bible say about homework - Uts internal course transfer - Prepare a plan for digital evidence cases involving divorces - Inventive thinking through triz - Barbara starfield primary care principles - Case study on trait theory of leadership - Kirby drop in refrigeration units - Reasons why we study intercultural communication - What is a dot on stuffdot - Gwen harwood best poems - Week 5 Discission -Motivation - Medicare entitlement statement form - Vision board worksheet for students - Two Section Q & A - Disney Assignment - Characteristics of an agile mis infrastructure - Sensory Detail Memoir - The art of the commonplace - Six major american film genres - Lobbying - Minimum wetting rate packed column - Of mice and men part 2 - Andrew inglis clark studies in australian constitutional law - SOCW 6361 - Physician associate course wolverhampton - Welding symbols australian standard - Is the pirate bay safe - Pacific exploit fv3 mountain bike - Developing ideas penn foster exam - Jackson v murray 2015 - POWERPOINT PRESENTATION - An example of a plot pattern is metaphysical structure. - Summer tri cosamine - Critical Reasoning week 7 Discussion - Powerpoint - Contraindications for facial treatments - Creating Company E-mail and WIFI / Internet Use Policies Attached you will find a description of your final project assignment. - Portable dvd player b&m - Turn the other cheek poe - Community health nursing - In and out burger mission statement - Hersey and blanchard's situational leadership model ppt - Energy forms and changes phet lab answers - Extra linguistic elements of communication - Short answers - Facing it yusef komunyakaa theme - A cash budget by quarters is given below - You will be using 8 test tubes for this experiment - Moshi monsters sign up - Multiple t test prism - C cl polar or nonpolar - Alchemist book review pdf - Columbine 1999 yearbook for sale - Professional networking - Similes in hotel on the corner of bitter and sweet - What is a windshield survey nursing - Andy griffith season 1 episode 4 - DQ w1 650 - Computation - Managerial Economics - I need 300 words homework assignment in Alzheimer Disease - Zubin irani goldman sachs - Marketing - Golf ball survey - What are the six socialization tactics - What impact does probiotics have on population group and overall health - Repeated distribution method cost accounting - Sweatt model vs swot analysis - Andy brettschneider net worth - Lady shaw building cuhk - Woolworths first aid training