sql数据库课业案例英文版.docx
- 文档编号:3194934
- 上传时间:2022-11-20
- 格式:DOCX
- 页数:13
- 大小:155.58KB
sql数据库课业案例英文版.docx
《sql数据库课业案例英文版.docx》由会员分享,可在线阅读,更多相关《sql数据库课业案例英文版.docx(13页珍藏版)》请在冰豆网上搜索。
sql数据库课业案例英文版
DataAnalysisandDesign
Coursename:
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- sql 数据库 课业 案例 英文