Fantastic Fireworks Company ER Diagram and Database

Fantastic Fireworks Company ER Diagram and Database

Entity Relationship Model for Fantastic Fireworks Company

Relational Data Structures for the ER diagram

Table Individual Customer

Individual Customer (Contact, Address, City, Postal Address, Delivery Address, E-mail, Phone Number, Cell Phone Number)

Table Organizational Customer

Organizational Customer (Organization Name, Organization Type, Contact Name, City, Postal Address, Delivery Address, E-mail, Website URL, Phone Number, Cell Phone Number)

For both the Individual Customer table and Organizational Customer table location address and work phone number are always recorded. Postal and delivery addresses and mobile and home phone numbers are sometimes not available so these are optionally recorded



Table ...