Development of a New Database Environment | Best Beverages Limited

Added on - 16 Sep 2019

  • 7

    pages

  • 1745

    words

  • 114

    views

  • 0

    downloads

Showing pages 1 to 3 of 7 pages
Page3of9Assignment 1(Home)Plan,Install and Configure aDBMSsolutionInstructionsto StudentsThefollowinginstructionsaretobecarefully readbeforestartingthisassignment.Itisimportanttoclarify anyofthebelowpointswithyourlecturerbeforeattemptingthisassignment.Thishome assignmentmustbecompletedwithinthedatecommunicatedbythelecturerThisassignmenthasatotalweightof41%.CopyingisstrictlyprohibitedanditwillbepenalisedthroughareferralandotherdisciplinaryproceduresasperMCASTPolicies,ProceduresandRegulations.Yourfinalanswershouldbeonesinglefilecontainingalltheanswers.ItshouldbeuploadedtoTurnitInusingMCAST’sofficialemail.TurnitIndetailsshallbeprovidedbyyourlecturer.
CASESCENARIOYouhavebeentasked withthedevelopmentofanewdatabase environmentfor amulti-nationalbeveragecompanynamedBestBeveragesLimited.Thiscompanysupplies itsproducts toseveralcountriesaroundtheworldbutitsmainheadquartersresidein:Sydney(Australia):thisbranchisusedtoadministeralltheresourcesandusersacrossthedifferentbranches.Theserverinthisbranchshouldactasthedomaincontrollerwithoutanydatabaseinstancesinstalled.Moscow(Russia):personnelinthisbrancharetypicallyinvolvedinbuildingandmodifyingdifferentapplicationswhichmakeuseofdifferenttypesofdata.Thepersonnelinthisbranch requirethatfromadatabaseenvironmentpointofview,thedatabasedevelopmentenvironmentisseparatedfromtheproduction environmentwithinthesameserver.(Hint:MakesurethattheappropriateSQLServerversionisused inforeachenvironment)NewYork(America):personnelinthisbranchincludemanagerialpeoplewhoreviewlargeamountsoftheworldwidedata(storedlocally)and requireefficientreportgenerationtosupporttheirmissioncriticaldecisionsmakingprocess.
KU1IdentifyrequirementsforaDBMSsolutionKU4Illustrate theneedformultipleinstances1.Youaretoincludeasinglediagramwhichclearlyspecifiesthefollowingitemsforeachbranchmentionedinthe description:a. Theselected databaseserveredition.b.Theselecteddatabaseinstancenames.c.Theselecteddatabasecomponents.2.Youaretowriteabriefparagraph,inwhichyouclearlyjustifyyourselectionswithregardstothe selecteddatabaseservereditionandcomponentsintheMoscowandNewYorkbranches.3.Theproblemdescriptionsuggeststhatthecompanyhasseveral WindowsServersaroundtheglobewithdifferentdatabaseserversinstalled.Youaretodiscussthereasoningbehindthisdecision.Youaretomentionplausible reasonswhysuch anapproachwasused.AA1CompleteaDBMSinstallation4.Inthissection,you aretoinstallalltherequiredcomponentssothatthedesigndepictedinquestion1isimplementedinavirtualisedenvironment.Youaretomakesurethatallthebelowrequirementsareincluded:a. TheWindowsServersareconnectedviaadomaincontroller(thedomaincontrollershouldbenamedusingyournameinitialsfollowedbyyouridcard.Eg:IfyournameisLukeVella andyouridcardis11295M,thedomainnameshouldbeLV11295).b.Roamingprofilesshouldbeallowedinsuchasystem(hencethesameuseraccountcanbeusedtologondifferentWindowsServers)c.EachWindowsServerhasallthenecessarydatabaseserversinstalled(youshoulduse ameaningfulnameforeachdatabaseserverandincludealltherequiredcomponents)d.Alldatabaseengineinstancesshouldbeaccessiblebothlocallyand remotely.(Hint:Nameddatabaseinstancesrequirespecific configurationsettings tobeaccessedremotely)Note:Forthissection,youaretoincludethefollowingdeliverables
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document