Using Mysql workbench, design the following database

A. Consider a Bank Database: Each Bank can have multiple branches, and each branch can have multiple accounts and loans. A customer can have multiple accounts and loans. It is necessary to keep track of different types of ACCOUNTS(Savings_Accts, Checking_Accounts.....) and LOANS(car_Loans,Home_Loans.....) Suppose it is desirableto keep track of each account's TRANSACTIONS (deposits, withdrawals, checks........) and each loan's PAYMENTS; both of these include the amount, date and time. Create the EER diagram, Show and Specify the relationship types and constraints on each participation of an entity in a relationship type. Show the attributes of each entity underlining the primary key in each entity. B. Design a database to keep track of information for an art museum. Assume that the following requirements were collected: The museum has a collection of ART_OBJECTS. Each ART_OBJECT has a unique IdNo, an Artist(if known), a Year (when it was created, if known), a Title, and a Description. The art objects are categorized in several ways, as discussed below. ART_OBJECTS are categorized based on their type. There are three main types: . PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate objects that do not fall into one of the three main types. A PAINTING has a PaintType(oil watercolour,etc.), material on which it is DrawnOn(paper,canvas,wood, etc.), and Style(modern, abstract, etc.) A SCULPTURE or a STATUE has a Material from which it was created(wood, stone, etc.), Height, Weight, and Style. An art object in the OTHER category has a Type(print, photo,etc) and Style. ART_OBJECTS are also categorized as PERMANENET_COLLECTION, which are owned by the museum (these have information on the DateAcquired, whether it is On Display or stored, and Cost) or BORROWED, which has information on the Collection(from which it was borrowed), DateBorrowed and DateReturned. The museum keeps track of ARTIST'S information, if known: Name, DateBorn(if known), DateDied (if not living), CountryOfOrigin, Epoch, MainStyle, and Description. The Name is assumed to be unique. Draw an EER schema diagram for this application. Discuss any assumptions made. A. Consider a Bank Database: Each Bank can have multiple branches, and each branch can have multiple accounts and loans. A customer can have multiple accounts and loans. It is necessary to keep track of different types of ACCOUNTS(Savings_Accts, Checking_Accounts.....) and LOANS(car_Loans,Home_Loans.....) Suppose it is desirableto keep track of each account's TRANSACTIONS (deposits, withdrawals, checks........) and each loan's PAYMENTS; both of these include the amount, date and time. Create the EER diagram, Show and Specify the relationship types and constraints on each participation of an entity in a relationship type. Show the attributes of each entity underlining the primary key in each entity. B. Design a database to keep track of information for an art museum. Assume that the following requirements were collected: The museum has a collection of ART_OBJECTS. Each ART_OBJECT has a unique IdNo, an Artist(if known), a Year (when it was created, if known), a Title, and a Description. The art objects are categorized in several ways, as discussed below. ART_OBJECTS are categorized based on their type. There are three main types: . PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate objects that do not fall into one of the three main types. A PAINTING has a PaintType(oil watercolour,etc.), material on which it is DrawnOn(paper,canvas,wood, etc.), and Style(modern, abstract, etc.) A SCULPTURE or a STATUE has a Material from which it was created(wood, stone, etc.), Height, Weight, and Style. An art object in the OTHER category has a Type(print, photo,etc) and Style. ART_OBJECTS are also categorized as PERMANENET_COLLECTION, which are owned by the museum (these have information on the DateAcquired, whether it is On Display or stored, and Cost) or BORROWED, which has information on the Collection(from which it was borrowed), DateBorrowed and DateReturned. The museum keeps track of ARTIST'S information, if known: Name, DateBorn(if known), DateDied (if not living), CountryOfOrigin, Epoch, MainStyle, and Description. The Name is assumed to be unique. Draw an EER schema diagram for this application. Discuss any assumptions made