Please create a Relational Schema model given the following EER diagram and briefly describe your thought process.

Primary keys and foreign keys should be correctly identified

Show constraints (in words) over and above referential integrity constraints for each table. E.g., "a transaction cannot exceed $10000" is a constraint on the transaction table and must be checked before a sales transaction can be generated.

PName PBDate PBio PAddress PNationality Date (O,N) M N (O,N) Speed Film F-Stop Color/B&W Resolution (0,N) PHOTO TAKES PHOTOGRAPHER Price TDate TransID TotalAmount CardNo CardType CardExpDate CLUDE TRANSACTION LANDSCAPE ABSTRACT PORTRAIT N (O,N) MAKES ODEL Agency 1(O,N) StreetAddress1 CUSTOMER CAddress LOCATION MODEL City nName CType State Place Password CName Description MBio (MSex Notice: Some composite attributes (e.g. customer name) are represented as simple for simplicity PName PBDate PBio PAddress PNationality Date (O,N) M N (O,N) Speed Film F-Stop Color/B&W Resolution (0,N) PHOTO TAKES PHOTOGRAPHER Price TDate TransID TotalAmount CardNo CardType CardExpDate CLUDE TRANSACTION LANDSCAPE ABSTRACT PORTRAIT N (O,N) MAKES ODEL Agency 1(O,N) StreetAddress1 CUSTOMER CAddress LOCATION MODEL City nName CType State Place Password CName Description MBio (MSex Notice: Some composite attributes (e.g. customer name) are represented as simple for simplicity