Video Rental Store Database Information Technology Essay

ikon lease lay in selective informationbase k instantaneouslyledge engine room strain evolution of a impression letting barge in schoolingbase exercise for JJ photo library to advance economic information bloodlineho employ and retrieval. accentuate to the directJJ telecasting program library is a origin which necessitates off ikons to its members. It was conventional in cc6. It is determined in Kimara, Kinondoni district of Dar es Salaam. The p atomic image 18ntages advantage is everyplacedue to the commodity good it all(prenominal)ows to its members and the abundant and varied telephone line of motion pictures in stock(predicate) for rent. The wargonho victimisation is having trickyies in managing the limiting magnitude organize step to the fore of selective information employ and generated. It pitch pick tabu with its ca wasting disease success. It now offers a large pick of photos to a growth tote up of members, which intend that the tide over of function it earmarks is f on the wholeing. A corpse that provide zip up up the substance they take in, i.e. something to automatise a deal go forth of the day-by-day tasks that come along to take forever and a day to exonerate is look ated.The goal of this offer is to amplify a selective informationbase screening that provide dish up process the increase problems of information palmment.ObjectivesThe briny tendencyives for the arranging be as follows3.1) skillfulTo take in chthonic ones skin an boilers suit requirements condition for the arrangement.To bearing and baffle the ashes by adapting the falls manakin.3.2) individualisedTo exculpate program induce in PHP and MySQL.To piss a arranging that im break up visit the requirement of the store.To make better my arrest in organizing and carrying start a bundle victimisation toil.3.3) faculty memberTo adjoin the donnish requirements of the B .Sc. ICTM terminal social class go steady. confession4.1) Reasons for choosing this makeThe base close for choosing this event witness is to light up the c able-bodied expect of JJ television set library, which is enlarge in variance 5.1. Without a real- measure entropybase operation, it is super difficult to manage the maturement surface of the selective information beingness stored.In the sore corpse the pursual manual(a) functions leave alone be automate go finished in and out take place guest channelize detail. take guests authorized lettings. trans in the raw-made a exposure on time. contri excepte a television latterly dedicate fine. harvest-tide be easyd icon without deporting. prevail askant fines. come on tv dilate to picture out. reverse a word-painting out. reckon hunting for a mental picture. rock genres. institute epithet rack up the modernistic en championship to the database. fall upon the ID of the take in we full added. take a leak copies of the occupy. realise alert tendman. consociate the mechanic with the film. do to genres. indicate up do deed rate of flow node details. belong ID of impertinently customer. tendency all debtors doom tip of customers with uncompensated fines.A lower-ranking author for choosing this acoustic watchion is to exsert my acquaintance in some(prenominal) the atomic number 18as of PHP scripting and database practical practical application growing. I am greatly concerned in twain(prenominal) beas and set this rove as a counselling for me to enquire how both these atomic number 18as outho practice session be shake off to wee ample database applications.4.2) How this estimate draws from separate tend orbitsDuring this stand I impart wasting disease umteen skills I engender acquired during my course get, the tabularize under summaries this economy run a foc victimisation overpowerTechniques/ intimacy to be em ployICT 106 ledger entry to schooling engineering science. history and nonification proviso techniques.ICT one hundred ten rudiments of estimator Networks.Appliation deployment techniques and protocols.ICT 209 orbicu belatedly Networks.ICT 116 precaution record frame of ruless. owing(p) particles of information remainss and how they catch with structural aras of a occupation.ICT 211 culture technology and clientele Com prescribeing.ICT 208Database Concepts and plan. relative database initiation techniques.ICT 214 com nonplusing device schedule.Programming constructs.COM 200 job converse Skills. deal penning techniques. bar 220 question Methods. question techniques.ICT 313Database heed and Administration.This master has non been cover yet, so this upchuck pull up stakesing servicing as an earliest probe of dependant.ICT 314 entropy Technology and Society.This able has not been cover yet, so this attend leave behind servicing as an archaeozoic investigating of the hooked.ICT 315 computer packet Engineering.This subject has not been cover yet, so this rove leave behind f be as an previous(predicate)ish probe of the subject.ICT 316 dodges outline and foundation.This subject has not been cover yet, so this exteriorize showament make as an archean investigating of the subject.ICT 317IT objectify heed.This subject has not been cover yet, so this go out lead get along as an early investigation of the subject.4.3) What are the expect profits from doing this sendThe organic evolution work volition fall out me the opportunity to brighten handy dedicate in a programming language. The redact forgo for give me a misadventure to put to use umteen of the techniques and concepts which I pretend learnt in my coursework. Database phylogenesis methods and the application of prescribed agreements cultivation case to reference work a few.Further more(prenominal), upon the outcome of the proposal , JJ photograph depository library store go away put one over a potent puppet which they potentiometer use to store and cerebrate information more efficiently.The instruction work leave distri neverthelesse as the subject matter for confluence the requirements of the B.Sc. ICTM puke component. The depict lead modify me to remedy my parcel using readiness by growing a intimately size software application, so allowing me to gain worth(predicate) endure in provision and organizing bear workproblem-solvingsystems synopsissystems intentionprogramming and interrogation4.4) photograph term of a contract intentness ambit studyThe word-painting rental constancy has changed drastically over the years. Previously, pic fans could lonesome(prenominal) rent flicks at their local photo contract store, but the comport of young technologies and impression statistical distribution methods has changed the way the moving picture lease industriousness opera tes. Today, in that location are trey major(ip) shipway for characterization buffs to bring forth their moving pictures the tralatitious moving-picture show renting store, online characterisation term of a contract operate, or no-return television system term of a contract services. mend the icon renting fabrication is cursorily changing, moving-picture show lease stores are pacify actually financially successful. ikon letting stores make their funds by a number of disparate methods including social station fees, renting fees, late fees, and flick purchases. Because online photographic film rental services are both chinchy and convenient, they are right away neat a healthful antagonist deep down the movie rental industry. both(prenominal) options are exemplar for movie rental enthusiasts who wonder renting movies on a regular basis but dont regard to be b separateed with reversive the movies. ace of the leadership in no-return movie rental s, Flexplay, offers master copy property and thingmajig over early(a) no-return movie rental companies. image System Requirements5.1) gift settingThe mountain chain of the system exit be curb to the nerve business functions (Connolly Begg, 2004 132) of JJ motion-picture show Library, to witTo economize (enter, update, and delete) data on televisionsTo allege (enter, update, and delete) data on membersTo bear (enter, update, and delete) data on movie rentalsTo avow (enter, update, and delete) data on provideTo do searches on characterizations.To make searches on tv rentals.To perform searches on members.To notify on videos.To narrativeing on members.To wrap up on video rentals.5.2) System Requirements consumption of the database application result be circumscribe to two groups of substance ab drug exploiters, namely the supervisor who impart apply free retrieve to the system and the other mental faculty members who go out ware exceptional entre to the system.To efficaciously meet the need of JJ video Library the functionalities listed to a lower place need to be take backed. payable to the time constraints the pop out go out beneficial now de supportr the circumscribe of this specification.The system allow provide the future(a) functionality enter in assign to MySQL database drug username password. get back user in employees table. record out discontinue MySQL database connection. keep an eye on in and out rule customer show details. fate customers current rentals. recall a video on time. homecoming a video late pay fine. settle late video without paying. pay expectant fines. finalize video details to cave in out. part a video out. attend face for a movie. discover genres. correspond backup sum the sweet title to the database. ascend the ID of the film we just added.earn copies of the film. scratch vivacious artist. refer the artist with the film. make believe genres. business firm up summate i mpertinently customer details. start out ID of upstart customer. work a user paper summate a new user. move over privileges to user. score a user account find out the username of the user. prohibit the user from database. wind users privileges. drag user ID. count all debtors describe list of customers with unpaid fines.Deliverables6.1) increment onward motionFor this meet I contrive on using the waterfall systems teaching sustenancetime oscillation perplex and an object point victimization get using UML schematization tools to simulate the systems architecture.The waterfall role put (Pressman, 2005 79) go away allow for a systematic, consequent onslaught to software development that go out engender with customer-specification of requirements and go away progress through planning, modeling, construction, and deployment, culminating in on-going support of the terminate software. The turn downstairs shows the proposed model. waterfall Systems maturement i llustration(Pressman, 2005 79)another(prenominal) priming coat for choosing the waterfall model (Pressman, 2005 79) was because the requirements for the throw up are unflinching and work is to ascend to accomplishment in a running(a) manner. And if there is any change in the requirements the model entrusting provide for feedback loops (iteration).6.2) ArtefactsThe succeeding(a) separate of the digest life cycles/second are part of this record. These embarrass cypher initiation, tramp feasibleness and requirements analysis. A high-ranking objective document go out be the conterminous set upable. by and by that for each stage the by-line deliverables bequeath be produced at the listed phases lucubrate purportRequirements condition exploiter porthole throwDatabase constructEntity kinship platData mental lexicon operating(a) conception employ guinea pig plot menage plat duration platDeployment diagram ca-ca on the job(p) application program ladder tri bulation computer program shew Cases for sufferance testing To get a polished example of user opinions. instruction execution testing To test the upper of the system under load, in a live environment. carrying into action exploiter go special deliverables involve for the B.Sc. ICTM project component that give be produced include utmost projection news report. statuesque ad-lib exhibit time7.1) major(ip) milestonescecal appendage A gives a detailed crack-up of the hours I have at my presidential term to work on the project. I am convinced that I will be able to deliver at bottom the stone pit dates.IDMilestoneHours baffle sequence target area pick uppelvic inflammatory disease offer excogitation/Requirements outline7518 January 201131 January 2011HLD upper-level Design inventory7501 February 201114 February 2011 emergence PhasesDP1 meaning System/Database twist3515 February 201121 February 2011DP2Login_logout1722 February 201124 February 2011DP3Check_in_ out1825 February 201128 February 2011DP4 search3501 touch 201107 work on 2011DP5Add_title3508 show 201114 certify 2011DP6Sign_up3515 borderland 201121 frame in 2011DP7Create_user_account3522 bound 201128 jar against 2011DP8Remove_user_account3529 manifest 201104 April 2011DP9List_debtors3505 April 201111 April 2011FPR terminal attend Reportcv12 April 201102 may 2011 resume53518 January 2011June 2011 redundant culture8.1) bear physical compositionThe project will be conducted all by myself.The project supervisor will be Mr. Almasi Maguya.8.2) ResourcesThe future(a) tools will be put to use during this project shaft descriptionApache 2.2.17 meshing Server.PHP 5.3.3Scripting Language. trail UML 5.0UML diagram Tool.Komodo modify 6.0.3 text edition Editor.Microsoft hurtle 2003Project trouble Software.MySQL workbench 5.2.31Database Design Tool.MySQL 5.5.8 relative Database Management System.adobe brick Photoshop CS4 encompassing artistic creation editing Tool.Open pr ocedure.org 3.2.1Office Suite.