4.4 Entity Relationship Diagram

The three entities that we chose to show in the diagram are customer, invoice, and product. For the customer entity the attribute types that we chose to include for the different records are customer number, first and last name, the phone number, and their address (including street, zip code, city, state). For the invoice attribute types we chose to include invoice number, customer ID, product ID, date, subtotal, and total. For the product attribute types we chose to include product number, quantity, description, unit price, and total. When we gather enough information from our customers we will make database tables with these attribute types and fill in the records with attributes of those customers. The attributes will be of various data types and we will make relationships with them to connect the three entities.