DIAGRAM

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 accounts TRANSACTIONS (deposits, withdrawals, checks,............) and each loans 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 OnDisplay 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 ARTISTS 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.