Styjun

Labeling matrices/rectangles and drawing Sigma inside rectangle

Can I say: "When was your train leaving?" if the train leaves in the future?

As programers say: Strive to be lazy

How can dragons propel their breath attacks to a long distance

Could there be a material that inverts the colours seen through it?

Help in identifying a mystery wall socket

What are the components of a legend (in the sense of a tale, not a figure legend)?

Why is it harder to turn a motor/generator with shorted terminals?

What's the difference between "за ... от" and "в ... от"?

Extracting sublists that contain similar elements

Why did the metro bus stop at each railway crossing, despite no warning indicating a train was coming?

How exactly does artificial gravity work?

How can a layman easily get the consensus view of what academia *thinks* about a subject?

How much Replacement does this axiom provide?

Is taking modulus on both sides of an equation valid?

correct spelling of "carruffel" (fuzz, hustle, all that jazz)

What are the implications of the new alleged key recovery attack preprint on SIMON?

What are the holes in files created with fallocate?

How do employ ' ("prime") in math mode at the correct depth?

What episode was being referenced by this part of Discovery's season 2 episode 13 recap?

On what legal basis did the UK remove the 'European Union' from its passport?

LWC1513: @salesforce/resourceUrl modules only support default imports

What is the largest number of identical satellites launched together?

Why does my circuit work on a breadboard, but not on a perfboard? I am new to soldering

How do my App, Price and Container tables relate to each other in my ERD?

How to relate keywords to records - Many to ManyE-Comeerce Database ERD Helphow adding a fields to relationship Table in pivot table method using laravelERD database relationship 1 to many or many to manyMS Access - Form and subform based on same table, but different recordDatabase ERD - Junction Table (one-to-many)Rails - multiple relationships between two modelsJPA Relationship Order and ProductRelational model for ERDImplementing relationships with attributes? ER diagram

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have 4 tables:

• Customers


• Applications


• Prices


• Containers

Reulations between those go as follows:

• Each Customer has many Apps.


• Each App has many Containers.


• The User should be able to set the price based on size of Container (Big, Medium, Small).


• Overall price of the App should be shown based on the sizes of containers within the App.

What relationship should be specified between the App, Price and Container tables?

I've tried the following:

• App has_many Prices


• App has_many Containers


• Container has_one price.

However, I just can't seem to get my head around how they all work together.

entity relationship diagram erd

share|improve this question

edited Mar 23 at 13:30

Szymon Maszke

3,2031730

asked Mar 23 at 13:19

Tobias RobinsonTobias Robinson

11

add a comment | 

0

I have 4 tables:

• Customers


• Applications


• Prices


• Containers

Reulations between those go as follows:

• Each Customer has many Apps.


• Each App has many Containers.


• The User should be able to set the price based on size of Container (Big, Medium, Small).


• Overall price of the App should be shown based on the sizes of containers within the App.

What relationship should be specified between the App, Price and Container tables?

I've tried the following:

• App has_many Prices


• App has_many Containers


• Container has_one price.

However, I just can't seem to get my head around how they all work together.

entity relationship diagram erd

share|improve this question

edited Mar 23 at 13:30

Szymon Maszke

3,2031730

asked Mar 23 at 13:19

Tobias RobinsonTobias Robinson

11

add a comment | 

I have 4 tables:

• Customers


• Applications


• Prices


• Containers

Reulations between those go as follows:

• Each Customer has many Apps.


• Each App has many Containers.


• The User should be able to set the price based on size of Container (Big, Medium, Small).


• Overall price of the App should be shown based on the sizes of containers within the App.

What relationship should be specified between the App, Price and Container tables?

I've tried the following:

• App has_many Prices


• App has_many Containers


• Container has_one price.

However, I just can't seem to get my head around how they all work together.

entity relationship diagram erd

share|improve this question

edited Mar 23 at 13:30

Szymon Maszke

3,2031730

asked Mar 23 at 13:19

Tobias RobinsonTobias Robinson

11

share|improve this question

edited Mar 23 at 13:30

Szymon Maszke

3,2031730

asked Mar 23 at 13:19

Tobias RobinsonTobias Robinson

11

share|improve this question

edited Mar 23 at 13:30

Szymon Maszke

3,2031730

asked Mar 23 at 13:19

Tobias RobinsonTobias Robinson

11

edited Mar 23 at 13:30

Szymon Maszke

3,2031730

edited Mar 23 at 13:30

Szymon Maszke

3,2031730

asked Mar 23 at 13:19

Tobias RobinsonTobias Robinson

11

asked Mar 23 at 13:19

Tobias RobinsonTobias Robinson

11