only write the backend coding of this

Assesivise bustarnos: In this project, you wit design and implemert an oq-ine databaje drives webeite that can be acceseed both within and outride the orgaricution with propet login prowided. You will work in groupt ef fwo/three for thin assevment Paosery Ocschirnow The Metly Meckenie Marina and its surveundine property ate localed on Gippland Latm it Wentria, the Dean Mackentie own and eperate the Molly Mackeruit Marine. Cumently, the marinars dody operating activeri. to fun the oflice in a more efficient masher, Mr. Machescie hirei you to devigh a writsist for the marina. The rental properties. Current Stuation The Molly Mucherue Marina rests cabers, a vanety of watenoaft, and boar slys to ats cusiomens. When a cistomer tegpests a wabecraft of a cabin, a price qoobe is gives. The arice quobe is hesed on a thily rate. It a rabin er boat sip ter mone than a day, Mr. Mackeryie whll divcosne the daly rate, mating a longer itay more attractive. Cabins can be sensed tor a weelend, week, of month an a rediced rate, Table I shews the dascone codes and their arsocluted percentage discounts. While reserving the property, deposts are collerted on followirg bass: - The depesit is ascled to the rental fees for the property or is lortelted it the cuntoree cancels the reservation. - Mr. Mackentie is ferible on the depons arnount. Mr. Mackensie iequirn a minmum depout trom frecuent cultomers but doei chargw at heffy dopoilt for new cuitomers. for the propectr, minus any depost. - If an adwanced reservation was no made, the cuchomes pars the entire halueser when heriche reves the property. When a customer necuests a parboular property. following actions are carniof eut: - Mr. Mackente, or an employee dheck la see il the propeffy a imalable for the dateri nequeis by the cuitomer. If the requeited dates are imalable, reiereation data are caphlured on a reaterifion form. - Hated on the lenght of stay, Mr. Mackennet determines which rate is apolicable. ascotimetint Arief 4 favel 1 - For a typical reiervation, cutumer contatt information Iname, phone number, and maling addreal. reveration rumber if heline cancal the veservation ar when heluhe checks in. - for a Dypical resereation, cubooner comact inlormabion iname, phone namber, and malleng addretal. tesenatien dames, and propery ieformatien frental property number and ratel, ere recor iod. - When a reservation is made, the customer in civen a rovervation number. The cuntamer uies the tevervation nomber if he/ahe cabcel the relecvation or when fie/she checls in. - When a caymed is made, the payment date payment amount, and any comments are reconded. When the susiamer neturns the watercaft or checis out of the cabin, helywe itses hy the oflice and is given as involce showing hilher rental trancartions. Requirements Centidering the desien of the Marina's mebsibe, pau identfy theee major edmponenta: anturity legon, dpitim maintenance, and mariza managentent. The security logsn component is the gatioway to the whole wyition. A typical login ionem ands the uair for a uieritarne and a paismord. It the user parises this seturity check, the other ports of the acplicatien becomet actersible. The agslem maietenarie purt of the aysen beepr the applications that augport the dita in the database ug to date. Typically, tiriks ifvolved are add inlarmation, edie esheing indermation, or delete inlarmation. Fhe was upplatien has two levels of nystem permhsions that are verifed ewh time a unee legi as and tren to perform a ieto thin spdeen maintenance area but it afowed to iccesd the murina data. seten is aliwwed to add edin, of delece the data heie. Duta Specifications A few rounds of talk wath Mr. Mackereic. pou reaise that a dacabuse is necded tor the nurie wetsier and thur the database must caphure and store data and intormarion about the marina's cuctomen, revtai gnoperty. reetal reservations. in addirion, vou nealue that a number of well pages and toms are sequed foe capiarieg information. and displaps the customer's nane, addres, enal, and phone number. Adsitosaly, the customer fors shows the curtomer ileneficatios aumber, tatal tharges, the aneunt helghe has peid and the bulanir dut. The botal charges field show the total amount owed tor the cvitosiert correct seservalion Virwise the Amountpaid field shows the tocal paid taward the conent imerations, and the Remaining Balance field indicanes how much is atill due. - On the reservation form, Mr. Mackender marts so see at a minimum, thw reseriten defri, booking fontal rase, tolal isate cest, and commenti. When isine the Reservabon form, Mr. Mackerue warta tis select the rescal prosersy number them a list of hos terwal preperties and haver me seital poperty's deierigtien and sental fee duplayed. On the atyment form. Mr. Madertir warta ts set the paymuete dase purtieet amourt, and coments. b cordibent, profersional appearance, be ealy to int. Addxichaly, fach forn must inclube buthoss that alow walues, input munkt, and proper tarmatting. information Spencificatiom On the Mariea's weboife, \& thould haw a funcion la dinplay a Dally fectal fraperty firseriction ferpor, a Froperty Alswervition showa which propertins are inserved for the neat diny. This mocrt iorti the properties by separt to moke sure that the teserved wasertah and cabini are in working order. Often cuitumen will wh when a retal property in avaleble. It is then iequined that the wothile providrs abieg 1o locate ieneal propecty's second and check its ovalabilify. The feneal Property Avalabilty trport sheuld be aropertr showd be sonted whin eack cabegory. fental trancictions. Ad mencioned above, you are fiee to work with the derien of the web pages loyour and forms. Yoe min needse weate addinosal formsjpages or collect isformation that has not been previcunly specifies. Fou can discuss with wour lecturer to shientind those resuiremens about the onobien. Decivetuales the probiem deicription and then prepare a writtes report. The following are required for wornisios of deliverables. - Finst things first, You are not allowed to make une of a web framwwork (ve. Calphie, Codeleniter. guttethen ath frustert. - A written report, witien in Microvaft word format, detalk the design ane inolementacion of pour webrice, The report ahould centain two parts Webvite devien and Wrbute implementation and proganming. Webute devigh needs to previse indormation about andiping and devering vour webste for the cae. Docamests required in this part involve, for earmple, functional requienmenth, not hunctional requerements, flagrami such as IADs, broh fet. The secord part, which is Webaibe implementateot and pregrameing, of the report needs to provide ieformation on developing the webute which in haued on the infomation indeated in the deugh gart. Docurnects resuired for this part include a wwbuite ithucture, laybut of packs. databare detign including tables, attributes, troes of data for attr butes such ar numenc, tex: efc. with their comeraints wath at mas length, eft. The cepart thould prowide advquite information trom a vptem devien standpoie to addrea how your whinee was deugred, toded, tesled, and implememed. Dhcusa aty arsumptione you have made ibcut the problem and the kry elements of the problem. Additionally, what Aeatures ded pou add to make the vebifte mare functional? Uier friendly? JPleast note that these assumptiom cantoe wolate afy of the requiremeres apec fied above and munt be approved by your lectourer. I The repot should alse indicate machine an a teat bed for your wrb int. If your weboke requrei logiv/paiswond, inlomation ibout. logis and painword foed to be prowded. As part of thes report include what walidetros you heve included on the inputs and whiy. - A student goug work and individual contriauson statemene forn (wvallatie trom Alist wibrite