Create an ERD. Database Design Diagram (ERD). The following videos and documents will assist you. https://www.youtube.com/watch?v=QpdhBUYk7Kk , https://www.youtube.com/watch?v=-CuY5ADwn24 , https://creately.com/blog/diagrams/er-diagrams-tutorial/
Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.
Database Design Diagram Use any application you know such as Word or PowerPoint to create the Database Design Diagram. The software you use to create the Database Design Diagram, take one or more screen captures of the diagram, place the screen captures into a Word document.
For each student, the college needs to track the student ID, student names, addresses, start date, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, and birth date.
For each course, the college needs to track the course ID, course name, department, quarters offered, sections, and instructor teaching each course.
For each instructor, the college needs to track the instructor ID, name, address, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, birth date, and the courses that each instructor is qualified to teach. Additionally, the college needs to track the final grades for each student after each course has completed.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post erd creation appeared first on Essay Writers.
