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

7 levels of tension - Food Safety Discussion - Ucl accommodation what to bring - Collaborative problem solving powerpoint - Unit 4 Assignment Theory Evaluation Paper- d - 380 bus route auckland - Intervention Plan Practice #1: Sample Learners - HIS 121 - Paper - WATCH A VIDEO - Obtain the thevenin equivalent at terminals ab - What is blanket overhead rate - Vector addition of forces lab report - Organizational change cawsey pdf - A zero wage increase again - Repetition of vowel sounds - Validity of secondary sources - References available upon request - Fortinet study guide pdf - Secomea gate manager download - Absolute power to control the internet and its content - Brewer and treyens 1981 original study pdf - Clement hall texas tech - 2 thessalonians 2 6 - 14 in japanese hiragana - Uq activate internet session - Internet service provider network diagram - Need Help To Write Executive Summary And Conclusion - Popular world music by andrew shahriari - Topic 4 DQ 1 - You can grow your intelligence author - Physical exam soap note example - Buzzfeed can you solve this mystery snapchat - Night at the elemens - Unit 3 hhd exam - Complete a Planets Vocab Assignment by Creating one of the following: 1. PowerPoint 2. Sway 3. Word Document - Big mac index china - Mcdonalds north st marys - Reply to each post (Must be 150 words long for each one) in words. I expect perfect APA technique. The minimum requirement is three (3) scholarly sources with at least one (1) source a peer reviewed article published in the last 7 years. - 601 bus timetable adelaide - Honeywell smartfit y plan - Yogurt is tolerated better than milk by many lactase-deficient people because: - Cambridge thinking skills past papers - Oaktreesim micromatic - Whirly corporation’s contribution format income statement for the most recent month is shown below: - Case analysis - American revolution - Introduction to christian ethics crook - Kite streamers wang meng pdf - 5 amp socket symbol - EBP Implementation Scale - Warzewitsch frog - Cloud Computing - 2019 scaling report vce - How is earned value management different than straight financial accounting - Psychotherapy and therapeutic treatment timeline - Simple past tense of catch - Plant cell in distilled water - Inventory that is "in the pipeline" moving from one link to another is - Old testament survey workbook pdf - Genogram projects - Seven old ladies locked in a lavatory - Rehabilitation in schizophrenia ppt - Macewan residence services a risky accommodation - What is modular growth in plants - Cisco telepresence holographic video conferencing - Diagram of the reflex arc - Cryptic clues for christmas carols - What happens on a river bend - Great depression test questions with answers - Ol 421 final project swot - Business Research Paper - Human resource - Terminat hora diem terminat auctor opus translation - How to calculate treynor ratio - Percent acetic acid in vinegar lab - Mlc super abn number - The spider and the fly short story - What is the molarity of a solution prepared by dissolving - Virtual security cloud lab access - Apollo shoes case assignment answers - MGMT discussion - In art the design principle of balance functions to - Well hung and tender - Fragmented ip protocol wireshark - Http www topmarks co uk judaism story of moses - 85 spence street cairns - Backyard Constellations: Observations and Paper - Cirque du soleil competitive advantage - Fair mindedness critical thinking - Assignment - Lazarillo de tormes book answers - Bloomberg businessweek b school connection program - Library Assignment - Roland pinch roller sensor - Assignment on white collar crime - Acc 202 final project presentation to investors - Elmo kills barney song - Rev min to rad s - Explain the principle of least privilege - Biology cells word search