Garden Glory Project Interface Design
Justify the decisions you make regarding minimum and maximum cardinalities.
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. Draw the entity relationship diagram erd in crow s foot notation using ms visio 2013 2016. Convert the data model you constructed for garden glory in part b at the end of chapter 4 or an equivalent data model that your instructor provides for you to use into a relational database design for garden glory.
We design luxury garden appliances and stylish outdoor decoration to help our customers express their own personal style. 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. Extend and modify the e r data model to meet garden glory s new requirements.
Note that foreign keys are not shown in data models. 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. 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. Use pdf export for high quality prints and svg export for large sharp images or embed your diagrams anywhere with the creately viewer. Using figures 5 26 and 5 28 as.
Use this data model to complete the following tasks. We are garden glory. Specify tables primary keys and foreign keys.
Document your database design as follows.