Study Guides (247,929)
Canada (121,167)
CS 338 (6)
Final

Study Guide for Final Exam CS338.pdf

6 Pages
268 Views
Unlock Document

Department
Computer Science
Course
CS 338
Professor
Khuzaima Daudjee
Semester
Winter

Description
CS338FinalExamReviewALTXerWKongEChapter1IntroMetadatadatabasedenitionsandinformationaboutthedatabaseCharacteristicsoftheDBapproach1selfdescribingnature2insulationbetweenprogramsanddatadataabstraction3multipleviewsofthedata3sharingofdataandmultiusertransactionprocessingProgramdataindependencestructureofhowdataisstoredindependentfromprogramsthataccessitProgramoperationindependenceindependenceoffunctioncallsrelativetotheirimplementationDataabstractionallowstheabovetwoConceptualrepresentationofdatanodetailsofhowdataisstoredorimplementationofoperationsEgAdatamodelmaybeusedasaconceptualrepresentationViewsubsetofdatathatisderivedfromdataoftheDBbutisnotexplicitlystoredTransactionsisolatedoneatatimeandatomicallornothingDBAauthorizecoordinateacquireDBdesigneridentifychoosestucturesSysAnlystdeterminereqsAppprogrmrsimplementthroughprogsEnduserscasualnaiveparametricsophisticatedstandaloneAdvantagesDeNormalizationredundancycontrolsecuritybackupandrecoveryGUIsrelationshiprepresentationTypesofIntegrityConstraints1Referentialdependentexistence2KeyUniqueness3BusinessRules4InherentdatamodelrulesegNULLsInferencingdeductiveDBsystemsadhoctriggershappensafteranupdatestoredproceduresChapter2DBMSClientServerarchitectureChefCustomerrelationshipDataModelscollectionofconceptsthatdescribeadatabasesstructureallowsdataabstractionbasicoperationsandsetstatevalidity3categorieslowphysicaldetailedusesaccesspathsandindiceshighconceptualusualandrepresentationalenduserscanalsobesplitbetweenrelationalandobjectoriented3SchemaArchitecture1Internalphysicaldescription2ConceptualdescribewholeDB3ExternalViewselectivesubsetforendusersDataIndependenceCapacitytochangeschemaatonelevelofDBNwithoutchangingthenextSplitintologicalvsphysicalTieredarchitecturesextralayersbetweenclientandservercommunicationDBMSclassicationcriteriadatamodelnumberofusersnumberofsitesaccesspathscostOtherslidesarebroughtupagaininotherchaptersChapters3to5KeysSQLDegreenumberofattributesinarelationCardinalitytotalnumberofvaluesindomainUnderstandthefollowingnotationRAAAvtAtA123iiiSuperkeydistinctidentierKeyminimalsuperkeycandidatekeyPrimarykeyUniquekey2KeysForeignkeysaresuperkeystheyrequiretotalparticipationMoreIntegrityconstraints1FunctionalICs2SemanticICs3StateICs4TransitionICsWewillignorethesectiononSQLandEREERdiagramsasthesehavebeenwellstudiedforthemidtermandduringassignments1
More Less

Related notes for CS 338

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit