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

Pangea jigsaw puzzle worksheet - American registry of pathology - City two point perspective - Dr mark nesselson pediatrician - Medical report about improvement system for practical issues, a computer related task or function in an area of healthcare that is relevant - Learning Strategies for Success - General mills acquisition of pillsbury from diageo plc - Nine basic physical abilities - Amazon delays opening of cashierless store to work out kinks - African discussion - Dikw continuum - Credit analysis and lending management multiple choice questions - Excel quiz - Consider the following discrete probability distribution - Nonverbal Communication TED Talk - Ntcp diamond model project management - Vic uni st albans campus map - 7two escape to the country - Tik Tok - Decision making styles soc 110 - Ecc environmental compliance certificate - Critical assessment template - Cost of capital practice questions and answers - Answer 3 objectives questions - Name three specific consequences of the boston busing crisis - Discussions - 4 year old child observation report - Defusement - Claritas my best segments zip code - English Introductory Outline - Letter from birmingham jail thesis statement - ?same-day +27833173182 Mhlume - Lubombo ABORTION CLINIC // PILLS,,,, - The wallace group case study problems and solutions - Plymouth city council safeguarding - Business location lesson plan - Umuc libs 150 final exam answers - What products should ww grainger carry at a store - PRJ656 Project Management Integration Framework - MC Wk8 - Nspa shower gel boots - How to know your IQ - 219 grand vista cibolo tx 78108 - Difference between ditscap and diacap - The mass of oxalic acid crystals - Scb & associates pte ltd - Precautions - Weather - ART 10000 Question - Fast start bonus doterra - Ralph stayer johnsonville net worth - Select a transaction that effects the accounting equation as follows - HTML programming - Tots video 123 vhs - ____ the format painter button allows it to remain active until you turn it off. - Veltri corporation is working on its direct - Jzzmusic - Chemistry: Temperature and Pressure - Dependents of Phase Equilibria Questions - Australian curriculum studies association - Www nationalgeographic org interactive salem interactive - Moped ignition switch wiring diagram - Research process 8 steps - Collection period for accounts receivable formula - Discussion Board Replies - 44 presidents crossword puzzle answers - Jace is writing a paper for his criminal justice course - How to increase working capital in capsim - The man who invented management - Lpab exam time table - Educational technology - Vce chemistry study design 2020 - Transformation leadership and knowledge and knowledge sharing within an organization - Sociocentric thinking - Bible verse about human resource management - When backing up it is best to____ - Fire safety training questions and answers - Stratco gable homeshed instructions - literature reviews - How do i make a brochure in word - Danske invest hedge fixed income strategies - Is happy a verb - Bathroom floor drain requirement qld - How to find the surface area of an octagonal prism - Assignment 5 employee compensation and benefits - Academic vs technical writing - Independent group design strengths and weaknesses - Forward and backward scheduling ppt - How many prada stores worldwide - Lse general course acceptance rate - Assignment 5: - Determination of the ka for a weak acid lab - Pizza hut hk menu pdf - Atraumatic care in pediatric nursing - Helper - Robert todd carroll becoming a critical thinker - Microeconomics notes chapter 1 - Order 2303487: A True Diary Of a part time indian - Securities exchange act of 1934 auditor liability - Thermal expansion coefficient of ethanol - Code of conduct software - Integrative Intercultural Communication Paper