Create a diagram using a diagramming tool AND provide a written textbased document explaining your relationship mapping systems analysis use

Create a diagram using a diagramming tool AND provide a written text-based document explaining your relationship mapping (systems analysis use case document).
Requirements:
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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

textbook: NEW PUBLIC PERSONNEL ADMINISTRATION ByNIGROREQUIREDEDITION:7TH 14PUBLISHER:CENGAGE LISBN:9781133734284 Explain how Strategic Human Resource Management SHRM discussed in Chapter

textbook: NEW PUBLIC PERSONNEL ADMINISTRATIONByNIGROREQUIREDEDITION:7TH 14PUBLISHER:CENGAGE LISBN:9781133734284Explain how Strategic Human Resource Management (SHRM), discussed in Chapter 3 in Nigro & Kellough (2014), can improve performance of public organizations and addresses critical issues such as recruiting, promotion, organizational needs, and equity and the representativeness of the public workforce?Responses are expected to

Scientists Are Teaching the Body to Accept New Organs

Paper details https://www.nytimes.com/2019/01/22/health/organ-transplants-immune-system.html Introduction/Rationale: Being able to analyze information given to us is a critical and most vital skill in an age where information is being spread irresponsibly with the touch of a button. It’s easy to click “like” or “share” something if we feel that it supports our own

The report is not to exceed 5 pages including a

The report is not to exceed 5 pages including a separate title and reference page and include at least two references in addition to the textbook.  It must be typewritten using Times New Roman 12pt. font, 1-inch margins according to APA Style Guide, 6th ed. Case Study Analysis should not

  This week, you have examined the three dimensions of generalist

  This week, you have examined the three dimensions of generalist practice in social work. For this week’s assignment, using the social problem from Week 1, prepare a PowerPoint presentation for local policymakers explaining how the problem might be impacted by each of the three dimensions. Be sure to illustrate

In Chapter 26 and the accompanying video lessons, we saw

  In Chapter 26 and the accompanying video lessons, we saw the successes of the Civil Rights Movement lead to the advancement of ongoing reform movements designed to improve the lives of youth, women, Latinx peoples, and American Indians. Based on what you have learned, what unfinished work remains to secure the blessings

In this assignment, you will explore the role of cloud

In this assignment, you will explore the role of cloud computing in boosting business intelligence (BI) tools. You will learn about different types of cloud computing architectures that can provide value-adding services for organizations. As a manager, you must understand the different service types needed to run on the different

Toileting and hydration needs.

4-Proposed solutions to my project will be to revise post fall debriefing- such as doing a fall huddle to analyzed the fall and educate staff on what to do. Post fall huddle should be conducted after a fall as soon as possible involving all staffs and even the patient to

M05 – Internet Research Select ONE option and writ a

M05 – Internet Research Select ONE option and writ a minimum of three pargraphs.  1. Visit the Web home page and web site of a manufacturer of interiors products. Research any information available on the site concerning that would be similar to the pricing, ordering, and shipping instructions that would be

Write a program that performs the brute-force attack to break

Write a program that performs the brute-force attack to break the password. The following table shows encrypted passwords using the crypt() function. Your mission is to break the password corresponding your CWID in the table. For example, the last digit of your CWID is 1, then you should identify the

ubmit a word document containing an analysis and a summary

  ubmit a word document containing an analysis and a summary of the completed lab (part A). The word document should contain the following elements: Summary of the lab Analysis of the activities performed in the lab and their importance to the course topics How the lab relates to the