An example relational database is shown below. This database stores data about wineries and the wine regions they are located. A relational database manages data in tables. There are two tables: the winery table that contains information about wineries and the region table that collects information about wine regions.

Please draw the entity-relationship diagram to illustrate the relationship(s) between/among the entities in the above database.

Please list any TWO attributes of the Region Table.

Please list the primary key and foreign key of the Winery Table.

DBMS users for large and midrange computers, such as DB2, Oracle, or SQL Server, would employ SQL to retrieve the information they needed from the database. Display the results of the below SQL statement: SELECT Winery_name, State FROM Winery, Region WHERE Winery.Region_ID = Region.Region_ID

An example relational database is shown below. This database stores data about wineries and the wine regions they are located. A relational database manages data in tables. There are two tables: the winery table that contains information about wineries and the region table that collects information about wine regions. * Winery Table Winery ID 1 2 3 4 5 Winery name Moss Brothers Hardy Brothers Penfolds Lindemans Orlando Address Smith Rd. Jones St. Arthurton Rd. Smith Ave. Jones St. Region ID 3 1 1 2 1 Region Table Region ID Region name State Barossa Valley South Australia Yarra Valley Victoria Margaret River Western Australia 3 . a)- Please draw the entity-relationship diagram to illustrate the relationship(s) between/among the entities in the above database. + b) Please list'any TWO attributes of the Region Table. + c) Please list the primary key and foreign key of the Winery Table.:- d)-DBMS users for large and midrange computers, such as DB2, Oracle, or SQL Server, would employ SQL to retrieve the information they needed from the database. Display the results of the below SQL statement: SELECT Winery name, State FROM Winery, Region WHERE Winery, Region. ID=Region. Region. ID