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 xxx Rosenblatt xxxx of xxx components xxxxxxx Data xxxxxxxxxxxx Language xxx which xxxxxx users xx perform xxxxxxxxxx like xxxxxxxxx updating xxxxxxxx and xxxxxxxxxx data xxxx the xxxxxxxx Secondly xxxxxx and xxxxxxxxxx that xxxx in xxxxxxxx the xxxxxxx structure xx the xxxxxxxx including xxxxxx fields xxx relationships xxxxx Subschemas xxx subsets xx the xxxxxx defining xxxxxxxx views xx the xxxx for xxxxxxxxx users xx systems xxxxxx amp 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 amp xxxxxxxxxx Describe x primary xxx candidate xxx secondary xxx foreign xxx and x combi xxxxxx key xxx your xxxxxxxxxxx to xxxxxxx an xxxxxxx of xxxx key xxxx is xxx in xxx textbook xxx Firstly xxxxxxx Keys xxx one xxxxxx way xx identify xxxx record xxxxxx a xxxxx in xxxxx to xxxxxx that xxxxx are xx repeated xxxxxxx of xxx same xxxx for xxxxxxx for x database xx restaurant xx a xxxxxxxx table xxx customer xx might xxxxx as xxx primary xxx ensuring xxxx each xxxxxxxx has x distinct xxxxxxxxxx or xxxx for x university xxxx ours xxx student xx could xx the xxxxxxx key xxx the xxxxxxx table xxxxxxx each xxxxxxx is xxxxxxxx a xxxxxx ID xxxxxx to xxxxxxxxxxxxx them xxxx other xxxxxxxx acting xx a xxxxxx identifier xxxx no xxxxxxxxxxx Tilley xxx 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 xxx Rosenblatt xxxxxxx secondary xxxxx are xxxxxxxxxxx a xxxxx or xxxxxxxxxxx of xxxxxx that xxxxxxxx to xxxxxxxx records xxxxxxxxxxx but xx not xxxxxxxxxxx provide x sense xx uniqueness xxxxx identifying xxxx record xxx it xx often xxxxxxxx for xxxxxxx or xxxxxxxx data xxxxx the xxxx example xxxxxx a xxxxxxxxxx in x student xxxxxxxx the xxxxxxxxx last xxxx could xx a xxxxxxxxx key xxxxxxxx for xxxxxxx retrieval xx records xxxxx on xxx student's xxxx even xx the xxxxx student xx is xxxxxxx Tilley xxx 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 amp xxxxxxxxxx For xxxxxxx in xxx university xxxxxxxxxx table xxx student xx would xx a xxxxxxx key xxxx references xxx primary xxx Student xx in xxx student xxxxxxxx table xxxxxxxx that xxxx enrollment xx associated xxxx a xxxxx students xxxxxx combination xxxx are xxxx a xxxxxxx key xxxxxxxx of xxxxxxxx fields xxx used xxxx a xxxxxx field xxxxxx uniquely xxxxxxxx a xxxxxx Tilley xxx 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 amp xxxxxxxxxx The xxxxxxxxxxxxx describe xxx connections xxxxxxx entities xxxxxxxxx around xxxxx primary xxxxx starting xxxx One-to-One xxxxxxx a xxxxxx instance xx one xxxxxx relates xx exactly xxx instance xx another xxxx how xxxxxx can xx interlinked xxxx MANAGER xxxxxx amp 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 xxx Rosenblatt xxxxxxx Many-to-Many x N xxxx the xxxxx two xxxx type xxxx enable xxx instance xx the xxxxx entity xxx relate xx many xxxxxxxxx of xxx second xxx vice xxxxx for xxxxxxx STUDENT xxx CLASS xxxxxxx apart xxxx three xxxxx types xx entities xxxxx discussed xxxxx are xxxxxxxxxxx Entities xxxxxxxx to xxxxxxxxx a xxxxxxxxxxxx relationship xxxx are xxxxxxxxxxxx entities xxxx have xxxxx own xxxxxxxxxx and xxxxxxxxxxxxxxx Tilley xxx 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 xxx Rosenblatt xx a xxxxxxx using xxx we xxx develop x blueprints xxx creating xxx physical xxxxxxxx structure xxxxx can xxxxxx communicate xxx intended xxxxxxx to xxx stakeholder xxxx data xxxxxx References xxxxxx S xxx Rosenblatt x J xxxxxxx analysis xxx design xxxxxxx LearningMore Articles From Information Technology and Administrative Management
.ico)
.ico)
.ico)
.ico)
