CCNC/CCNC Module 5/The database application/Database Concepts/Self Assessment

---

Self Assessment

Outcomes

Upon completion of this self assessment the learner will: Assess their understanding of basic database concepts Create an ER diagram from an artifact they are familiar Normalize entities to second normal form Fully attribute the identified entities

Portfolio Activity

Find one or two forms or information sheets from within your school or business. Review these artifacts to determine which you could most easily identify the entities, their attributes and the relationships among the entities. Using a pencil and paper draw an entity relationship diagram of the entities and attributes discovered from the artifact. Review the ER diagram and draw fully attributed entity diagrams to second normal form. Identifying data types for each attribute. Determine which attribute is mandatory and which is optional, makes notes to your rationale.