Reference no: EM1353422
Draw an ERD for a database that should track baluster designs, balusters sold, and customer orders for a company that sells various wood balusters. Details follow:
There are various baluster designs to choose from. Each wood baluster design can be offered in various wood species, such as oak, maple, and hickory. However, not all wood species are available to all designs. (Some only come in oak, others come in both oak and maple, still others may have wider wood species selection.) A unique design id is used to denote each design. Not all designs are available to ship to all states. The database needs to store all baluster designs and what wood species are available for each design. In addition, for each design, the database needs to store which states it can't be shipped to.
Each design comes in 5 different lengths: 31", 34", 39", 41", and 44". For each design in each length, an image of the baluster should be stored to give customers more visual information.
Price can vary depending on the design, the wood species, and the length. The database needs to store pricing information for each type of balusters.
Each baluster of a particular design, wood species, and length is assigned a unique baluster id.
When a customer orders balusters, she chooses the design, the wood species, and the length. The database should store all balusters ordered, as well as the quantity and the unit price for each baluster. The database also stores customer's first name, last name, address, phone, and email.
Hint: Since there is a unique design id and a unique baluster id, it's a dead giveaway that you'll need two entities, one for baluster design and the other for baluster. There are of course other entities as well.
|
Explain what do you think would happen to the prices
: Explain What do you think would happen to the prices of goods and services in our economy if all advertising were banned?
|
|
Explain how does marginal analysis affect goods and service
: Explain how does marginal analysis affect goods and services, efficiency, equity, and on market economy.
|
|
Calculate the effective annual rate of interest
: John Fleming has been shopping for a loan to finance the buy of a used car. He has found three possibilities that seem attractive and wishes to choose one with the lowest interest rate.
|
|
Provide constant power to the wheels over a range of speeds
: A more realistic car would cause the wheels to spin in a manner that would result in the ground pushing it forward with a constant force (in contrast to the constant power in Part A). If such a sports car went from zero to 30.0 in time 1.10 , how ..
|
|
Draw erd for database that track baluster design
: Draw an ERD for a database that should track baluster designs, balusters sold, and customer orders for a company that sells various wood balusters.
|
|
Explain how do you think a wbs should be created
: Explain How do you think a WBS should be created and what stakeholders or team members should be involved
|
|
What she hired a fourth worker her total product increased
: When she hired a fourth worker, her total product increased but by only 1,000 bullfrogs. Yolanda pays $1,000 a week for equipment and $500 a week.
|
|
How would the electric force be affected
: A charge of +2q is fixed to one corner of a square, while a charge of -1q is fixed to the diagonally opposite corner. Expressed in terms of q, what charge should be fixed to the center of square, so the potential is zero at each of the two empty c..
|
|
Explain is any outcome generated by a nash equilibrium
: Explain is any outcome generated by a Nash equilibrium not generated by any subgame perfect equilibrium.
|