@[toc](DesignDB Outline) ## Conceptual Database Design ## Presents students with the knowledge to design a database, including the representation of database concepts and associations as Entity Relationship (ER) diagrams and the mapping of this conceptual design to a relational database schema.  ---------- ### Design: What is Conceptual Design?  ---------- ### ER Diagram: Overview of Entity Relationship Diagrams.  ---------- ### Entities: What concepts are to be stored in the database?  ---------- ### Relationships: How are the concepts related?  ---------- ### Mapping: How are ER diagrams mapped to tables?  ---------- ### More Diagrams: Alternative approaches to the ER Diagram.  ---------- ### Checkpoint: Quiz yourself on another example - click the Show ERD button to see the ER diagram.  > 20 multiple choice and True-False questions provide a formative self-assessment component for the learner. ---------- ## Pedagogy ## Besides assigning the formative self-assessment with a performance goal for participation credit, the use of a cooperative learning exercise in class is highly recommended. The database design [cooperative exercise][1] consists of 2 parts: 1. Given requirements, draw an ER diagram 2. Given an ER diagram, map it to a relational database schema The requirements for drawing an ER diagram emphasize entites, relationships, and their corresponding cardinality and participation constraints. The ER diagram to map is not related to the requirements given in part 1. Note that in the class discussion, students can describe the requirements that are illustrated by the ER diagram to be mapped. ## Source ## The OSF FLEX Source Code folder contains the exported Flash Builder project for DesignDB: [DesignDBMain.fxp][2] [1]: https://osf.io/wxe8y/ "DesignDB Cooperative Exercise" [2]: https://osf.io/p2e34/ "DesignDB Source Code"