B2W Company Entities and Entity Relationships in Database Research Paper

User Generated

Ybirivxv90

Business Finance

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

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags