Electronic Notice Board Software

Electronic Notice Board SoftwargonENB send was created to modernise the continent means of communion through the pin and paperboard based conversation to the more high-octane and dynamic communication of general information to the disciples of the Bolton University.Student and module testament get the durati whole information while they ar walking roughly School office or in Labs. ENB provide remind the student about the critical dates for the exams, sociable events, and warnings etc. It will positively affect the student behaviour towards the school dayman excellence and era management. ENB will decrease the score of late assignments submission and absents among the students.ENB will decrease the workload of university management for printing and pasting the traditional paper based notice boards. ENB system will not hold any add upitional hardw atomic number 18 and it will be highly-developed in the Microsoft Visual Basic .net Express Edition and Microsoft SQL s erver Database hence low appeal of victimisation and actionation. ENB will bring forth a positive change in the university environment.ENB honk was created using the VB.NET and SQL entropybase express editions, which ar free of cost. Database is aimed to visit the efficiency of the software in the mesh topology environment.A survey was conducted on the render of students to evaluate the potential of ENB to improve the overall communication in the campus.To look into the successful implementation of the project the software was tested and evaluated in the campus environment. The final solution met all the basic requirements and alike delivered al approximately extra features. Further features and melioration can be added in the proximo.The report has the details of the ENB project from start to end, including the requirement epitome, background look, design, implementation, testing and evaluation stages.CHAPTER 1INTRODUCTIONProblem commentaryDuring my time in unive rsity I occupy missed many recreational occasions and a couple of times I have missed substantial dates of final assignment submissions as I was miss in create about the dates. All these errors of misinformation made me realize the necessity of an electronics notice board.In the University of Bolton there are many problems, distinguish is between rumour and true information. At times dates are changed and change of plan is very poorly move ond to the students and force, which creates confusion. In case of an ENB students will have access to all-important(prenominal) announcements while walking around and have the benefit of cosmos reminded some(prenominal) times a day. Currently university administration is using a Paper based notice board. A printed black and white poster is pasted on the notice board to announce university events. The method then consumes the administrative and clerical time of the university. Sometimes the change of dates is not timely announced, which provokes frustration among the students of the concerned disciplines.The ENB project was realised and envisaged based on the concept of better the communication channels within the University campus among students and the faculty members. For example to announce the start of fresh semester a simple piece of paper is loosely pasted at the front door notice board of school office. Sometimes the fonts are not distinguish and the black ink prints are not very hypnotic and appealing to grab the real perplexity of the concerned students. So the students miss the critical information and often submit the final project or form for the final exams very close to the deadline. In my opinion irrespective of the students aptitude the fault might be at the universitys end. The ENB will effectively convey the tell apart academic information to the students hence there will be great reduction in the late submission of the final projects and assignments. The ENB will play a all-powerful role at will increase the academic productive of the students.A notice board can be defined as Abulletin board(pinboard,pin boardornotice boardin British English) is a place where people can leave publicmessages 1A Notice Board is a traditional stopcock for the dissemination of information in academic campuses. A traditional Notice board is made of a woodwinden frame with a soft central square of cork for pinning the cover of information for the students.Widespread adaptation of information technology has changed the traditional means of information dispersion. Electronic notice board is an innovative replacement for the traditional wood and cork notice boards. Due to the dynamic nature of the electronic notice board it has practical application in the corporate environment. Following are some of the case studies about the practical application of electronic notice board in both academic and corporate scenarios.AimThe project ENB aims to develop and implement application software tha t will disseminate the academic information in the network environment among the students and faculty members. The project ENB will open the new powerful channel of communication between university management and students.The solution will consist of a page server and client PCs as the notice boards.In the design phase I will focus on to simplifying the end drug substance abuser experience of using the ENB. End users will probably include members of admin staff. For the administrator it will be hassle free to upload the different formats of multimedia. There will be some quick templates to quickly upload the announcements.The ENB system first time configuration will be automatic thusly very easy. There must be server software on one end therefore the client side will automatically detect the server. In case of multiple page servers the ENB system will give options to connect.The ENB system will be Database driven hence it will take the minimal amount of network bandwidth. The ENB system will be network based therefore additional network optimization technology will be deployed to make it as fast as possibleThe system will be operated by Administrator and new(prenominal) staff to assist them in scheduling toils for messages in the near future. Also an aim of the project is to develop the framework so that it is easy to extend in the future.ObjectivesThe ENB system will be developed using the visual basic programming language and MS SQL SERVER database. I will focus on the following outcomes for the finished product.In order to satisfy the aim the following objectives need to be achievedDeploying a software engineering methodology relevant to the ENB projectDesign a data amaze for ENBDesign and develop an integrated system to query the data modelTest and Evaluate the ENB against the requirementsMinimum RequirementsA prototype of an integrated framework for Electronic Notice Board system which can be informative and flexible.A prototype to input and store ta sk commands.A prototype to input and store scheduled task commands.A prototype to input and transfer scheduled task to task command data.EnhancementsA login system to provide security for the server application.View of Report of pending tasks for any date.View of Report of completed tasks for any date.Administrator prototype to add new users on database server.Administrator prototype to run client in Admin mode.Data bound lineation to control scheduled tasks.Controlling the clients status wide awake or inactiveInputFIFO First in First out. As task is isthmus to client, it is executed straight a authority. meter Controlled drill Events are controlled by given time. Time can span to any number of minutes, hours or even days.Date Controlled pattern Events are controlled by given Date.Time and date controlled pattern combination of Time Controlled pattern and Date controlled pattern.Client Registration DataPrimary Input Client Id, Client Name, Client anomalous Id, Time of Regist ration, Date of Registration.Secondary Input Client State.Base Data (Client Data)Base table is basically a blueprint for all clients.(Primary Input) Record Id, line Id, projection Command, Task Arguments(Additional input) Task in Time, Task in Date, Task StateScheduled DataIt is same as Base Database.(Primary Input) Record Id, Task Id, Task Command, Task Arguments(Additional input) Task in Time, Task in Date, Task StateOutputFor each task that is in current execution schema is grouped by registered users and are performed by clients on given time span.Scheduled tasks are placed in scheduler and on given time they are transferred to corresponding client(s) for execution.Requirements AnalysisThe purpose for this project is not to develop a system that can act as a notice board and to integrate and utilize data driven technology to accomplish entangled tasks with ease without any additional hardware to display message. Integrated scheduling technology provides flexibility and automation.Orange valley systems are the market leader for marketing the ENB application for the business organizations Appendix WRITE IT IN END. A thorough analysis was conducted on the orange valley product. Basic conception for the ENB features was captured from the screen shots on hand(predicate) from their web situation. In depth interviews were conducted with the students, friends, and the IT administrator staff.On collecting the requirement analysis data from the above research the following functional and non functional requirements were devised.Functional RequirementsAdd and edit tasks.Add and edit scheduled tasks.Add and remove tasks.Schedule tasks bring out reports of tasks.Non Functional RequirementsSystem must be easy to use and navigate.System should have a consistent interface.CHAPTER 2METHODOLOGIESMethodologiesCommunication is the lifeline of any social system. Success of any organization is directly related to the effectiveness for their communication systems. Aca demics are no exception for this. An effective campus communication system must be understood, credible, and practically utilized.Attributes about the campus communicationIn the year 1973 Mr. Anderson Jerry M presented his research papers at the Annual meeting of the Nebraska speech communication association. cognomen of the research papers were Improving the internal communication A campus Quandary. Research papers were based on the formal interviews with the 90 interviewees. Each interview took 15 to 90 minutes. Interviewees were randomly selected persons of the campuses. Interviewees included the campus administrators, faculty, students, staff, alumni and trustees representing 30 post secondary institutions of different sizes. Past research data was also used to analyze the results of the research.The 1971-72 opinion research was based on an interview format knowing to be open-ended to encourage respondents to call upon personal experience and ventilate feelings. The interviews unveiled the issues and anxieties regarding the campus communication.Two questions formed the basis for interviews, except in a few instances where a more structured questioning onrush was necessitated to elicit more extended responses. Those two questions From your posture and experiences, how effective is communication on this campus? What, if anything, would you do to improve it? 2Three general attitudes clearly emerged.The need for improved campus communication is among the most signifi tip and pressing problems. When asked why, most answered that the functional operation of the campus was dependent upon communication effectiveness and it could be much improved, and internal effectiveness as perceived by those outside the campus would determine the take of future support.Recommendations for improvement were multiple, usually incomplete in development, and concluded with the statement that no clear solutions existed.Concern was expressed about the lack of sensitiveness and a ttention to communication problems by those with the expertise to improve the situation and by others in positions to effect change.Opinion research drew the following conclusions.Research uncovered a strong need to improve the campus communication.Old faculty members were nostalgic about the good old days when they knew everybody in campus and always knew the important eventsCampus members realize the supreme responsibility of communication lies on administrationAdministrator is frustrated about changing the campus communication. They dont understand the approach to the change. They themselves are confused on aligning their communication between deans and faculty.Faculty members and chairman were not happy with the unreasonable deadlines, dissemination of information in clusters, reactions to proposed policies.Communication denial and communication under load were the important concern of middle level management.Campus staff was concerned about the lack of confidence upon their c olleagues due to surveillance and audit of their work.Information used to distort when passing game down or up in the hierarchy of the organization. Traditional approaches were not working20% of the sample showed their lack of interest for improving the campus communication. These were mostly the students and faculty members.Interviewees were most distrustful about the administrative communication behaviour especially lack of disclosureSolutions for improving the Campus CommunicationCommunication had been improved using the scientific advances.Providing informational announcement is on closed circuit television between classes had proven to be effective.The use of telephone answering services in offices during after hours, and as a message dissemination system for people to call and hear important recorded messages.Catalogues and bulletins and other information sources need be written with the sensitivity to readability.Departments or divisions, large institutions, should be encou raged to develop newsletters.Bulletin boards could be kept up to date and used more extensivelyI have chance to review the communication methods deployed by the UK universities. These are some general and specialise methods. countersignKantor, Brian and Phil Lapsley Network News Transfer Protocol A Proposed pattern for the Stream-Based Transmission of News. 1986. 3 Universities employ NNTP (network news transfer protocol) service named News as the official bulletin board. NNTP provides discussion forums for facultys, programming languages and other both academic and non-academic topics. NNTP has also the application of a notice board where official announcements are posted. Students can access the news by any newsreader. Thunderbird email client and Tin are pop newsreader. Students are required to read the newsgroups on a regular basis as it is the chief(prenominal) method of official communication between the school and students. It has been noticed in the recent years a fallin g trend of reading news among the university students.EmailUniversities provide everyone with an email account. Using email to communicate has several expediencys. Email Communications are often more effective than printed direct mail. 4 Firstly email is a flexible system that by at present has large amounts of web integration. Therefore people have flexibility in how to access their email account Secondly email is an accepted method of communication with people usually inspecting their email on a habitual basis and therefore messages be likely to get read. As a broader point, email is merely further widely used all-round.SISThe term SIS School Information System is used in some of the UK universities. SIS provides information on students, staff, modules, timetables, coursework and more. From the perspective of an undergraduate student, SIS provides access to the school timetables, modules information, and coursework results and is also used to facilitate the submission of electr onic coursework.Module web internet sitesIn most of the UK universities every module has its own WebPages. Modular group of pages can be accessed on adding codes in the official URL. These web pages typically include the outline of the module, lecture slides from each lecture, sample coursework, additional reading and information on the examination and assessment process for the module. 5WikiThe simplest online database that could possibly work.6 Universities have link to the WIKI. WIKI has rigorous information of how to and guides to using the facilities. The wiki provides plenty of face-saving information and is frequently the first port of call for numerous students when students have a problem or desire information on the University facilities. University of Bolton has the WIKI. It also has new information that people are continuously adding. However until now nearly all of the edits have been through by staff or by a splendid selection of students. It has up till now to be fu lly embraced by undergraduate students with a small number of using it on a regular basis and barely any undergraduates contributing to it.VLE (Virtual Learning Environment)Mostly Uk Universities Library has a virtual learning environment which the universities developed in-house and launched in around 1996. Access to the environment is available through a web browser for both students and guests 7.The thought is to create a virtual campus online separated up into diverse buildings which house the different resources on offer. The quantity of information available varies from school to school and from module to module. For example the business school has a chat room, module information, lecture slides and past exam papers for a large number of their modules. The School of Computing however does not. This is most probably because all this information is available on the schools intranet. The VLE also provides quick access to searching Google, Oxford reference dictionary, Thesaurus.c om, Institute and the library catalogue.FacebookFacebook is a social networking website analogous to MySpace. It was at first targeted at university students. The site was launched in 2004. It was primarily developed for student community of Harvard and extended to offer networks for other universities and ultimately opened membership to all and sundry in 2006. The idea is based around a series of networks, one for each university. In order to join the network one needs to use a logical email address for that institution (for instance, in order to join the University of Bolton network you require to use a Bolton.ac.uk email address. You then have access to that networks features much(prenominal) as being able to view peoples profiles, joining groups and creating and replying to event invitations. Facebook is amazingly popular with students, claiming a penetration rate of 85% among US college students. Facebook also achieves very high levels of user retention. Over 50% of its user base visits the site every day 8 and on average each user views 50 pages of the site per day. The main problem with Facebook from the perspective of the school is that is it not managed by the Institution and the Institution has no control over it. The school has no effective way to utilise Facebook to communicate with students as it does not have control over the School of Computing group on Facebook and only a minority of the staff are registered on the site. A more elemental problem is that Facebook is a social networking website intended for students and was not intended to be used for academic activities or to be utilised by academic institutions.ConclusionIn the universities of UK current methods of campus communication do not seem to be engaging the students. Declining use of the News and other web based IT platform shows that students information needs are not met. Facebook is very popular but Universities have no control on it.Therefore it would appear to the Universities requirement to deal with these problems either by upgrading their existing systems or adopting a new system in order to engage students more and meet the new level of expectations of the students.CHAPTER 3BACKGROUND RESEARCHBackground ReadingSoftware Engineering MethodologiesA methodology is a structured approach to design and develop the software, hence reducing the chances of software project failure. Methodology provides a recommendation of a series of steps to be followed 9.There are number of software development methodologies. The selection of the methodology depends on the scoop and complexity of the project. Some of the famous methodologies are Waterfall Model which is also set forth classical model 10. The Spiral Model was introduced to replace the Waterfall Model 4. The Spiral model is being criticised for its rigidity.The Rapid Application Development ( rad) methodology became popular in the early 1990s due to the perceived deficiencies of the traditional waterfall appro ach 11. rad is ideal for the projects where requirements may change during or after the development.RAD has advantage on other methodologies to save the time required for development. Prototyping is another methodology in which developer builds an application from the requirements.There are two types of prototyping methodologies evolutionary prototyping and throwaway prototyping. It is important to decide in advance the selection for the type of prototyping methodology 12.After a thorough analysis it seems that no single methodology is suitable for the ENB project. elect methodology will be explained in the following section.Chosen MethodologyIt has been decided after reviewing the common methodologies, it seems appropriate to select the Evolutionary prototyping methodology for the ENB project. RAD will be used to develop the required features of the ENB software. Using an only the approach of RAD will lead to the errors and the prototyping will allow correcting the errors.Prototyp ing has the four main stages.Identification of the requirements.Development of a prototype system.Review the prototype.Revisions and enhancements of the Prototype.Prototyping typing will allow the development of the certain module of the project. Even if the whole project is not developed, there will be basic system to be developed further in the future. For example server side application will be developed with all requirements of scheduling, the tasks and defining the users rights. The client application will be developed afterwards. Client application will have support for the features of the server. On the user evaluation the further features will be added on the server side. RAD will be used on each phase of the development therefore the client server applications will be developed rapidly.RAD will be used within each phase of development, so the Time Controlled pattern / Date Controlled pattern Input task will be developed rapidly. Similarly the other aspects will be developed like this and will unneurotic form the overall framework, which will develop as an evolutionary prototype. Each aspect of the system will be developed using a RAD approach and then modified, this will include the database development, the input component and the output component. The evolutionary prototype will allow for any bugs to be corrected during the development instead of detecting and correcting them during the testing phase.Tools and ApplicationsDatabase SystemsThe system involves the use of a lot of information, some which will be needed several times and the most appropriate form of storage of this data is in a database. This will allow data to be saved from input to the system and retrieved to be used by the system.As an important aspect of this project is use of Time Control System. In this section several databases are reviewed for their suitability to this project.Microsoft AccessMicrosoft Access is Bundles of RDBS with the Microsoft Office. MS Access is widely spre ad on the windows based PCs. It is dependent on the windows environment therefore it cant be deployed on the Linux or UNIX environment.MS access has a graphical user interface, Which facilitates creating the database tables and their relations, queries, forms and reports. MS Access is one of the best selling databases and it has a lot of support available from Microsoft and this is likely to remain so in the future 13. MS access has disadvantages. It has data limit of 2GB. It is not ideal to use on the network. MS access has lax security measures to prevent the unauthorized access.These disadvantages would be an issue for this project as the system is likely to be accessed by a multiple users at a time and multimedia files will be run on it, it is very likely to exceed 2GB in size. There is a possible security risk of an MS Access database due to it being stored as a single file if un-trusted sources gain access to the folder it is contained in 14.Most important drawback of MS Acces s is that lack of network support. ENB is on the whole depending on Network environment for communication which is by no means supported by MS Access.MS SQL master of ceremoniesMS SQL Server has been developed by Microsoft and it is their more expensive but more robust alternative to MS Access. MS SQL Server is more commonly used by businesses for small to medium sized databases.MS SQL Server is a high surgical procedure database with a bundle of functionality and it also has built in security features for LAN/ disgusted and web environment. There are free express versions of MS SQL Server that can be downloaded for free, however free versions offer less in functionality 15. MS SQL Server utilizes Transact-SQL as its primary query language.MS SQL Server allows procedures to be stored within the database comparable to MS Access queries. This reduces load on the network bandwidth because only the variables are sent to the data along with the related procedures to be executed not th e entire queries. This method is useful for the regular database queries. The method also protects the database from the shooting attacks 16.Sql server has the following disadvantages.It can only work on Windows environmentProfessional and Enterprise editions has costly license feeAs far the ENB project the Enterprise edition is not required.MySQLMySQL is free open source relational database management system. MySQL is the most popular open source database due to its high performance 17. MySQL has compatibility with any operating system including Linux, UNIX, Mac and Windows. It can also handle large amounts of data and provides security through user authorization and access privileges 18. MySQL was designed to use on the internet, due to the high performance and very advance features MySQL is a favourite database for the desktop applications. A disadvantage of MySQL is that it is not ideal to set foreign key references 19.PostgreSQLPostgreSQL is also an open source RDBMS, it is a platform independent database management system analogous to MySQL, however it has more advance features such as triggers. On implementing all features PostgreSQL performance is slower as compare to MySQL. PostgreSQL is the database of many high profile applications such as Skype and Hi5.com. PostgreSQL database design is more complex than MySQL. Performance of PostgreSQL is relatively slow 19.Chosen Database Management SystemOn reviewing the above database systems the following analysis are being concluded.Ms Access has been dispose from the selection list. It has no support for the network environment. Due to the network oriented nature of the ENB project the network performance is the core issue. Network performance cant be compromised. It will jeopardize the overall functionality of the project during the network load times.PostgreSQL has similar feature as MySQL. Both are discarded on the grand of limited GUI support for development and maintenance. Both are not closely integ rated with MS VB.Net.MS SQL server 2008 Express editions has been decided to be used as database platform for the ENB project. SQL Server 2008 Express is a correct choice for project to include Multimedia database services.Microsoft SQL Server 2008 is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL. Due to the limited scoop of the ENB application I will use MS SQL Express Edition.Microsoft SQL Server Express is available at no cost. SQL Server Express edition relational database management system, comprises a database is limited for embedded and smaller-scale applications. Database engine is limited to gain work from a small number of users. It has several technical limitations therefore it cant be deployed in the enterprise environment.Maximum database size of 4 GB per database. The 4 GB limit applies per database (log files excluded) but in some scenarios users can access more data through the use of multiple interconne cted databases.It has the several advantages. The advantages are listed in the following lines.Its free of costSQL server express edition has all the features required for my ENB project.SQL server express edition has Management studio. special(a) support for multiple clients on LAN.SQL management studio will simplify the management and maintenance of the ENB database.Most of the IT technician and administrators are well versed with the MS SQL server.GUI appliances will allow administrator to easily troubleshoot the common database issues.Main reason for selecting the SQL server is the TCP/IP pipes. TCP/IP pipes technology is very efficient on network as compare to the traditional TCP/IP packets.Programming EnvironmentsAn appropriate programming environment is required for the system development. The programming tool must be capable to develop the graphical user interface to display the understandable output to the end user.In the ENB project the end user will the system administra tor. It has been selected that MS SQL Server will be used to store the Database so the Programming tool must be able to move with the MS SQL database. The chosen language should include support for object-oriented implementations.Booch (1998) stated Each object can be viewed as an independent little machine with a distinct role or responsibility 20. Objected oriented language would allow efficient data parsing. The development in the high level programming tool is simpler than coding in the low level programming environment. Indeed high level programming tool reduces the cost of development as well the time spent on coding.Some of the programming environments are analyzed in the detail.JavaJava is an object oriented programming language, developed by cheer Microsystems 21. Java is a well accepted high-level language. ICN students study java during the firs