Sure, here's a programming assignment using a supermarket system: Using the relations created for Programming Assignment in Unit 1, create an E-R diagram that shows the entities, attributes, and relations of the supermarket software system. Utilize a graphics tool or Database Modeler tool to create an E-R diagram. A free tool that can be used is DIA, which is available at http://dia-installer.de/download/index.html.en. You can also use any tool that can produce a standard E-R diagram. Your tool must be capable of displaying the standard format of entities and relationships as illustrated in the Pedersen, A. A. (n. d.) in Figure 1. Figure 1: Example E-R diagram. Reprinted from Entity Relationship Modeling Principles (p. 24) by A. A. Pedersen, n. d. Some valid tools include DBModeler, Microsoft Visio, PowerPoint, OpenOffice Draw, OpenOffice Impress. Whichever tool you use, you must be able to copy your results into a Word document for your final submission. If you use either OpenOffice Draw or Impress, you will need to get arrows for your connecting lines that have the standard 'crows' foot notation used in E-R diagrams. In the supermarket, there are several entities and relationships that need to be modeled, including: Customer Product Order Payment Employee Each entity must include appropriate attributes and primary keys. Each relationship must be labeled with the cardinality of the relationship, and the unary relationship must be described. Your assignment must include the following: An Entity Relationship (E-R) diagram that defines the relations and the relationships between them. Each entity must include appropriate attributes and primary keys. Each relationship must be labeled with the cardinality of the relationship. The unary relationship must be described. Be sure to copy images and paste them directly into your document. It would be recommended that you document your relations in the manner used in the example assignment provided in this unit.