Question: I need help to fix my errors in my ERD diagram. ERD is about system delivery. I got issues that i have to consider all

I need help to fix my errors in my ERD diagram. ERD is about system delivery. I got issues that i have to consider all the FKs in Items table and not null. like

What if a customer only buys gold , then how to handle the rest of PKs' values.

i need to have the superclass and subclass concept for those items. i have to

create a superclass that is associated with items and subclasses with unique attributes.

i should have major relationships that will be associated with the superclass.

my other issue is delivery table, it needs a relationship with CUSTOMER.

Supplier shipping Item to Customer.

the diagram is below, I couldnt download the image.

https://www.draw.io/?client=1&title=Copy%20of%20Untitled%20Diagram.pdf#LSSRm

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!

I need help to fix my errors in my ERD diagram. ERD is about system delivery. I got issues that i have to consider all the FKs in Items table and not null. like What if a customer only buys gold ,...

Project Management Casebook David I. Cleland, Karen M. Bursic, Richard Puerzer, and A. Yaroslav Vlasak Library of Congress Cataloging-in-PublicationData Project management casebook /edited by David...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona. MovinOn provides a truck, driver, and one or more moving assistants to move residential...

CIS-336: Lab 3: Building the Physical Model LAB OVERVIEW Scenario and Summary The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model...

Scenario and Summary The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

FastFit Sporting Goods is a successful New England regional supplier of sporting goods to the high-end consumer market. They sell an exclusive selection of equipment and apparel to men and women who...

Chapter 2 User-Centered Systems Design: A Brief History Abstract The intention of this book is to help you think about design from a user-centered perspective. Our aim is to help you understand what...

Consider the project dependency matrix and activity durations in days provided below. URRERE A1 A2 A3 A4 A5 A6 A7 AB A9 A10 A11 A12 Duration A1 . X X 5 AZ X A3 X X A4 X AS X 11 A6 X X 5 A7 X 2 AS 3 ....

Box office revenue at a multiplex cinema in Paris is R(p) = 3600p 10p3 euros per showing when the ticket price is p euros. Calculate R(p) for p = 9 and use the Linear Approximation to estimate R if...

LG ( 4 ) E 5 - 4 Your firm has the option of making an investment in new software that will cost \ ( \ $ 1 3 0 , 0 0 0 \ ) today but will save the company money over several years. You estimate that...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

=+6 Who is the peer of the IA ?

=+herself to in terms of equity with regard to this assignment?

=+ What typical employee will the IA compare him/