Using the questions found at the end of Chapter in your textbook complete this homework 3537- CoachOnCouch

Information Technology and Administrative Management

Question.3537 - Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document, including an ERD, and answering questions 2, 3, and 4.

Answer Below:

- xxxxxxxx Activity xxxxxx Seven xxxxxxxx Sprecher xxxxxxxx New xxxxxxxxx University xxx Advanced xxxxxxxxxxx Technology xxxxxxxxx Bradford xxxxxx September xx - xxxxxxxx Activity xxxxxx Seven xxxx is x DBMS xxxxxxx describe xxx components xx a xxxx Ans xxxxxxxxx to xx understanding xxxx the xxxxxxxx Database xxxxxxxxxx System xx technically x library xx software xxxxx with xxxxxxxx that xxxxxx users xx interact xxx manage xxxxxxxx it xxxx as x framework xxx organizing xxx storing xxxxxxxxxx and xxxxxxxxx data xxxxxxxxxxx Tilley xxxxxxxxxx Some xx the xxxxxxxxxx include xxxx Manipulation xxxxxxxx DML xxxxx allows xxxxx to xxxxxxx operations xxxx inserting xxxxxxxx deleting xxx retrieving xxxx from xxx database xxxxxxxx Schema xxx Subschemas xxxx aids xx defining xxx overall xxxxxxxxx of xxx database xxxxxxxxx tables xxxxxx and xxxxxxxxxxxxx while xxxxxxxxxx are xxxxxxx of xxx schema xxxxxxxx specific xxxxx of xxx data xxx different xxxxx or xxxxxxx Tilley xxxxxxxxxx Third xxxxx be xxxxxxxx Data xxxxxxxxxx utilized xx store xxx actual xxxx and xxxxxxxx information xxxxx the xxxx in x structured xxxxxx lastly xxxxxxxxxx tend xx provide x way xxx users xxxxxxxx administrators xxxx and xxxxx systems xx interact xxxx the xxxx like xxx structured xxxxx languages xx graphical xxxx interfaces xxx other xxxx to xxxxxxxx with xxxxxxx datasets xxxxxx Rosenblatt xxxxxxxx a xxxxxxx key xxxxxxxxx key xxxxxxxxx key xxxxxxx key xxx a xxxxx nation xxx Use xxxx imagination xx provide xx example xx each xxx that xx not xx the xxxxxxxx Ans xxxxxxx Primary xxxx are xxx unique xxx to xxxxxxxx each xxxxxx within x table xx order xx ensure xxxx there xxx no xxxxxxxx records xx the xxxx kind xxx example xxx a xxxxxxxx of xxxxxxxxxx in x customer xxxxx the xxxxxxxx ID xxxxx serve xx the xxxxxxx key xxxxxxxx that xxxx customer xxx a xxxxxxxx identifier xx even xxx a xxxxxxxxxx like xxxx the xxxxxxx ID xxxxx be xxx primary xxx for xxx STUDENT xxxxx wherein xxxx student xx assigned x unique xx number xx differentiate xxxx from xxxxx students xxxxxx as x unique xxxxxxxxxx with xx repetitions xxxxxx Rosenblatt xxxxxxxx candidate xxx is xxx attribute xx a xxxxxxxxxxx of xxxxxxxxxx that xxxx the xxxx intent xx primary xxxx which xx to xxxxxxxx a xxxxxx within x table xxx a xxxxx can xxxx only xxx primary xxx with xxxxxxx candidate xxxx wherein xxxxxxx key xx chosen xxxx among xxx candidate xxxx Drawing xx the xxxx example xx our xxxxxxxxxx with xxxxxxx and xxx database xxxx the xxxx title xxx ISBN xxxxxx could xx candidate xxxx However xxx ISBN xxxxxx is xxxxxxxxx chosen xx the xxxxxxx key xxx to xxx guaranteed xxxxxxxxxx Tilley xxxxxxxxxx Thirdly xxxxxxxxx key's xxx technically x field xx combination xx fields xxxx employed xx retrieve xxxxxxx efficiently xxx do xxx necessarily xxxxxxx a xxxxx of xxxxxxxxxx while xxxxxxxxxxx each xxxxxx and xx is xxxxx utilized xxx sorting xx indexing xxxx Using xxx same xxxxxxx within x university xx a xxxxxxx database xxx student's xxxx name xxxxx be x secondary xxx allowing xxx quicker xxxxxxxxx of xxxxxxx based xx the xxxxxxxxx name xxxx if xxx exact xxxxxxx ID xx unknown xxxxxx Rosenblatt xxxxxx foreign xxxx are xxxx fields xxxxxx one xxxxx that xxxxxxxxx the xxxxxxx key xx another xxxxx in xxxxx to xxxxxxxxx a xxxxxxxxxxxx between xxx two xxxxxx ensuring xxxx integrity xxxxxx Rosenblatt xxx example xx the xxxxxxxxxx enrollment xxxxx the xxxxxxx ID xxxxx be x foreign xxx that xxxxxxxxxx the xxxxxxx key xxxxxxx ID xx the xxxxxxx enrolled xxxxx ensuring xxxx each xxxxxxxxxx is xxxxxxxxxx with x valid xxxxxxxx Lastly xxxxxxxxxxx keys xxx also x primary xxx composed xx multiple xxxxxx but xxxx when x single xxxxx cannot xxxxxxxx identify x record xxxxxx Rosenblatt xxx example xxxxxxxxxxx the xxxx example xx university xxxxxx a xxxxxxxxxxxx table x combination xxx might xx composed xx the xxxxxxx ID xxx course xx ensuring xxxx each xxxxxxxxx registration xxx a xxxxxxxx course xx uniquely xxxxxxxxxx What xxx entity-relationship xxxxxxxx and xxx are xxxx used xxxx symbol xx used xxx a xxxxxxxxxxxx What xx an xxxxxxxxxxx entity xxxxxxx an xxxxxxx Ans xxxxxxxxx to xx understanding xxxx the xxxxxxxx Entity-Relationship xxxxxxxx ERDs x typically xxxxxxxxxxxxxxx depicting x relationship xxxxxxx entities xx a xxxxxxxx system xx a xxxxxxxxx manner xxxx aid xx designing x database xxx better xxxxxxxxxxxxx and xxxxxxxxxxx wherein xxxxxxxx serve xx the xxxxx component xx an xxx since xx could xx representing xxxxxx or xxxxxx events xx even xxxxxx as xxxx in xxx book xxxxxxxx were xxxxxxxx ORDER xxx PRODUCT xxxxxx Rosenblatt xxx relationships xxxxxxxx the xxxxxxxxxxx between xxxxxxxx revolving xxxxxx three xxxxxxx types xxxxxxxx with xxxxxxxxxx wherein x single xxxxxxxx of xxx entity xxxxxxx to xxxxxxx one xxxxxxxx of xxxxxxx like xxx OFFICE xxx be xxxxxxxxxxx with xxxxxxx Tilley xxxxxxxxxx While xxx second xxxx is xxxxxxxxxxx M xxxxxxx one xxxxxxxx of xxx first xxxxxx can xxxxxx to xxxx instances xx the xxxxxx but xxxxx instance xx the xxxxxx can xxxxxx to xxxx one xxxxxxxx of xxx first xxx instance xxxxxxxxxx and xxxxxxxx Tilley xxxxxxxxxx Thirdly xxxxxxxxxxxx M x like xxx first xxx this xxxx will xxxxxx one xxxxxxxx of xxx first xxxxxx can xxxxxx to xxxx instances xx the xxxxxx and xxxx versa xxx example xxxxxxx and xxxxx However xxxxx from xxxxx major xxxxx of xxxxxxxx being xxxxxxxxx there xxx Associative xxxxxxxx utilized xx represent x many-to-many xxxxxxxxxxxx they xxx intermediate xxxxxxxx that xxxx their xxx attributes xxx characteristics xxxxxx Rosenblatt xx the xxxxxxx ORDER xxxx is xx associative xxxxxx that xxxxxxxx ORDER xxx PRODUCT xx order xx understand xxx use xxxx aid xx visualize xxx data xxxxxxxxx by xxxxxxxxx a xxxxxxx and xxxxxxx representation xx the xxxxxxxxxxxxx between xxxxxxxx and xxxx identifying xxx data xxxxxxxxxx by xxxxxxxxx the xxxxxxxxxxxxx to xxxxxxxx potential xxxx redundancy xxx eliminate xx Tilley xxxxxxxxxx In x summary xxxxx ERD xx can xxxxxxx a xxxxxxxxxx for xxxxxxxx the xxxxxxxx database xxxxxxxxx which xxx easily xxxxxxxxxxx the xxxxxxxx message xx the xxxxxxxxxxx with xxxx models xxxxxxxxxx Tilley x Rosenblatt x J xxxxxxx analysis xxx design xxxxxxx Learning