Database

EER to Relational mapping: Illustrate how you translated from the EER diagram to your relational schema. It should follow the EER to Relational algorithm. 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.

An ER Diagram for the Photo Shop Project (O,N) M N(ON)Name PhotolD Date Speed Film F-Stop Color/B&W Resolution PBDate PBio PAddress PNationality (O,N) PHOTO TAKES PHOTOGRAPHER Price TDate TransID CardNo CardType CardExpDate CLUDE TRANSACTION LANDSCAPE ABSTRACT PORTRAIT N (O,N) MAKES MODELS 1 (O,N) BillingAddress StreetAddress1 M 1,N) CUSTOMER StreetAddress2 City State ZipCode CAddress LOCATION MODEL CType Place MName Password CName Description MBio (MSex An ER Diagram for the Photo Shop Project (O,N) M N(ON)Name PhotolD Date Speed Film F-Stop Color/B&W Resolution PBDate PBio PAddress PNationality (O,N) PHOTO TAKES PHOTOGRAPHER Price TDate TransID CardNo CardType CardExpDate CLUDE TRANSACTION LANDSCAPE ABSTRACT PORTRAIT N (O,N) MAKES MODELS 1 (O,N) BillingAddress StreetAddress1 M 1,N) CUSTOMER StreetAddress2 City State ZipCode CAddress LOCATION MODEL CType Place MName Password CName Description MBio (MSex