Ask a question to Desklib · AI bot

Ask NowBETA

Plan, Install and Configure a DBMS solution Instructions to Students

7 Pages1745 Words85 Views
   

Added on  2019-09-16

About This Document

The personnel in this branch require that from a database environment point of view, the database development environment is separated from the production environment within the same server.(Hint: Make sure that the appropriate SQL Server version is used in for each environment) New York (America): personnel in this branch include managerial people who review large amounts of the worldwide data (stored locally) and require efficient report generation to support their mission critical decisions making process. (Hint: Make sure that the appropriate SQL Server version
BookmarkShareRelated Documents
Page3of9Assignment 1(Home)Plan, Install and Configure aDBMSsolutionInstructionsto StudentsThefollowinginstructionsare tobecarefully readbeforestartingthisassignment.Itisimportanttoclarify anyof thebelow pointswithyourlecturer beforeattemptingthis assignment.Thishome assignment mustbecompletedwithinthedatecommunicatedby thelecturerThisassignment hasatotalweightof 41%.Copyingisstrictlyprohibitedanditwillbepenalised throughareferralandotherdisciplinaryproceduresas perMCASTPolicies,ProceduresandRegulations.Yourfinalanswershould beone singlefilecontainingall theanswers. Itshouldbe uploaded toTurnitInusing MCAST’sofficialemail. TurnitIn detailsshallbeprovidedbyyourlecturer.
Plan, Install and Configure a DBMS solution Instructions to Students_1
CASESCENARIOYouhavebeentasked withthedevelopment ofa newdatabase environmentfor a multi-nationalbeveragecompanynamedBestBeverages Limited. Thiscompanysupplies its products toseveralcountriesaroundthe worldbutitsmain headquartersresidein:Sydney(Australia):thisbranchisusedtoadministeralltheresourcesandusersacrossthedifferent branches.Theserverinthisbranchshouldactasthedomaincontrollerwithoutanydatabaseinstancesinstalled.Moscow(Russia):personnelinthisbrancharetypicallyinvolvedinbuildingandmodifyingdifferentapplicationswhichmakeuseofdifferenttypesofdata. Thepersonnelinthisbranch requirethatfromadatabaseenvironmentpoint ofview,thedatabasedevelopmentenvironmentisseparatedfromtheproduction environmentwithinthesameserver. (Hint:Makesurethat theappropriateSQLServerversionisused inforeachenvironment)NewYork(America):personnelinthisbranchincludemanagerialpeoplewhoreviewlargeamountsoftheworldwidedata(storedlocally)and requireefficientreportgenerationtosupporttheirmissioncritical decisionsmakingprocess.
Plan, Install and Configure a DBMS solution Instructions to Students_2
KU1–Identify requirementsforaDBMSsolutionKU4–Illustrate theneedfor multipleinstances1. Youaretoincludeasinglediagramwhichclearlyspecifiesthefollowingitems foreachbranchmentionedinthe description:a. Theselected databaseserveredition.b. Theselecteddatabaseinstancenames.c. Theselected database components.2. Youaretowriteabriefparagraph,inwhichyouclearlyjustifyyourselectionswithregardstothe selecteddatabaseserver editionandcomponentsintheMoscowandNewYork branches.3. Theproblemdescriptionsuggeststhatthecompanyhasseveral WindowsServersaroundtheglobewithdifferentdatabaseserversinstalled. Youaretodiscussthereasoningbehindthisdecision.Youareto mentionplausible reasonswhysuch anapproachwasused.AA1–Completea DBMSinstallation4. Inthissection, you aretoinstallalltherequiredcomponentssothatthedesigndepictedinquestion1isimplementedinavirtualisedenvironment.Youare tomakesurethatallthebelowrequirementsareincluded:a. TheWindowsServersareconnectedviaadomaincontroller(thedomaincontrollershould benamedusingyournameinitialsfollowedbyyouridcard. Eg:Ifyournameis LukeVella andyouridcardis11295M,the domainnameshouldbeLV11295).b. Roamingprofilesshouldbeallowedinsuchasystem(hencethesameuseraccountcanbeusedtologondifferentWindowsServers)c.EachWindowsServerhasallthenecessarydatabaseserversinstalled(youshoulduse ameaningfulnameforeachdatabaseserverandincludealltherequiredcomponents)d. Alldatabaseengineinstancesshouldbeaccessiblebothlocallyand remotely. (Hint:Nameddatabaseinstancesrequirespecific configurationsettings tobeaccessedremotely)Note:Forthis section,youare toincludethe followingdeliverables
Plan, Install and Configure a DBMS solution Instructions to Students_3

Found this document preview useful?

Related Documents
Assignment - Network Design and Implementation
|31
|1260
|47

Operating System Requirements and Workplace Inspection
|15
|2152
|305

Client/Server Application Components
|23
|5991
|87