Make sure you draw in all the necessary entities, attributes, and relationship lines. Make sure you are selecting the correct cardinality for your lines.

(if you have any questions please describe them clearly)

PETUNIA'S GARDEN Invoice #: Date: Employee: 101 8/23/202 Betr Customer Name: Jane Doe Account Number: xxxx-XXXX-215 Item 1 2 3 4 5 Description Flat Dwarf Gold Marigolds Lavendar Rose Bush Boxwood Bush 1 Gallon 15 lb. Red Mulch 1 Pint Cherry Tomato Quantity 1 1 4 3 4. $ $ $ S Price Per 13.95$ 25.955 14.95 $ 2.59 $ 3.59 $ Price 13.95 25.95 59.80 7.77 14.36 Subtotal $ 121.83 Tax 7.31 Total $ 129.14 This photo by Unknown Author's licensed under CC BY-SA VISIT US ONLINE AT WWW.PETUNIASGARDEN.COM Petunia also tells you that customers can be in the database without ever placing an order. An order must have at least one item on it, quantities must be greater than zero and not all items in her store sell. Lastly, you ask Petunia if she would like any other enhancements to the database. Petunia mentions how she would like to be able to search for all the products she sells by category and that these category names should remain consistent. Too often she is looking for a particular item in the spreadsheet that has multiple spellings for one category name. PETUNIA'S GARDEN Invoice #: Date: Employee: 101 8/23/202 Betr Customer Name: Jane Doe Account Number: xxxx-XXXX-215 Item 1 2 3 4 5 Description Flat Dwarf Gold Marigolds Lavendar Rose Bush Boxwood Bush 1 Gallon 15 lb. Red Mulch 1 Pint Cherry Tomato Quantity 1 1 4 3 4. $ $ $ S Price Per 13.95$ 25.955 14.95 $ 2.59 $ 3.59 $ Price 13.95 25.95 59.80 7.77 14.36 Subtotal $ 121.83 Tax 7.31 Total $ 129.14 This photo by Unknown Author's licensed under CC BY-SA VISIT US ONLINE AT WWW.PETUNIASGARDEN.COM Petunia also tells you that customers can be in the database without ever placing an order. An order must have at least one item on it, quantities must be greater than zero and not all items in her store sell. Lastly, you ask Petunia if she would like any other enhancements to the database. Petunia mentions how she would like to be able to search for all the products she sells by category and that these category names should remain consistent. Too often she is looking for a particular item in the spreadsheet that has multiple spellings for one category name