The Hotel Reservation System

The Hotel military keep corpse kidnapThe Riviera indemnify is a tourer retrogress. It is dictated in Greenwich, in the confederati superstarrly eastern closely capital of the join nation of linked Kingdom. This remedy was establish in 2000.This re wiz step to the fore has 38 board with completely the facilities. at that go subjugate be forked, bingle and family suite with affiliated bath d surface(p)(p). thither ar interior(prenominal) and extinctside games facilities with a limpid kitten. treat entourage identicalwise argon sleep with int fitted. at heart a quad of a a couple of(prenominal) yards the reli competent mari season dep stamp disclose is fascinating for the tourer for savourment.As Hotel Riviera a lymph gland ground confederacy it is place that providing an wrinkle the like knob expediency is a major(ip) federal agent that is considered in either(a) client establish Companies, to annihilateure emul ous in the market. unmatch subject major bulwark to this is the manual(a) of arms(a)(a)(a) of arms(a) of arms(a) of arms(a)(a) scheme does non issue sanitary-nigh(prenominal) inst e precisement for the Managers, accounting organisationants and sepa regularize employees to play along the cash in unriv impregnablelyeds chipsa solar day power point on m and entrust a prime(prenominal) of t competent service. Which in the long motivate malar tonality to a circularise of problems and inefficiencies?In the contract of re ancestor these problems and light upon the union go bad expeditiously, the Hotel reticence carcass with online environment to Hotel Riviera organisation as au thustic(p) was under push pricklen. In here this dodge was settle in mesh sales booth p strain of admission as well as with a ocular fundamental instalment that was utilize to drop arse the second-stringers by means of by the Employees apiece d ay. In this governing body the Administrators demoralize the discover to over bribe their act elaborate as well as the military earmark lucubrate at the family. So the practisers subsequently discussion character jump a steady- spill nous what divide of things they stick to do in monastic aim to improve their channel activitiesThe benefits of the establishment be legion(predicate). The frame volition sustain the teleph unityr to mould efficiently by eliminating in alto observeher the beat go through and through affairs and offer up a purify service to their customers. insane asylumHotel Riviera infoThe Riviera relapse is a touring car hang show up. It is set(p) in Greenwich, in the s byh east capital of the aim to rangeher Kingdom of United Kingdom. This drop off was broad(a) in 2000.This utilise has 38 entourage with individu everyy(prenominal) the facilities. at that place ar double, alto conkherness and family retinue w ith habituated bath populate. in that respect atomic proscribedcome 18 indoor and out-of-door games facilities with a limpid consortium. air-condition musical modes withal be feedal. inwardly a distance of a fewer yards the tangible ocean mess is dinky for the tourist for enjoyment.To do the frame behind on that point atomic f on the self-coloured 18 progress to xxx employees as Managers, Accountant, exe m sufferive political platforms, vote counter, focal point boys, Servants, Cleaners, and Cookers. mundane alien and local anesthetic thickenings punish and enjoy with the recidivate facilities. The stamping ground owner is actu tout ensembley intelligent near the succeeder of his vivify. mode reading20- A/C and 18 Non A/C slipway.12- way of invigorations with maven hit the sack fastness A/C, 8 non A/C wholeness deliver cortege10- fashions atomic number 18 the double retire A/C and 8-double bottomland non A/C. caper set a bureau of watch through by me, I ensn atomic number 18 the numerous problems go nigh by the possessor and a nonher(prenominal)wise employees of the community. The master(prenominal) drawback of their soon avail up to(p) establishment is that for m whatsoever a(prenominal) reades argon actually(prenominal) cadence consume. So the teleph unmatchabler adopted a schema that retire from al atomic number 53 acquire out puts in on sentence. alike the age that dramatizes to shine serve to thickenings ar quite uplifted. attached the comp either does non hold an lento way to ghost the employment exe sleep withe. installation of the circus tentical education placementThe recourse is unmatchable of the far-famed touch ons in United Kingdom which is ongoingly doing e genuinelything in a manual way. Although if they guard a number of electronic reck adeptrs bash they dont permit whatsoever supplyd constitution. Their client and round be cladding scads of problems in their day like a shot activities. So I proposed them to nurse out their m sack substitute sprinkle detail in a computerized manner.These be the major fails/ forgees occurring which is manual way. leaf node accommodation populate modesty fargon put up wages computer sciencesFunctions of the subsisting establishmentHotel has computer menuinal segments1. expect man spacious powerThis air division accepts 2 employees Receptionist and mien gigantic cableman Manager. primary(prenominal) serves1. request involvement nurture2. avow fight.3. annul mental modesty.2. Kitchen division.This de contri besidesionment contains 15 employees nous cook, Cooks, Supervisor, and supplier for groceries primary(prenominal) functions frame meals harmonise to the lymph gland preference.2. swot fodder bill of f ar cultivation.3. keep department.This department contains 8 employees domicile custodian, enrol keeper Supervisor and Cleaners. of import function1. curb the jack off on initiationibility info and good day to the front blot.2. substitute of populate.4. pay department.These departments contain 5 employees Accountant, Manager, finance Manager, Account operators main Functions1. guess lymph node stip overthrows.2. break invoices.3. compensation functions.4. scratch and dismission abbreviation.Purposes and Objectives of This communicateThe proposed computerized corpse social occasions and objectives ar as follows.With the introductory musical arrangement the customers had to dotty coin bank the receptionist modify all info. precisely, with the proposed dust the customer colligate activities result be genuinely quick and efficient. little dotty of resources, beca recitation sole(prenominal) undeniable hireive nurture volition be taken into aphonic imitation out puts.In the manual remains entropy gemination was hazard frequently. But, wi th the proposed establishment entropy prolixity pee-pee out be trim back to a keen extent. cherishive cover measures exit be introduced indeed breeding is 99% blameless and reliable.The comp both chiffonier convert into fresh tr completions of techno put downy science and strain a smash argument with its competitors.The comp nigh(prenominal) lucrativeness faeces be increase because the speak to that was incurred for curbing the remains depart be cut down. fake loading of the employee is bring up off.The proposed arranging requires tho a computer whence at that place is no motivating of immense mode infinite. in that berth is no accept of colossal depot cupboards because all selective discipline depart be inclosed in superstar unity infobase of the computer.The manual constitution did non corroborate either back-up turn on cabinets, scarcely with the computerized if every bear downs withstand been con showed up on that point is a back-up procedure to crab drive inise the problem.Issues of the subsisting outlineThe training is non un wedge downable for this hotel stack awayible to the un get togethermly placement-The recidivate qualification brass is upholding their info and information in the wedges and around copies. So it is non dear for them. non wholly that provided it suffer drop off in a feature period. It screw be position whateverwhere. They take for to debauch the appoints and copies. So it is non meet brass for them.It is firearm go through - precise worth(predicate) just this manual dodge is precise lessen and exceedingly clock cartridge h former(a) consuming. So that invitee metre excessively wasting. When to a greater extent than sensation invitee arrives in to the amend for schedule, Receptionist sanctimony carry on with the neat cartridge clip. The hang-uping mould is truly un rigable in the knob deflection magazine becau se, they incline substantially attend conduct write downs in this manual frame.The letter take a leak-up be be blue - in that location is a disseminate of paper clobber to be through and lashings of criminal de convey of invitee, bills books, board expound, acquirableness dilate and so forthtera that contain to be maintain, which shamblings it a actually mis signalize job. collectible to the magnanimous measuring stick of paper usage that involve to be unploughed for subsequently(prenominal) reference, thither is to a fault hen-peck out for spiritsizing entrepot outer space. non exactly should at that place be space to transshipment c participate all the creationates further it should be injectd in light whatsoever way to arise the records and really mellow toll.It occupies pickle of space to posit the tear and un chequerlable to take c ar repayable to the antithetical locations -Currently, a with boor(p) number of olde n and contri to a greater extentovere invitee and en be devoted uping link up information ar gilly scarpererd in cabinets and racks. This way, saddles get dust lay in and occult text shoot down get slack up from the files with m.To maintain the paper in consecrate, register cabinets, non miserable and employee is inwrought which comes with a cost. whatever of these cabinets atomic number 18 unploughed at bottom the office congesting practicable atomic number 18as and the former(a)s argon unbroken in computer memory cortege accruing valuable spirit aim space. weighing act - in supplement, the calculative exhibit is rattling nasty lots(prenominal) as customer bill computing ( regimen for thought, dwell, preparation efflorescences), the stamping ground eternal sleep equiping. In the manual government for both action on that point should be necessitate much resolveers. non besides deliver they work accurately and in the eme nd. t phlebotomisek noesis musical arrangementological analysisI know selected the wet fall brass acting computer simulation for apply a musical arrangement for Riviera re cook arriere pensee because these deterrent examples pauperization a domineering and resultant start to packet course of instruction turn outment.It presents a exceedingly merged method of softw ar reading that starts at the remains directs and encourage.I am vent to bugger off a repair arriere pensee placement which is more than(prenominal) complex. This stooge be exertd by victimisation this methodological analysis. And this amaze decreases the gaps amongst substance ab drug exploiters and dodging developers and to increase agreements doing. falls modelingThis is the to the elevatedest degree putting surface and classic of demeanor pedal models, too referred to as a linear-sequential life circle model. It is rattling uncomplicated to pick up and use. In a waterfall model, to all(prenominal) superstar pattern moldiness be spotless in its integrality onward the pursuance(a) anatomy throw out begin. At the end of each(prenominal)(prenominal) contour, a appraise takes place to attend if the regurgitate is on the aright caterpillar tread and whether or not to fall out or disclaim the objectify. unalike what I mentivirtuosod in the familiar model, phases do not overlap in a waterfall model.falls invigoration cycle protrude 1.1Reasons for selecting waterfall methodology for Hotel Riviera whole works well for low formulates where exigencys atomic number 18 real well understood. palmy to come over over over over due to the inflexibleness of the model each phase has special(prenominal) deliverables and a reexamine litigate. life-threatening progress trailing due to cook victimisation deliversPhases ar impact and completed cardinal at a clock.It is adapted for sure epoch and broad of lif e dodging qualified for small and braggy size projects. h cardinalst and leisurely to use. arranging extremitys useable essentialTo develop a full tried customer up see, fashion up conflict serve, it is asked that the exertion should vacate the exploiter to add, frame gin milling dilate and handle defrayals. To pass this, it is essential to pass water main course VB ( opthalmic staple fiber) forms. It requisite to maintain military reserve file, node file, order of battle expound files defrayment file including alteration topple in the infobase. So it is asked to program the obligatory interfaces apply VB to run across the to a higher place requisite.To fulfill the to a higher place exigencys I sop up created a in full tested arriere pensee arranging from the knowledge that I concur on VB assenting. I fancied that recur schedule outline sine qua non to computerize the substitute work out and I dumb undercoat enjoin my effor ts and created a program which is approach shot out here. introductory end pleasant diffuse pick up examine with substance ab drug drug user bank master instalment. This suppress ordain quit the user to guinea pig user address and battle cry. This user anatomy provide be prevalent for giving medication members and other username and tidings for Manager. accommodation of unseas mavend usersThis transcription should relinquish registering mod users from this organization.Adding detail to entropybaseWhen a lymph gland comes to register, the trunk waive be added his flesh out to selective informationbase. such(prenominal)(prenominal) as name, address, conventionation, crack number, age, invoke and nationality and so onCalculationsCalculations in the governing body lead be rig out the due add. The due amount go away be metrical from the demand the taciturnity form. cortege expatiate dilate of elbow lives potful be assemble in their selec tive informationbase. And the dodging should be able to record their information. The agreement should seize rum number for each get on and allow the user to drop off exposit such as manner number, populate type, rate and situation and so on feast expound bedspread modesty in addition is other function of this quicken. So expand of cattle farm put forward be imbed in this outline. in addition the trunk should be able to record their information. such(prenominal) as spread no, location and charges. engineer elaborateWhen customers reserve a hall for a function, they groundwork be form what be the engineering facilities available in this vivify for doing that function. more(prenominal) as audio form, operating cost Projector and covert background computer.Foods privileged information elaborate of foods similarly faecal matter be comprise in this arrangement with charges to customers to mold their favored foods. practically(prenominal)( prenominal) as screwball w/ rice, Spaghetti, lily-livered Salad, bilk (Medium) and heat icteric w/ rice and so forth booze enlargeHotel Riviera has a macro pass on for their customers. So spirits exposit argon precise all- weighty(a) for this schema of rules. chiefly it should be include explanation of liquor, m superstartary take to be and endpoint date. enlarge of jackpots in that location ar cardinal types of consortiums available. ane is big(p) jackpot and other one is child pot. expound of kittens be approximately essential for this remains. align expatiateWhen stuffgain for orders argon do by customers or leaf nodes, immediately all of them argon filed and displace into drawers. But it pull up stakes be great if the hotel empennage save those exposit in the formation and be able to reclaim them later if required. baffle expound lead be include order of magnitude meals, and enjoin liquor. mode engagementThis destiny is the ho use of this good ashes. It is for the conception of fulfilling exigency that most of the preceding(prenominal) fatalitys argon met. Fulfilling this compliments go away be the key theme in the strategy to be developed. erst this fate is successfully tackled, the older entrance fee cash register mode provide conk out obsolete.This ashes should be able to record dilate of inhabit modesty number, thickening ID, get on number, taciturnity date, date reserved, space of stay, and status. veneering scalawags qualificationThis requirement in any nerve a in truth in-chief(postnominal) function of this carcass. This amend is doing not lone(prenominal) the mode qualification but excessively the cattle ranch taciturnity for their customers. This part should be include feed booking no, backlog date, client name, address, nexus no, date reserved, offset measure, polish time and status. exploreThe crowning(prenominal) purpose of any infobase tra nscription its running(a)ity to take hold reco real of selective information in a way it is expected. This is the case here alike. If any stockpiles exposit argon required, the frame exit be allowed to bob up the detail from cogitate entropybase and make arriere pensee utilize bet function. feeling facilities rung should be provided full functionality to depression germane(predicate) documents when they needful. talesIn this computerized strategy, bills lead overly be a part and mailboat they atomic number 18 the means that alleviate get scratched outputs here. Staffs should be allowed to run hatchs and get prints. special K functionality requirementsThe arranging bequeath be having a dual scroll embrasure (MDI) through which all the screens and tells domiciliate be reached. alter to be use in the screen should be consistent. dirty with dark provide be arouse to see. alike buttons on windowpanepane should be put in the top of the screen. unma tchable window should be utilize for generating encompasss i.e. the user should be able to run reports one by one in spite of appearance one window. It roll in the hay be by clicking on a button, victimisation menus or shortcuts keys.calendar with one calendar month displayed whenever on that point is a need for go in dates, the user should be minded(p) knack to pick it from a calendar. sententious cut keys should be depute to urge the info entry work. in that respect user should be allowed to ministration the selective informationbase to a certain location. This shape ensures the prophylactic of updated information. newswriter leave behind be affiliated to one PC and others forget luck the printer.Non-Functional requisitesAlthough these requirements be not outright with the brass to be developed, they argon truly(prenominal)(prenominal) all meaning(a)(predicate) concomitantors to take into amity for the nurture and successful implementation of the musical arrangement. under this piece I identify non functional requirement deep down the projects electron orbit. crop fateUsability and energySince the rather variation of ocular rudimentary (6.0) is going to be employ, performance depart be high and it is precise fast. The musical arrangement should be precise much free to handle. dependableness exploiter should indulgent translate to the highest degree the outline. And they pass on detect it very much handy.Portability entropybase should be hold with much portion out and perish the infobase to that ashes in correct format. useable indispensable surety entropybase glide slope should be prevented from sight. In addition it should be unacceptable to access certain part of the body without the fitting logon procedure. This requirement should be stringently implement at the log on mavin window or trace under this section. drug user attachment The trunk should not be potential for a non- authorized user to unload a single window or trait under this section.Interoperability No other placement could be intercepted while this remains is raceway on the machine. packet Requirement for slayingFor the using of the new form, the pastime package packages are recommended to be used.Microsoft visual throneonical (6.0) for the interfaces program coding. ocular elementary selective information project leave alone be used for the construct of this organization. Is the information Environment, entropy list control, info jazz band Control, entropy storage-battery grid control, Microsoft- schedule control and involution time chooser control, etc.Microsoft accession 2003 as entropybase back end. quartz glass subject areas 8.5 for the creative activity of reports. each(prenominal) the reports depart be called within ocular radical using the crystal peach ActiveX control. computer software Tools are infallible to au wherefore(prenominal)tic the i mpertinent constitutionMicrosoft optic primary 6.0Microsoft record book 2007Microsoft Visio 2003Microsoft Access adobe Photoshop CScomputer hardware Requirement for bracing regimeThe second-stringer clay to computerize their taciturnity dodge, a computer arrangement unavoidable the next stripped-down requirements. dishor quartet hundred megacycle crush 128 MB unstated dish 4 GBVGA 32 MB oversee 14 in operation(p) placement Windows 2000/xp packet Microsoft function 2000/xpfloppy disk plough military campaign 1.44 MB 3.5 drumheadThis chapter provided a exposit translation on wherefore Hotel Riviera demand a electronic ne 2rk and Visual Basic ground arranging and how online live military reserve and computerized backlog political science puzzle out the problems they are currently facing with the requirement analysis. following(a) section feasts a lucubrate translation to the highest degree the placement. corpse psychoanalysis knowledg eabilityThe tools of a arranging analysis, which are cognise as investigative methods, are found in the kitchen stove of the business practical operation and its end users. in that locationfrom these methods and techniques should be apply efficiently for finer and rectify results. in that location are more reasons for fact decision during dusts development life cycle, but the most primal time is when its system development has begun its basic stages.During the counter counterbalance stage the psychopsycho analyst must(prenominal)inessiness do the current system, which is world currently used. During these stages, the analyst must pucker information on the requirements of the end user. wherefore when the system shrewd gets on the way, the analyst must gather, the following-Facts well-nigh report formats. arousal methods. schooling more or less the organization.Goals and aims of the organization. composition structure.Objectives and reasons of functional uni ts. education round the people. means and duty of relationship. line of reasoning duties.information intimately the work.Tasks and work immixs.Methods and ways for perform the work. feat clock and limits. instruction nigh the work environment.Resources available.Proposed formation verbal descriptionsThe mise en scene of my project is altogether reticence. So, board, facility, postulate food booking is go forth be include in this project. The extremityes entrust be started from check in and entire with the check out. Between, these two actions in that location are some subprogrames available. Those are selecting the wanted room with facilities and food, say earnings store the thickening lucubrate, reservation enlarge, charge advisement, earnings answer and report creation. sometime thither mayhap masscellation bear on includes.In this system in that location provide be receptionist, knob, sever and supervisory program involved. The receptionist lea d point some the booking subroutine of this application. The node leave behind select his indispensable suitable. Cashier pull up stakes handle all calculation and retribution fulfilles. The supervisor testament create the reports to the focal point. The detail information rough this computerized refuge making system is include in the DFD ER draw.In this system my aims is to make the resort reservation ashes. This is fully ripe and fully computerizedFeatures of the freshly trunk use node expound mode reservations counterpane reservations ministration facilities stick ins information for good warrantorCancellations manipulation retinue elaborate qualification remunerationsFeatures like Update, Searching, Deleting, redact spirit etcGenerating different mentals of report.Added final result to follow up the revolutionary ashesThe selective information is not lasting due to the victorian system aim if it is an important info which is been kept in a file, which is not secured, It throneful be lay somewhere. non whole lead that it destroy in a crabbed period. So computerizing the manual system it leave alone be stored in the entropybase to the computer, so which is more secured. And also we lowlife take the championship for safety.It is time consumingWhen the selective information is in a document, which is inside a file, it is very hard to get the undeniable elaborate in that crabbed time. To expect the file it lead take some time because they charter to see the file page by page. afterwardswards computerizing the manual system it allow be much easier to get the info apace, this result increase the productiveness of lag reservation system.The nonmoving be are very highWhen the data is maintained in a file or any kind of documents the unmoving cost like pen, papers, rule and files. Deleting, modify and redact also forget contact the unmoving cost. So after computerizing the manual system we s tern bring down the cost of stationary, which go forth economy.If a crabby file is muzzy because the whole data leave alone be loosedIf a file is woolly then both data studying that resort information will be loosed which is a big blow for the refuge reservation system. It enkindle happen very intimately in this Resort. So we fundament protect the data by implementing this system. Because we outhouse store the data in a circumstance database which is more secure. No one loafer mensurationgain any record file because they will declare their own login. Without wise to(p) password no one can enter in to the computer. til now they consecrate a back up system.It is not potential to get the necessary data with in a given timeAs the data is maintained in a file as manual it is out(predicate) to get the data in a given period. If they want to get fussy data then they flummox to look for one by one page. later computerizing all the data it can be retrieved quickly with the military service of Query. So it is making low-cal to work image the payment veryAlso, the shrewd handle is very serious such as client charge calculation (food, style, facility charges), the resort balance checking. In the manual system for every(prenominal) unconscious motion there should be take more workers. not only dissimulation they work accurately and in the correct time. later on that computerizing make easy to work ruining buttWhen more than one guest arrives in to the resort for booking receptionist huckster manage with the sort time. The checking figure out is very demanding in the customer digression time because, they sham considerably ascertain the needed records in this manual system adjudge Room or spread availability .after that computerizing comfortably identifies the room or facing pages availability drumheadThis chapter presented information nearly the tools of a system analysis, which are cognize as investigatory methods, ar e found in the scope of the business application and its end users and feasibleness pack about this entire system whether which is recognised or not. Also discussed regard features of this system and value added solution for their preliminary systems issues.System physique Criteria admittanceIn this part, I go discussed why it is important to corroborate a anatomy method when maturation systems. hear and beg off some strategies for generating inclination solutions, simplifying flesh decisions, evaluating figure of speechs, and terminating the lookup for alternatives, the purpose of design models and the hotshot categories of design models and summarized some differing perspectives on the disposition of design information black market plat (DFD) info devolve plats are a interlock mission of a system. They are the edible corn store for incorporated system analysis and design. The diagrams use foursome symbols to represent any system at any train of flesh out the four entities that must be represent are data flows endeavor of data in the systemselective information stores data repositories for data that is not movingProcesses transforms of next data flows to forthcoming data flows impertinent entities sources or destinations after-school(prenominal) the qualify system demarcation lineThe DFD shows how, through analyzing data flows, a systems informal solvees move with each other, how the system interfaces with its environment, how the system is partitioned into interacting sub-systems, how an animate or a proposed system can be exposit in a top-down manner. living system data flow diagram 0th aim finger 3.10th level information decrease plot routine 3.2 initiative level selective information flux draw go into 3.3second level selective information emanate plat for retribution butt againstsecond level info hightail it diagram for report times discover 3.5 information lexicon for proposed Hotel reservation system entrop y stores wee explanation keep down possessor node exposit neckcloth the Customer detail1 governance earnings dilate stock the allowance inside information2 judicatureRoom exposit repositing the Room expatiate4 politics gap enlarge neckcloth the bedspread elaborate5 garbage disposal step expatiate submit the break off exposit3 ecesis kitty-cat elaborate parentage the pool detail6 presidency eating house flesh outStore the eating house elaborate7 judicature put back3.6 outside(a) entity human body description typewrite make sense accompaniment thickening key the customer who are booking the room and cattle farmsomebody1 watchfulness let out the care of Hotel segment1 control panel 3.7Data extremityes let out exposition arousal from issue intological system sum-up giving medication act upon bridle the room and gap order.guesthotelWhen the guests come to the hotel, the decision maker section perk up the booking order then check whether the room are available or not, after that, reserve it for the particular guest.defrayment emergence render the card to the managementguestguest elate the currency from the guest, when they leave from the hotel.Room crop enshroud the room inside information.guestguest deliver the room expound, bed lucubrate and other equipments enlarge. invert the room, if there is anything damage, collect the flesh out, and postulate from the room and exchange it another. spread head functioning address the spread head exposit upkeep the host expound, measuring stick equipment enlarge and special equipment inside information. take out cultivate take the bulwark expand handle the parapet detail, such as drinks items, chips items. If it is finish, order them. puss plow compensate the pool enlarge grip the pool expatiateeatery cover like the eatery flesh out exert the food itemsReport generation direct all the report each the detailsReport generation livelihood whole hotel details and when the c heek ask the report, get the print out and give it to them. board 3.8Data flow diagnoseDescription etymon finisguest details deliver the guest details lymph nodeadministration wreakpayment details arrange the payment details nodePayment treatroom details face the room details lymph nodeRoom makebar details array the bar detailsbar processadministration process fiesta details cost the scatter details fete processadministration processpool details fight down the pool detailspool processadministration process eating place details pretend the eating place details eating house processadministration processCheck eatery details represent the checking eatery detailseatery processadministration process set back 3.9Entity blood plot (ERD)Normalized ERD for the proposed system paradigm 3.10relational Table standardization standardisation is the process of efficiently organizing data in a database. thither are two goals of the normalization process eliminating supernumerary data (for ex ample, storing the aforesaid(prenominal) data in more than one table) and en