1. Convert the ER Model below into a relational database The ER model helps maintain a database...

1. Convert the ER Model below into a relational database

Transcribed Image Text:

The ER model helps maintain a database of cookies sold by girl scouts. Number Troop Number Name (0,1) Service Unit (1,n) belongs to belongs to (0,1) (1,n)/ Councit Name Qty (0,n) (0,n) (0,m) (1,n) (1,n) shop sales sells for Price date Date (1,n) belongs to Customer (1,n) (1,n) individual sales (0,n) (1,n) Name Cookie (0,n) contracts Qty Name Address (1,n) Name Address Daisy offers (1,n) (1,n) Girl G,D Member G,D Brownie Senior Junior (0,1) Baker Leader Cadette Name Address The ER model helps maintain a database of cookies sold by girl scouts. Number Troop Number Name (0,1) Service Unit (1,n) belongs to belongs to (0,1) (1,n)/ Councit Name Qty (0,n) (0,n) (0,m) (1,n) (1,n) shop sales sells for Price date Date (1,n) belongs to Customer (1,n) (1,n) individual sales (0,n) (1,n) Name Cookie (0,n) contracts Qty Name Address (1,n) Name Address Daisy offers (1,n) (1,n) Girl G,D Member G,D Brownie Senior Junior (0,1) Baker Leader Cadette Name Address The ER model helps maintain a database of cookies sold by girl scouts. Number Troop Number Name (0,1) Service Unit (1,n) belongs to belongs to (0,1) (1,n)/ Councit Name Qty (0,n) (0,n) (0,m) (1,n) (1,n) shop sales sells for Price date Date (1,n) belongs to Customer (1,n) (1,n) individual sales (0,n) (1,n) Name Cookie (0,n) contracts Qty Name Address (1,n) Name Address Daisy offers (1,n) (1,n) Girl G,D Member G,D Brownie Senior Junior (0,1) Baker Leader Cadette Name Address