Question: QUESTION 2: (20 points) Create an ERD diagram for AMAZON website. List out atleast 5 business rules, mention atleast 5 entities, atleast 3 attributes

QUESTION 2: (20 points) Create an ERD diagram for AMAZON website. List out atleast 5 business rules, mention atleast 5 entities, atleast 3 attributes for each entity and mention the cardinalities, PK and FKs using Crow Foot's methodology.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

TruScreen Group Limited (TRU.AX) Ramsay Health Care Limited (RHC.AX) EBOS Group Limited (EBO.AX) Open High Low Close Adj Close Volume 0.022 0.022 0.022 0.022 0.022 0.022 0 Date 16/01/2024 Open High...

Title: Child Cancer Disease Database Final Project Due Day 4 of Week 7 Any instructor feedback provided for assignments previously submittedwhen graded should be incorporated in the final submission....

Jim Watanabe, assistant director of IT for Petrie Electronics, and the manager of the No Customer Escapes customer loyalty system project, was walking down the hall from his office to the cafeteria....

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

below is the ERD digram I need a same new normalized ERD diagram as per the requirements and checklist mention below . 1.The old ERD 2. The new Normalized ERD 3.A summary of the changes that you have...

Needing help with this project anything is appreciated. The model with the relationships is throwing me through a loop. Thanks Database Project Part 1: 150 points Due: See Canvas for Due Dates...

This is my college Database coursework. I have a problem regarding making the erd diagrams and normalization(UNF, 1NF, 2NF, 3NF). I hope you would help me in making this along with the final erd...

please help me answer this question, I promise to upvote on the right answer 01 J14-rroject 1 Due 3/12 Cunho Cum Art ER 2 c 2200 Core SUS 1003 10 RE Bere . 1 2 3 20 Me 14 - > ne Business Rules: Each...

A. Lab # : BSBA BIS245A-2 B. Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database C. Lab Overview Scenario / Summary COs: 1. Given a business situation in which managers require...

The comparative condensed statements of financial position of Conard Corporation are presented on the shown below. Instructions (a) Prepare a horizontal analysis of the statement of financial...

You are given the expected return and standard deviation of Asset 1 and Asset 2: E(R1) = 10%, 1 = 10% E(R2) = 14%, 2 = 16% The correlation between the two assets is p = 0.2. a. Calculate the expected...

find the infinite ( 4 x ^ 5 + 2 x ^ 3 + 2 ) dx a ) non of these b ) 2 0 x ^ 4 + 6 x ^ 2 c ) 2 / 3 x ^ 6 + 1 / 2 x ^ 4 + 2 x + c d ) 2 / 3 x ^ 6 + 1 / 2 x ^ 4 + 2 x

White Company has two departments, Cutting and Finishing. The company uses a job-order costing system and computes a predetermined overhead rate in each department. The Cutting Department bases its...

2. Using C# to write a Windows form application that uses a stored procedure to retrieve employees name, job ID from emp table in SCOTT schema.Write the procedure code first. The procedure uses...

Consider the Cu-Ag phase diagram (Figure 9.7 p. 298). At a temperature of 900 degree C and a composition of 40 wt% Ag, how much of each phase is present? Composition (at% Ag) 20 40 60 80 100 1200...

A centrifugal pump is directly couple to a motor. The pump rating is 3,600 liters per minute against a total head of 8 meters of water. Pump efficiency is 65% at shaft speed of 550 rpm. Calculate the...

Overall score and talk time on telephone are interval or ratio scale and why?

A. Fill-in the blanks Now, it is time to test your memory again! You read the statement below and fill out the missing word/s or group of words. 1. _______________ is the process of determining and...

List five properties of relations.

Which installation strategy would you recommend for PVFs Purchasing Fulfillment System? Which would you recommend for Hoosier Burgers inventory control system? If you recommended different...

Assume that you have a project with seven activities labeled AG (below). Derive the earliest completion time (or early finishEF), latest completion time (or late finishLF), and slack for each of the...

Problem 8 in Chapter 12 involved comparing straight-line regression fits of SBP on QUET for smokers and nonsmokers, and it was found that these straight lines could be considered parallel. Use...

Assume that the data involving the regression of VOTE (Y) on TVEXP (X) in Problem 5 in Chapter 5 came from congressional districts in New York. Now, suppose that researchers selected a second sample...

The data in the following table represent four-week growth rates for depleted chicks at different dosage levels of vitamin B, by sex. Use the information provided in the next table to answer the...