Module C - Designing databases and entity-relationship diagramming. After studying this chapter you will be able to: Identify how databases and spreadsheets are both similar and different; list and describe the four steps in designing and building a relational database; define the concepts of entity class, instance, primary key, and foreign key; given a small operating environment, build an entity-relationship (E-R) diagram.