Database DesignDiagram (ERD). The following videos and documents will assist you.
Supposea local college has tasked you to develop a database that will keep track ofstudents and the courses that they have taken. In addition to tracking thestudents and courses, the client wants the database to keep track of theinstructors teaching each of the courses.
Use anydrawing package or any other application you know such as Visio, Word,PowerPoint, or another tool to create the Database Design Diagram. Otherwise,you may draw the diagram by hand with pen and paper. If you draw the diagram byhand, then take one or more pictures of the diagram with your cell phone orlaptop camera, place the images into a Word document, and submit the document.Otherwise, if you use software to create the Database Design Diagram, then takeone or more screen captures of the diagram, place the screen captures into aWord document, and submit the document. Submissions that are not in .doc or.docx format will not be graded.
Foreach 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 birthdate.
Foreach course, the college needs to track the course ID, course name, department,quarters offered, sections, and instructor teaching each course.
Foreach 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 eachinstructor is qualified to teach. Additionally, the college needs to trackthe final grades for each student after each course has completed.
Gradingfor this assignment will be based on answer quality, logic/organization of thepaper, and language and writing skills, using the following rubric.
"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."