Week 8 Assignment 2: Generate an ERD (100 Points)
Database Design Diagram (ERD). The forthcoming videos and muniments gain aid you.
Suppose a topical nursery has tasked you to eliminate a database that gain sustain way of tyros and the continuitys that they entertain charmed. In restitution to waying the tyros and continuitys, the client wants the database to sustain way of the educationists instruction each of the continuitys.
Database Design Diagram
Use any plan lot or any other collision you apprehend such as Visio, Word, PowerPoint, or another cat's-paw to generate the Database Design Diagram. Otherwise, you may entice the diagram by employmentman delay pen and paper. If you entice the diagram by employmentman, then accept one or over pictures of the diagram delay your cell phone or laptop camera, fix the images into a Word muniment, and surrender the muniment. Otherwise, if you use software to generate the Database Design Diagram, then accept one or over cloak captures of the diagram, fix the cloak captures into a Word muniment, and surrender the muniment. Submissions that are not in .doc or .docx format gain not be graded.
For each tyro, the nursery needs to way the tyro ID, tyro designates, haranguees, set-out epoch, phone total and types (such as fickle, residence, employment), email haranguees and types (such as specific, train, employment), gender, and rise epoch.
For each continuity, the nursery needs to way the continuity ID, continuity designate, office, quarters offered, sections, and educationist instruction each continuity.
For each educationist, the nursery needs to way the educationist ID, designate, harangue, phone total and types (such as fickle, residence, employment), email haranguees and types (such as specific, train, employment), gender, rise epoch, and the continuitys that each educationist is competent to train. Additionally, the nursery needs to way the developed grades for each tyro behind each continuity has completed.