Prototype

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 30  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).

Don't use plagiarized sources. Get Your Custom Essay on
Prototype
Just from $13/Page
Order Essay

 

SECTION 1

Data Fundamentals Overview

 

Section Beginning (Dark Color Option )

1

Fundamental relationship

Relationship between two entity types

A person, place, or thing “acts” upon something to complete ”x” (i.e. purchase a product)

Binary Relationships

Salesperson

Product

 

Sells

 

2

Represents the maximum number of entities that can be involved in a relationship.

One-to-One Binary Relationship

One-to-Many Binary Relationship

Many-to-Many Binary Relationship

Cardinality

 

3

The minimum number of entity occurrences that can be involved in a relationship.

“inner” symbol on E-R diagram (“outer” symbol is cardinality)

 

Modality

Everyone order has exactly ONE customer AND Every customer has one or more ORDERS

 

4

Associate occurrences of an entity type with other occurrences of the same entity type.

 

Unary Relationships

 

5

A single occurrence of one entity type can be associated with a single occurrence of the other entity type and vice versa

1:1 Relationships

Student

Student ID #

 

6

Use “crow’s foot” to represent the multiple association.

“many” = the maximum number of occurrences that can be involved, means a number that can be 1, 2, 3, … n.

 

1:M Relationships

Company

Product A

Product B

Product C

 

7

“Many” can be either an exact number or have a known maximum.

 

M:M Relationships

Musicians

Albums

Musicians

Musicians

 

8

Involves three different entity types

Ternary Relationships

 

9

Describes the relationship between two entities.

Used with many-to-many relationships.

Represented on E-R diagram as an “associative entity”

 

Intersection Data

 

10

Entities can have attributes; many-to-many relationships can have attributes.

Many-to-many relationship may be treated similarly to entities in an E-R diagram.

 

Associative Entity

 

11

SECTION 2

Data Modeling Creation

 

Section Beginning (Dark Color Option )

12

A diagramming technique

Diagrams entities (with attributes) and the relationship between the entities.

There are many variations of E-R diagrams in use.

 

The E-R Diagram

 

13

Entity Relationship Diagram Basics

Entity type’s attributes are shown below the separator line.

PK and boldface denote the attribute(s) that constitute the entity type’s unique identifier

 

Rectangular shape

OBJECT = a type of entity

Name of entity is in caps above the separator line.

 

 

14

In an ER diagrams, common practice is to a convention that entity type and relationship type names are uppercase letters, attribute names have their initial letter capitalized, and role names are lowercase letter

Data Definition & Naming Conventions

 

15

SECTION 3

Assignment

 

Section Beginning (Dark Color Option )

16

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

 

Tools

Visio

Visual Paradigm Online

SQLDBM

Draw.io

ERDPlus

Lucidchart

Essay Writing Pros
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

Our writers have been trained on how to handle papers placed by our clients. The writer must read and understand before embarking on writing the papers. In case of any issue that needs clarification, writers are encouraged to ask the client or support.

Professional and Experienced Academic Writers

Our team comprises of the best writers and editors. We do thorough vetting during recruitment to make sure that our writers have the knowledge and experience we aspire in the team.

Free Unlimited Revisions

Our aim is to give the client the best outcome. If for some reason you are not satisfied with the wok done, you can ask the paper to be revised or rewritten. This will be done to your satisfaction with no extra charges.

Prompt Delivery and 100% Money-Back-Guarantee

We have writers who work round the clock. This helps in making sure that all our clients’ papers are delivered on time. If we have issues with the deadline, we will ask for extension. If its not possible, the money is fully refunded.

Original & Confidential

Our clients’ confidentiality is highly respected. We can never disclose our clients’ details to third parties. In the same regard, we strive to give our clients 100% original papers. We do not tolerate plagiarism from our writers.

24/7 Customer Support

Clients can reach us any time of the day, and any day of the week. There is a live chat, email or phone numbers to help in ease of communication.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

You should never be worried about your papers even in the middle of the night. Our team will work round the clock to deliver.

Essays

Essay Writing Service

We have an able team that can deliver your work in the shortest time possible. The academic level or the type of work should never be a hindrance. Our highly competent support team is always around (24/7) to give you any assistance you may need.

Admissions

Admission Essays & Business Writing Help

Do you need to be admitted in your dream institution but find it challenging to write an admission essay? Our team is in a position to write the best letter that will guarantee you an admission. We do as well write the best business proposals and reports.

Reviews

Editing Support

Writing can be fun and enjoyable when everything has been done right. Writing is not just enough without proper editing and proofreading. We have a team of editors that ensure everything falls in place, whether its issues to do with grammar or referencing styles.

Reviews

Revision Support

Once the paper has been done and submitted, that is not the end of it. You can always ask for amendment or improvement if you feel something has not been done right. Our team of writers and editors will gladly assist you to your satisfaction. Revision is free of charge.