sql数据库课业案例英文版文档格式.docx
《sql数据库课业案例英文版文档格式.docx》由会员分享,可在线阅读,更多相关《sql数据库课业案例英文版文档格式.docx(13页珍藏版)》请在冰豆网上搜索。
DataAnalysisandDesign
Tutor:
*****
Name:
AssignmentTitle:
Alargesupermarkettransactiondatabase
AssignmentNumber:
two
DateDue:
2013-1-16
Contents
Scene3
Task13
Task24
Task311
Bibliography11
Scene
Asthesupermarket'
sbusinessexpansion,containsalotofinformationanddatamanagement,today,therearealotofsupermarketmanagementsystemisfirststarted,hasnotevenusingcomputersforinformationmanagement.Data-processingworkload,datarange,easilylost,prone,anddifficulttofind.InGeneral,thelackofsystematicstandardizedinformationmanagementtools.
Basedonthisquestion,itisnecessarytoestablishasystemofsupermarketmanagement,supermarketmanagementstandardization,systematization,programmed.Weneedadatabaserequirementanalysis,designaccordingtouserdemandarationaldatabase.
Task1
Understandingofthedatamodelanddatabasetechnology
1.1Identifythestructureofthedatamodelandexplaintheirpast,present,andfuturecontributionstothedevelopmentofthedatabase.Whyamodelwillbephasedoutandreplacedbyanewmodel.
Thedatamodel(DataModel)istheabstractionofthedatacharacteristicsofteachingintheformofdatabasemanagementframework.Inthebeginning,thedatamodelonlybeunderstoodasadatastructure.
Hierarchicalmodelstructureissimple,easytoimplement,veryefficientforcertainapplications,butneedtodynamicallyaccessdata(suchasaddormodifyarecordtype),efficiencyisnothigh.Inaddition,forsomenon-hierarchicalstructure(suchasmany-to-manycontact),theexpressionlevelmodelisrelativelymorecomplicatedandnotintuitive.
Meshmodeliscomparedwiththehierarchicalmodel,providinggreaterflexibility,moredirectlydescribetherealworld,betterperformanceandefficiency.Thedisadvantageofthemeshmodeliscomplexstructure,theuserisnoteasytograsp,recordsinvolvingtheadjustmentofthelinkpointertypecontactchanges,expansionandmaintenancearemorecomplex.
Theconceptoftherelationalmodelisclearandsimplestructure,entities,entitycontactandqueryresultsarerelations,said,theuserisrelativelyeasytounderstand.Inaddition,theaccesspathtotherelationalmodelistransparenttousersandprogrammersdonotcareaboutthespecificaccessprocess,reducetheworkloadofprogrammershavebetterdataindependenceandsecurityconfidentiality.Therelationalmodelalsohassomedisadvantages,insomepracticalapplications,thequeryefficiencyoftherelationalmodelissometimesnotasgoodashierarchicalandmeshmodel.
1.2Studyonthefilesystem(FileBasedApproach)andthedatabasemanagementsystemDBMS(databasemanagementsystems)andtheircontributionstodatabasetechnology.
Stageinthefilesystem,dataisstoredexternally,centrallymanagedbytheoperatingsystem.Andsystemsprovideaseparateinterface.Distinguishbetweenthedocument'
slogicalstructureandphysicalstructure,separationproceduresanddata,dataandprogramhasacertaindegreeofindependence.User'
sprogramsanddataonamemorycanbestoredindependentlyinthefield,andeachcanshareasinglesetofdata,enablingdatasharing,andfile.
Thedatabasemanagementsystemtothedatacenteroforganizationaldata,reducetheredundancyofthedatagreatly,toprovideefficientdatasharingcapabilities,thesystemalsorequiresprogramsanddatahasahigherindependence,whenthelogicalstructureofthedataischanged,doesnotinvolvethephysicalstructureofthedatanotaffecttherunningoftheapplication,andcanreducetheapplicationtothedevelopmentandmaintenancecost.
DatamininggenerallyreferstoautomaticallySearchhiddenfromthelargeamountofdatawhichhasaspecialrelationship(Associationrulelearning)process.Dataminingisusuallyassociatedwithcomputerscienceandstatistics,onlineanalyticalprocessing,informationretrieval,machinelearningexpertsystem(relyingontheruleofthumbinthepast)andpatternrecognition,andmanyothermethodstoachievethesegoals.
1.3Studynewdevelopmentofdatabase,suchasdatamininganddatawarehousing,relationship-objectdatabase.
Datawarehouseshavealargenumberofcasesinthedatabase,inordertofurtherminingofdataresourcesandtodecision-makingneeds,itisnottheso-called"
largedatabases"
.Datawarehouseconstructionoftheaimoftheprogrammerwastofrontthequeryandanalysisasabasis,becauseoflargerredundancy,sorequiremorestorage.
WebdatamanagementisundertheWebenvironment,efficientprocessingofcomplexinformation,convenientandaccuratequeriesforinformationandpublications.
Task2
Designarelationaldatabasebasedonuserneeds
Aninformationmanagementsystemasthebackgroundoftheirownchoice,accordingtouser