Ashungunie

Ask New Question

About Ashungunie

Posted question : 7

Bought : 5

Member for : 286 Weeks, 5 Days

TOP RATED

Math Expert

3 times

tutor

1 times

SmartExpert

118 times

John

1 times

QuickHelper

10 times

Category > Information Systems Posted 29 Aug 2020 Deadline 30 Aug 2020 My Price 30.00

cis 111

Week 8 Assignment 2: Create an ERD 
 
Database Design Diagram (ERD). The following videos and documents will assist you. 

 

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 drawing 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 by hand, then take one or more pictures of the diagram with your cell phone or laptop camera, place the images into a Word document, and submit the document. Otherwise, if you use software to create the Database Design Diagram, then take one or more screen captures of the diagram, place the screen captures into a Word document, and submit the document. Submissions that are not in .doc or .docx format will not be graded. 
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.

Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills, using the following rubric. 

 

 

 

Attachments:

Answers

SmartExpert
(118)
Status NEW Posted 29 Aug 2020 01:08 AM My Price 30.00

Wee-----------k 8----------- As-----------sig-----------nme-----------nt -----------2: -----------Cre-----------ate----------- an----------- ER-----------D -----------

Attachments

file 1598795458-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
file 1598839844-CIS 111 Week 8 Assignment 2 Database Design Diagram.docx preview (228 words )
A-----------SSI-----------GNM-----------ENT----------- 2:----------- Da-----------tab-----------ase----------- De-----------sig-----------n D-----------iag-----------ram----------- N-----------ame----------- C-----------IS -----------111----------- P-----------rof-----------ess-----------or ----------- 2-----------020----------- E-----------nti-----------ty -----------Rel-----------ati-----------ons-----------hip----------- Di-----------agr-----------am -----------(ER-----------D) -----------ill-----------ust-----------rat-----------es -----------tha-----------t h-----------ow -----------the----------- im-----------ple-----------men-----------tat-----------ion----------- of----------- da-----------tab-----------ase----------- ta-----------ke -----------pla-----------ce -----------and----------- it----------- is----------- a -----------vis-----------ual----------- in-----------ter-----------pre-----------tat-----------ion----------- of----------- an-----------y d-----------ata-----------bas-----------e d-----------iag-----------ram-----------. I-----------t c-----------ont-----------ain-----------s t-----------he -----------bas-----------ic -----------com-----------pon-----------ent-----------/el-----------eme-----------nts----------- wi-----------th -----------the-----------ir -----------cor-----------res-----------pon-----------din-----------g f-----------igu-----------res-----------. -----------The----------- da-----------tab-----------ase----------- wi-----------ll -----------be -----------uti-----------liz-----------ed -----------to -----------sto-----------re -----------und-----------ers-----------tud-----------y's----------- da-----------ta -----------or -----------stu-----------den-----------t d-----------ata----------- in----------- a -----------col-----------leg-----------e. -----------Whe-----------nev-----------er,----------- it----------- ou-----------ght----------- to----------- ha-----------ve -----------the----------- op-----------tio-----------n t-----------o
Not Rated(0)
SmartExpert
(118)
Status NEW Posted 29 Aug 2020 01:08 AM My Price 30.00

Wee-----------k 8----------- As-----------sig-----------nme-----------nt -----------2: -----------Cre-----------ate----------- an----------- ER-----------D -----------

Attachments

file 1598795458-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
file 1598839844-CIS 111 Week 8 Assignment 2 Database Design Diagram.docx preview (228 words )
A-----------SSI-----------GNM-----------ENT----------- 2:----------- Da-----------tab-----------ase----------- De-----------sig-----------n D-----------iag-----------ram----------- N-----------ame----------- C-----------IS -----------111----------- P-----------rof-----------ess-----------or ----------- 2-----------020----------- E-----------nti-----------ty -----------Rel-----------ati-----------ons-----------hip----------- Di-----------agr-----------am -----------(ER-----------D) -----------ill-----------ust-----------rat-----------es -----------tha-----------t h-----------ow -----------the----------- im-----------ple-----------men-----------tat-----------ion----------- of----------- da-----------tab-----------ase----------- ta-----------ke -----------pla-----------ce -----------and----------- it----------- is----------- a -----------vis-----------ual----------- in-----------ter-----------pre-----------tat-----------ion----------- of----------- an-----------y d-----------ata-----------bas-----------e d-----------iag-----------ram-----------. I-----------t c-----------ont-----------ain-----------s t-----------he -----------bas-----------ic -----------com-----------pon-----------ent-----------/el-----------eme-----------nts----------- wi-----------th -----------the-----------ir -----------cor-----------res-----------pon-----------din-----------g f-----------igu-----------res-----------. -----------The----------- da-----------tab-----------ase----------- wi-----------ll -----------be -----------uti-----------liz-----------ed -----------to -----------sto-----------re -----------und-----------ers-----------tud-----------y's----------- da-----------ta -----------or -----------stu-----------den-----------t d-----------ata----------- in----------- a -----------col-----------leg-----------e. -----------Whe-----------nev-----------er,----------- it----------- ou-----------ght----------- to----------- ha-----------ve -----------the----------- op-----------tio-----------n t-----------o
Not Rated(0)
Relevent Questions