Garden Glory Project Interface Design
Db basics assignment 2 you can edit this template and create your own diagram creately diagrams can be exported and added to word ppt powerpoint excel visio or any other document.
Garden glory project interface design. Draw an e r data model for the garden glory database schema shown in chapter 3 s garden glory project questions use the ie crow s foot e r model for your e r diagrams. Note that foreign keys are not shown in data models. Draw the entity relationship diagram erd in crow s foot notation using ms visio 2013 2016.
Using figures 5 26 and 5 28 as. Use this data model to complete the following tasks. We are garden glory.
Justify the decisions you make regarding minimum and maximum cardinality. Attached is a data model design for the garden glory project questions in assignment 2. They are added in the database design phase.
We design luxury garden appliances and stylish outdoor decoration to help our customers express their own personal style. Justify the decisions you make regarding minimum and maximum cardinalities. Transform the data model to physical model database design.
Extend and modify the e r data model to meet garden glory s new requirements. Try hard or don t try at all. Specify tables primary keys and foreign keys.
Draw an e r data model for the garden glory database schema shown in chapter 3 s garden glory project questions use the ie crow s foot e r model for your e r diagrams.