- Identify all involved in the database system so your ERD accurately â€œcapturesâ€ the entire process, actors, and relationships (e.g., staff, patients, suppliers, carriers, etc.).
- Identify and list entities and attributes for each entity.
- Make sure you designate an attribute to serve as a primary key per each entity. Explain why that attribute â€œdeservesâ€ to be designated a primary key.
- Briefly define business rules. (Example: One patient canâ€™t schedule more than one appointment at a time.)