A Management System For Shopping Malls Computer Science Essay

A Management System For thieveping M tout ensembles Computer Science Es sound out1.1 inductionTherough this frame to design constitution to orgnize the make water of Shoppiing M whole contain many stores belong to the same company of this m every.Through this agreement we foundation manage the work of all shops in this mall and monitor all activities in all shops.In this system we have tow sections, the first is Management, and the second is Shops,Each section hase diametric features.we have in this system tow level of privilleges, administrator or manager , and the employee of shops.The manager or administrator grass add overbold administrator for this system, add parvenue employee dor shops, add unused shop, and see report of all shops in this mall.The normal drug substance abuser of employee of shop has the privillege to perform barter operation,add new goods to the install of this shope, update the balance of exicting goods in the store of this shope,monitore th e daily bargains operation through with(p), onitore the monthly sales operations done, and monitore the balance of goods in the sotre of this shope.1.2 Aims Of The ProjectThrough this system we work to achive the avocation documentalsform the Registration of new shope in this objective we orgnize the registeration of new shope and enter the relative information about this shope.Organize the registration of sales operation in this objective we orgnize the registeration of sale operations informtion and try to do it in less time with less effort.Orgnize the registeration of new goods information in this objective we allow the normal user to enter the information of new good in the store of his shope. all(prenominal)ow the user to add extra quantity of an excting provender in his shopes store.Enable the user to occupy information about sales operations done finished this system (daily and monthly) prin add-in format.Enable the user to get information about goodss balance in h is shope in printable format.Enable the administratore to get information about all shopes in the mall.1.3 System ToolsTo design this system we use Visual Basic 6.0 as programming language to design the GUI (Graphical exploiter Interface), and we used Microsoft portal to build the informationbase of this system.We selected Visual Basic because it is easyto use. We endure establish forms ( portholes) utilise drag-and-drop techniques. A tool is used to place fancys on the form ( window). We can enter the default value for the attribute of any control we add to the form (interface). Many attribute values can be modified during run time based on user actions or changes in the environmentFor ensamplewe can cange the date of sale always to the current date even if we run it after 2 years after finish designMicrosoft Access database management system was also used in designing the database of the system. It is used to create simple database solutions. Access tables support a varie ty of standard force field oddballs, indices, and referential integrity. The system also includes a query interface, forms to display and enter data, and reports for printing. The underlying Jet database, which contains these objects, is multiuser-awargon and handles record-locking and referential integrity including cascading, updates and deletes.Microsoft Access also offers the ability for programmers to create solutions using the programming language Visual Basic for Applications (VBA), which is similar to Visual Basic 6.0 (VB6) and used throughout the Microsoft Office programs such as Excel, Word, Outlook and PowerPoint. most(prenominal) VB6 code including the use of Windows API calls, can be used in VBA. Power users and developers can extend basic end-user solutions to a professional solution with advanced automation, data validation, error trapping, and multi-user support.Applications that simply view data or have simple data entry can support considerably more users.2.1 St ructure of the systemIn this system we have tow main sections first for managemetn and second for shopes.2.1.1 management sectionIn management section we have four featurs correspond new administrator in this feature we allow the administrator to add anothor administrator (administrator = manager), in this feature the asministrator enter the user put up and password for new administrator.Add new user in this feature the admin can add new use (we mention here in user to the employee of the shope), to add new user the admin assume to enter the user name and password and the shope which this user forget belong (or works for), here we mention that we cannot add new user to a shope not there in the mall.Add new shope in this feature we allow the admin to add new shope to the mall, to add new shope to the mall the admin need to enter the name of this new shope and the type of it (e.g optics).Report of all shopes in this mal in this feature we allow the admin to get information about al l shopes in this mall in printable formate.2.1.2 shope sectionThis section available to the emmployee of shopes in the mall, we have to mention that the administrator of this system must add this user hence he can login to this section.in this section we have six featuresNew sale in this feature the user can enter the information of new sale operation, these information includes the customer name, customer mobile number, saled good,ordered auantity,unit price, and discount if there is any discount.Add new goods in this feature we allow the user to add new goods to the store of this shope, the information needed to do this tax includes Good name, Purchae price,sale price,Quantity,andmeasure.Update goods in this feature the user can update the quantity of any exeicting goods in the store of his shope, the relative information requested here is good name, added quantity,purchase price, sale price.Goods report in this feature the user can get report of all goods and its balance in h is shope.Daily sale in this feature the user can get report of all sale operation done through this system in current day.Monthly sale in this feature the user can get report of all sale operation done through this system in selected month.2.2 Systems TablesIn the previous section we explained the main organize of this system, now we have to show the building of the systems database (the database of this system was designed using Microsoft Office Access as mentioned before) The following tables argon designed in the database of this systemADMIN this table created to save the information of administrator login data (Table 2.2.1)USERS this table is for livery the information of users of this system. (Table 2.2.2)SHOPS this table is for saving the information for shops in this mall. (Table2.2.3).GOODS this table designed to save the information of goods. Table(2.3)5-SALE_INFO this table desgined to save the inormation of sale opertation. Table(2.2.5)2.3 Connecting between systems d atabase and users Interface on that point are many ways to connect between visual basic and MS Access but in our system we depend on the connection by the code and connecting the object directly to database not by adding object on the form at design time.It depends on the connection wagon train for pettifoggery library, at first a new ADO Connection and ADO recordset items is created then define the connection path (path of database in this system) as connection stringAfter that the recordset is opened by sending a query for specified table name.Dim rs As ADODB.RecordsetDim con As ADODB.ConnectionThe following shows an example about the connection way in this systemThen write the following code where connection to database is wanted to retrieve, send or view dataSet rs = New ADODB.RecordsetSet con = New ADODB.Connectionrs.CursorLocation = adUseClientConstring = Provider=Microsoft.Jet.OLEDB.4.0Data Source= App.Path MMS.mdbcon.Open (Constring)Chapter 3Implimntation of the system 3.1 Main Features Of The SystemThe aim of this system is to acquire a number of objectives. These objectives areRegistration of new shops in this feature, the administrator need to register the iformation of new shop, this information include the name of shop and the type of this shop (shops activity).Orgnize the operation of create new user this feature allowed for administrator only, in this feature the administrator can create new user, this new user works in selected shop while the administrator create this user.Orgnizing the registeration of sale operation in this feature the user must register the information of sale operation, this information include the shop name,goods name,order quantity, the discount, customer name, customer mobile, and some information will be mechanically loaded when the user select the good name like available qantity, and unit price.Orgnizeing the registeration of new goodsThis feature allow the user to add new goods to the shop where he is working, this information include the name of goods,purchase price, sale price , and the purchased quantity.Orgnize the operation of updating the quantity of goods in this feture the user can add quantity of any goods in his shop.Preparation of detailed reports theadministrator and user can get these types of ReportsAll shops this report shows the information of all shops in the Mall.Daily sales this report displays the information of all sales operation done in selected date.monthly sales this report displays the information of all sales operation done in selected month.Goods report this report show the information of all goods in the shop.We have to mention that the first report allowed for the administrator only, while the other reports allowed to the normal user3.2 Implementation Of The SystemIn presvious section of this report we explaineed the structure of this system and talk about the objectives of this system, now we will talk about how t use this system, or how this system works.F irst there is introduction window, in this window the user select the section heshe wants to use Management or Shops as shown in physique 3.1Figure 3.1 Introduction window3.2.1 Management subdivision If the user select Management from the introduction window heshe will get the login window where heshe must write the user name and password of administrator in this system, as shown in figure 3.2Figure 3.2 Administrator Login windowAfter make the sorrcet username and passowrd of administrator, heshe will get the main window of adminstrators task, as shown in figure 3.3Figure 3.3 Administrators task windwIf heshe wants to achieve th feature of New administrator, heshe must click on New Administrator energy, then heshe will get the following windw, as shown in figure 3.4Figure 3.4 New Administrator windowAfter fill the requested handle , the system will connect to the databse and go into the table Admin and save new record with the information of new administrator.If the administra tor wants to achieve the feature New User, heshe must click on New User button on the Administrators task windw, then will get the following window, as shown in figure 3.5Figure 3.5 New User windowIn this window will need the username and apssword for new user , also we need to select the shop where this new user will work, the list of shops will automatically loaded to the window by going through the database and go to Shops table and have the name of all shops in this mall.When the user fill all rewuested palm heshe must click on Save button to save the data of new user, in this operation the system will connect to the database and go to USERS table and create new record conatin the information of the new user and give him an autonumber as ID, the administrator can cancel the operation or close this window by click on Close button.In case the administratore wants to achieve the feature Add New Shop, hezshe must click on New shop button on Administrators task windw to get the fol lowing window, as shown in figure 3.6Figure 3.6 New Shop WindowIn this window we can see that we have only tow fields about new shop, these fields are shop name and shop type, after the administrator fill thee fields, heshe must click on Save button to go through the database and create new record in table Shops and give this shop an autonumber as ShopID.The administrator can cancel the operation or close this window by click on Close button.Finally, if the administrtor wants to get report about all shops in this mall, hese can click on All Shops button on Administrators task windw, the get the report as shown in figure 3.7Figure 3.7 All Shops report window3.2.1 Shop Section This section specified for the normal user (the employee of the shop), the user can go into this section by clicking on Shop button in Introduction window, then heshe get the folloing window, figure 3.8Figure 3.8 user Main windowAs we see, in this window there are six buttons, each one for different feature.If t he user want to perform sale operation, heshe must click on New Sale button, then will get the following window, as shown in figure 3.9Figure 3.9 Sale windowIn this window the user will find list of all goods available in this shop and the balance of this goodsand the unist price also, ths information brought by the system when load this window, the system will go to the database and go to goods table and bring the name of all goods which belong to that shop, after that when the user select the goods name and its balance nd the unit price.After the user fill the requested fields then click on calculate button to cacuate the total price, then the user clicks on Save button to save the information of sale then he can click on Bill button to get the bill of this sale.If the user wants to add new goods heshe must clicks on New Goods button then heshe get the following window, as shown in figure 3.10ConclusionUsing this system we organize the work in the Hall, also we reduce the time and effort spend to achieve the following task Register customers information in this system.Register the relative information of second-stringer in this system .Organize the operation of updating the information of reservation.Organize the confirming and caneling reservation in this system.Getting the reports of all reservation done through this system.Getting the reports of all reservation done through this system accoring to selected month.Getting the reports of all reservation done through this system accoring to selected month and year.After using the system we can say that work of Hall reservation can be organized through this system.As we explain in the body of this report the use of this system is tardily and any one with simple knowledge of computer usage can use this system and finish the task without any mistake.there is no pure(a) system and each system contain some notices either the analyzing or the scenario of work, but in this system we try to cover the most importan t task or features of store department work.Before we build the system we have to analyze the system and detect the work flow of working and see what are the rules that control work in Hall reservation operation to suffer building the tables and see what windows we need and how any windows we must have in our systemafter that we search for tools enable us to program the system in best way, we find that the easiest tools to do that is VISUAL BASIC (VB) for program the user interface and Microsoft Office Access (MSACCESS) as database management system, these tools are easy to use and easy to be used in developing the system in future.When start to build new system the author face tow types of problem technical and official.The technical problems was to find the suitable and useful tools (programming and database management system) enable the designer to build efficient system and enable the user to store many records in database able to be retrieved in few seconds without any proble ms.After we contract the programming language and database management system and connect them together and start build the database and table and start writing the code that will be put to death while system running in order to achieve the tasks of this system.