Description
Please I need help with my assignment
One of the main objectives of this class is to help you identify relationships between different pieces of data in a database to better understand how databases are set up and operate. For this assignment, you will do just a couple of simple things: Pick a business or organization that uses a database such as an online retailer, a doctor’s office or a brick and mortar business. Identify two important entities associated with that business/organization. Under each entity, make a list of 3 attributes that could be associated with that entity. Identify the relationship between the two entities (one-to-one, one-to-many or many-to-many) and indicate the nature of the relationship (which has one, which has many, i.e., one customer can have many appointments but each appointment can only have one customer).
Explanation & Answer
Attached.
Running Head: ENTITIES AND RELATIONSHIPS IN DATABASE OUTLINE
Entities and Entity Relationships in Database OUTLINE
Name
Institutional Affiliation
1
ENTITIES AND RELATIONSHIPS IN DATABASE OUTLINE
B2W Company
•
B2W is an e-commerce company that offers online retail services to customers.
•
B2W was formed after the merger between Submarino.com and Americanas. Com.
•
The main competitors of B2W include Cnova, Amazon, Mercado Libre, and Walmart.
Purpose Statement
•
The purpose of this paper is to examine the database entities and attributes utilized by
B2W in order to establish the relationship between those entities.
Entities in B2W
•
The two entities in B2W database include employee entity and customer entity.
•
A customer entity contains attributes such as email address, surname, customer ID/or
order ID, telephone number, and postal address.
•
Employee entity contains attributes that include employee ID, name, health plan
enrollment, and work location.
Relationships between Entities
•
Using entity-relationship model, the employee entity at B2W is identified using one-toone (1:1) and one-to-many (1: M) (McGrew & Cohen, 2017).
•
For a customer entity, B2W only use one-to-one.
•
For example, a customer named (A) is associated with only one customer ID (B
Nature of Relationships
2
ENTITIES AND RELATIONSHIPS IN...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Flowers For Algernon
by Alice Walker
Ethan Frome
by Edith Wharton
Into the Wild
by Jon Krakauer
Hidden Figures
by Margot Lee Shetterly
The Red Badge of Courage
by Stephen Crane
Shattered - Inside Hillary Clintons Doomed Campaign
by Amie Parnes and Jonathan Allen
A Farewell To Arms
by Ernest Hemingway
Narrative of the Life of Frederick Douglass
by Frederick Douglass