sql数据库课业案例英文版文档格式.docx

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