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
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).
Data Fundamentals Overview
Section Beginning (Dark Color Option )
Relationship between two entity types
A person, place, or thing “acts” upon something to complete ”x” (i.e. purchase a product)
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
The minimum number of entity occurrences that can be involved in a relationship.
“inner” symbol on E-R diagram (“outer” symbol is cardinality)
Everyone order has exactly ONE customer AND Every customer has one or more ORDERS
Associate occurrences of an entity type with other occurrences of the same entity type.
A single occurrence of one entity type can be associated with a single occurrence of the other entity type and vice versa
Student ID #
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.
“Many” can be either an exact number or have a known maximum.
Involves three different entity types
Describes the relationship between two entities.
Used with many-to-many relationships.
Represented on E-R diagram as an “associative entity”
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.
Data Modeling Creation
Section Beginning (Dark Color Option )
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
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
OBJECT = a type of entity
Name of entity is in caps above the separator line.
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
Section Beginning (Dark Color Option )
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).
Visual Paradigm Online
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!
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.
You should never be worried about your papers even in the middle of the night. Our team will work round the clock to deliver.
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.
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.
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.
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.