Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an E-R diagram to represent a sample customer order based on the data shown in the following figure. You must give a name and

Draw an E-R diagram to represent a sample customer order based on the data shown in the following figure. You must give a name and attributes for each entity type.

image text in transcribed

PVF CUSTOMER ORDER ORDER NO: 61384 CUSTOMER NO: 1273 NAME: Contemporary Designs ADDRESS: 123 Oak St. CITY-STATE-ZP: Austin, TX 28384 ORDER DATE: 11/04/2014 PROMISED DATE: 11/21/2017 \begin{tabular}{|l|l|c|c|} \hline \hline PRODUCTNO & DESCRIPTION & QUANTITYORDERED & UNITPRICE \\ \hline \hline M128 & Bookcase & 4 & 200.00 \\ B381 & Cabinet & 2 & 150.00 \\ R210 & Table & 1 & 500.00 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Oracle APEX 5 Application Development

Authors: Edward Sciore

2nd Edition

1484209893, 9781484209899