Week 8 Assignment 2 Create an ERD
Database Design Diagram  (ERD)
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.Â
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.Â
Â
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.
Answers
Status NEW
Posted 30 Aug 2020 01:08 PM
My Price 20.00
Wee-----------k 8----------- As-----------sig-----------nme-----------nt -----------2: -----------Cre-----------ate----------- an----------- ER-----------DÂ -----------
Attachments
file 1598795562-Other Answer Guide.docx preview (334 words )
P-----------lea-----------se -----------ref-----------er -----------to -----------the----------- ex-----------pla-----------nat-----------ion----------- pa-----------rt -----------for----------- th-----------e E-----------RD -----------dia-----------gra-----------m a-----------nd -----------als-----------o t-----------he -----------app-----------roa-----------ch -----------how----------- to----------- so-----------lve----------- it-----------. -----------Exp-----------lan-----------ati-----------on:----------- E-----------RD -----------is -----------an -----------acr-----------ony-----------m f-----------or -----------the----------- En-----------tit-----------y R-----------ela-----------tio-----------nsh-----------ip -----------Dia-----------gra-----------m w-----------hic-----------h d-----------esc-----------rib-----------es -----------how----------- th-----------e D-----------ata-----------bas-----------e e-----------xec-----------uti-----------on -----------wil-----------l t-----------ake----------- pl-----------ace-----------. I-----------t i-----------s a----------- vi-----------sua-----------l r-----------epr-----------ese-----------nta-----------tio-----------n o-----------f a-----------ny -----------dat-----------aba-----------se -----------sch-----------ema-----------. W-----------hic-----------h c-----------ons-----------ist-----------s o-----------f t-----------he -----------bas-----------ic -----------ele-----------men-----------ts -----------wit-----------h t-----------hei-----------r r-----------esp-----------ect-----------ive----------- fi-----------gur-----------es.----------- R-----------ect-----------ang-----------les-----------:Â -----------Ent-----------iti-----------es:-----------Â T-----------he -----------rea-----------l-w-----------orl-----------d o-----------bje-----------ct -----------tha-----------t u-----------sua-----------lly----------- be-----------com-----------es -----------tab-----------les----------- in----------- th-----------e d-----------ata-----------bas-----------es
Not Rated(0)