第1页共148页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第1页共148页APROJECTREPORTONXXXXXXXXXXSubmittedtoOsmaniaUniversityforthepartialfulfillmentoftherequirementfortheAwardofDegreeforXXXXXXXXXXXXXXXXXXXXXXXXDonebyMr./Miss.XXXXXXXXXXXInstituteofManagement&ComputerSciencesHyderabadCERTIFICATE第2页共148页第1页共148页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第2页共148页ThisistocertifythatMr.XXXX,bearingRollNo.XXXXXXXXXXXhavedevelopedSoftwareprojecttitledXXXXXXXXforxxxSOFTWARESOLUTIONSasapartialFulfillmentfortheawardoftheDegreeofXXXXXXX.HEADOFDEPARTMENTPRINCIPALXXXinstituteofManagement&ComputerSciencesEXTERNALACKNOWLEDGMENT第3页共148页第2页共148页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第3页共148页MyexpressthanksandgratitudeandthankstoAlmightyGod,myparentsandotherfamilymembersandfriendswithoutwhoseuncontainedsupport,IcouldnothavemadethiscareerinXXXX.Iwishtoplaceonmyrecordmydeepsenseofgratitudetomyprojectguide,Mr.XXXXX,xxxSoftwareSolutions,Hyderabadforhisconstantmotivationandvaluablehelpthroughtheprojectwork.ExpressmygratitudetoMr.XXXX,DirectorofXXXXXInstituteofManagement&ComputerSciencesforhisvaluablesuggestionsandadvicesthroughouttheXXXcourse.IalsoextendmythankstootherFacultiesfortheirCooperationduringmyCourse.FinallyIwouldliketothankmyfriendsfortheircooperationtocompletethisproject.XXXXXXX第4页共148页第3页共148页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第4页共148页ABSTRACT第5页共148页第4页共148页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第5页共148页ThisprojectisaverypopularandwidelyusedinmanybigSupermarketsDepartmentalstoresandisusedtocatertheneedofthesalessystemthere.Thisisanonlinesystemandisusedmaintain/controlmostoftheactivitieshappeninginbigstores.Thismaintainsandcontrolsthestockdetailsanddoesonlinebillingandgeneratesvariousonlinereports.Theprojecthasbeenplannedtobehavingtheviewofdistributedarchitecture,withcentralizedstorageofthedatabase.Theapplicationforthestorageofthedatahasbeenplanned.UsingtheconstructsofMS-SQLServerandalltheuserinterfaceshavebeendesignedusingtheASP.Nettechnologies.Thedatabaseconnectivityisplannedusingthe“SQLConnection”methodology.Thestandardsofsecurityanddataprotectivemechanismhavebeengivenabigchoiceforproperusage.Theapplicationtakescareofdifferentmodulesandtheirassociatedreports,whichareproducedaspertheapplicablestrategiesandstandardsthatareputforwardedbytheadministrativestaff.Theentireprojecthasbeendevelopedkeepinginviewofthedistributedclientservercomputingtechnology,inmind.Thespecificationhasbeennormalizedupto3NFtoeliminatealltheanomaliesthatmayariseduetothedatabasetransactionthatareexecutedbythegeneralusersandtheorganizationaladministration.Theuserinterfacesarebrowserspecifictogivedistributedaccessibilityfortheoverallsystem.TheinternaldatabasehasbeenselectedasMS-SQLserver200.Thebasicconstructsoftablespaces,clustersandindexeshavebeenexploitedtoprovidehigherconsistencyandreliabilityforthedatastorage.TheMS-SQLserver200wasachoiceasitprovidestheconstructsofhigh-levelreliabilityandsecurity.ThetotalfrontendwasdominatedusingtheASP.Nettechnologies.Atallproperlevelshighcarewastakentocheckthatthesystemmanagesthedataconsistencywithproperbusinessrulesorvalidations.Thedatabaseconnectivitywasplannedusingthelatest“SQLConnection”technologyprovidedbyMicrosoftCorpora...
