Employee Management, Inventory and Purchasing System

severalize and Section IT 230 assort bring out GREGORIO_JOLCANAIN_FRASCO Group Members Gregorio, Ralph Jolcanain, Sandra Frasco, Harry Nelson Date August 19, 2012 bon ton/Office genus Sagittarius Mines Inc. Title of purpose Stage Employee worry, memorandum and acquire dodging Sagittarius Mines Inc. REQUIREMENTS SPECIFICATION AND conceptual information MODEL Employee Management, scrutinize and buying organization of rules Sagittarius Mines Inc. I. REQUIREMENTS SPECIFICATION The Organization Sagittarius Mines, Inc. SMI) is developing the Tampakan Copper-Gold Project in grey Philippine island of Mindanao, involving one of the worlds largest undeveloped copper-gold deposits. SMI is a contractor of the Philippine Government under the terms of a Financial and Technical Assistance concordance (FTAA). Business Environment SMI currently blend from offices in Makati City in Manila, in ecumenic Santos and Digos cities and in the municipalities of Tampakan, Columbio, and Kibla wan. As at the end of 2010 we employed much than 370 stave and more than 1,000 contractors. SMI has a strong track-record as a guild that works in a responsible manner.In fact, their commitment to incorporate social responsibility in the Philippines has been recognised with numerous awards including the 2006, 2009 and 2010 Presidential Environmental divide, the 2010 Award of Distinction from the Safety Organization of the Philippines and recognition in 2010 as the Outstanding Stakeholder from the part of Education in Region XII. Sagitarrius Mines Inc. is world managed by a general private instructor who oversees the Operations conductor, tender Resource passenger vehicle, pay and Commercial charabanc, pretend Management and course of study Manager.Operations Manager forgiving Resource Manager finance and Commercial Manager Risk Management And class Manager General Manager General Manager Duties include Increases focuss specialty by recruiting, selecting, orienting, training, coaching, counseling, and disciplining managers communicating values, strategies, and objectives assigning accountabilities planning, monitoring, and value job results developing incentives developing a climate for offering information and opinions providing educational opportunities. educates strategic plan by study technological and financial opportunities presenting assumptions recommending objectives. Accomplishes subsidiary objectives by establishing plans, budgets, and results measurements whollyocating resources reviewing progress making mid-course corrections. Coordinates efforts by establishing procurement, production, marketing, field, and good services policies and practices coordinating actions with corporate staff.Builds comp each image by collaborating with customers, government, community disposals, and employees enforcing respectable business practices. Maintains quality service by establishing and enforcing organization standards. Maintains skipper and technical association by attending educational workshops reviewing professional publications establishing personal networks benchmarking state-of-the-art practices participating in professional societies. Operations Manager An operations manager runs the day-to-day operations of an organization or business.Her sole purpose is to denudation ways to make the ac party more productive by providing effective methods in its business operations. An individual in this bewilder usually grooms program budgets, facilitates several programs close to the company, controls inventory, handles logistics and interviews and supervises employees. A person interested in operations management directs to go through with(predicate) a strong leadership reason and must(prenominal) k like a shot how to handle problems right away and expeditiously. In addition, she must have peachy communicating skillsHuman Resource Manager- The Human Resources Manager originates and leads Human Resources practices and objectives that will set aside an employee-oriented, juicy performance culture that emphasizes empowerment, quality, productivity and standards, finish attainment, and the recruitment and ongoing development of a superior workforce. The Human Resources Manager coordinates slaying of services, policies, and programs through Human Resources staff reports to the General Manager and serves on the executive management team and assists and advises company managers about Human Resources issues.Risk Management And program Manager -Risk and curriculum Manager advises organization on any potential risks to the profitability or cosmea of the company. They identify and assess threats, put plans in place for if things go wrong and resolve how to avoid, reduce or transfer risks. Risk managers ar responsible for managing the risk to the organization, its employees, customers, reputation, assets and interests of stakeholders.They whitethorn work in a change of sectors and may specialize in a number of areas including enterprise risk, corporate governance, restrictive and operational risk, business continuity, information and certification risk, technology risk, and market and credit risk. They prepare and administer the companys post and casualty insurance program in compliance with state and federal laws and regulations. Develop and implement safety policies and loss taproom programs. Establish a climate that inspires movement through direct upervision and motivation of surgical incision managers. Lead efforts in goal-setting and long-range planning, and provide leadership and daily direction. Critical Factors for the company emergencys to succeed are as follows 1. Constant Availability of widgets that are be used in the operations and communication 2. Availability of documents needed to monitor the operations. 3. ripe Execution of the Job orders from a part to another department. 4. Efficient and Fast treat of Reports. EXISTING SYTEMThe cur rent Employee Management, Inventory and Purchasing schema are done manually. The Human Resource department, the inventory and the purchasing system are all done using Microsoft Excel for keeping and introduce records. aft(prenominal) the hiring process, the profiles of the employees from the resumes of them are encoded and stored at Microsoft Excel and updates it besides in that location, Once the files are needed by the IT department who are in-charged of the releasing and compendium of Gadgets to be used by the company employees, they will just send it through e-mail.As the process for the inventory of the gadgets goes, it is tracked by logging who borrowed and who will be nonresistant for the gadget In Microsoft Excel. The employee who needs the gadget needs to email the IT department for the need of the stop. Upon the request, it will be checked if there are available peak and and notice is sent to the requestor with regards to the item borrowing. The item is also mon itored if it is in good context and need to be replaced by a late one. All transactions must be logged in Microsoft Excel so it will be documented.Once there is a need to purchase a new item, the purchasing department must be notified. The purchasing process is also monitored using manual inputting data in Microsoft Excel. As the IT department notified the purchasing department that the need of item is situated, they will assess the parliamentary law of the item from a supplier. And once the item is delivered by the supplier, It will be documented in the Excel that the item is now purchased. Statement of the Project Scope This come out will cover the Employee Profiling formation, Inventory Tracking System and Purchasing System of Sagittarius Mines Inc. . Employee Profiling The Proposed system limits barely in the sustainment of employee profile and creating luxuriant and efficient employee profile report to all present and past employees whether regular, probationary, cont ractual, or contractors. 2. Inventory Tracking The Proposed System focuses on tracking the deployment of items(gadgets), the returning, the condition of item and creating fast and efficient inventory report of all items borrowed and returned by every employee of SMI. 3. Purchasing item delivery, purchasing order, maintain supplier list, item maintenanceThe Proposed System limits only with the delivery of the compass point from the purchasig departemt to the IT department, the purcharing order, maintenance of the suppliers and items. The areas covered by the project are department of IT department, HR department and Purchasing department concerning to profiling, item inventory and purchasing. II. CONCEPTUAL DESIGN 2. 1 obtain enjoin View 2. 1. 1 Employee Requests fact Entity Employee Characteristics EmployeeID, F spend a penny, L cook, Emp address, massageLocationID, patchID, view, patienceDate, Team no. DeprtmentNo, StartDate, EndDate, ContactNo, Employment casefulNo.Entity secure rove exposit Characteristics PODNo, PPOCreationDate, POOrderDate, EmployeeID Entity Purchase concomitant Details Characteristics PIDNo, measuring, PODNO, supplier ID, COst, Remarks, Description, PO concomitantNo 2. 1. 2 supplier Delivers fact Entity supplier Characteristics supplierID, Company construct, send, ContactNo, EmailAddress Entity Purchase incident Details Characteristics PIDNo, Quantity, PODNo, Supplier ID, COst, Remarks, Description, PO stopNo Entity particular Characteristics straight No, Device characterNo, Received stageNo, monetary value, locating, ItemType, DateReceived, spoken languageDate, Delivery place . 2 Deliver Items View 2. 2. 1 Employee Delivers Item Entity Employee Characteristics EmployeeID, F earn, L anticipate, EmpAddress, WorkLocationID, positionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo. Entity Purchase Item Details Characteristics PIDNo, Quantity, PODNO, Supplier ID, COst, Remarks, Description, POItemNo, Entity Item Characteristics Serial No, DeviceTypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus 3. 1 Items View 3. 1. 1 Employee Borrowed Item Entity EmployeeCharacteristics EmployeeID, FName, LName, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo. Entity give way Item Characteristics RenderedItemNo, DateRendered, SerialNo, Employee ID Entity Item Characteristics Serial No, DeviceTypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 2 Employee Returns Item Entity Employee Characteristics EmployeeID, FName, LName, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo.Entity Return Item Characteristics ReturnItemNo, ReturnDate, Remarks, RenderedItemNo, SerialNo Entity Item Characteristics Serial No, DeviceT ypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 3 Employee Lost Item Entity Employee Characteristics EmployeeID, FName, LName, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo. Entity Lost Item Characteristics LostItemNo, DateLost, Remarks, EmployeeID, SerialNo Entity ItemCharacteristics Serial No, DeviceTypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 4 Employee Donate Item Entity Employee Characteristics EmployeeID, FName, LName, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo. Entity Donate Item Characteristics giftItemNo, DonationDate, Status, EmployeeID, SerialNo Entity Item Characteristics Serial No, DeviceTypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 5 Employee hit the hay Item Entity EmployeeCharacteristics EmployeeID, FName, LName, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo. Entity Retire Item Characteristics RetiredItemNo, RetiredDate, Status, EmployeeID, SerialNo Entity Item Characteristics Serial No, DeviceTypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 6 Employee Request haunt Item Entity Employee Characteristics EmployeeID, FName, LName, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo.Entity Repair Request Characteristics RepairRequestNo, RequestDate, RepairStatus, DoneDate, , Employee ID Entity Item Characteristics Serial No, DeviceTypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus III. system of logical Design 1. serviceable Dependencies Item submit 3NF SerialNo -gt Device Type No. , Received Item No. , Cost, Status, Item Type Device Type Table 3NF DeviceTypeNo -gt Type, Model , daub Communication operate Table 3NF AccountNo -gt Item_Serial No. , MIN, IMEI, PlanStartDate, PlanEndDate, Status, Remarks, PlanCost, Employee ID Inventory Table 2NF sellNo -gtDisposalDate, Status, Employee ID, SerialNo RetiredItemNo -gt RetiredDate, Status, Employee ID, SerialNo RendereditemNo -gtDateRendered, Employee ID, Serial No. Donation Item No -gt DonationDate, Status, Employee ID, SerialNo ReturnItemNo -gt ReturnDate, Remark, RendereditemNo, SerialNo LostItemNo -gt DateLost, Remarks, Employee ID, SerialNo 3NF Decomposition of Inventory Dispose Item 3NF dramatics Name DisposeNo PK DisposalDate Status Employee ID FK SerialNo FK DisposeNo -gtDisposalDate, Status, Employee ID, SerialNo Return Item 3NF field Name RetiredItemNo PK ReturnDate Status Employee ID FK SerialNo FK RetiredItemNo -gt RetiredDate, Status, Employee ID, SerialNo RenderedItem 3NF top ic Name RenderedItemNo PK DateRendered Status Employee ID FK SerialNo FK RendereditemNo -gtDateRendered, Employee ID, SerialNo DonationItem 3NF sector Name DonationItemNo PK DonationDate Status Employee ID FK SerialNo FK Donation Item No -gt DonationDate, Status, Employee ID, SerialNo ReturnItem 3NF sphere of influence Name ReturnItemNo PK ReturnDate Status RendereditemNo FK SerialNo FK ReturnItemNo -gt ReturnDate, Remark, RendereditemNo, SerialNoLostItem 3NF handle Name LostItemNo PK DateLost Remarks Employee ID FK SerialNo FK LostItemNo -gt DateLost, Remarks, Employee ID, SerialNo PurchaseTable 2NF PIDNo -gt Quantity, PODNo, Supplier ID, Cost, Remarks, Description, POItemNo PODNo -gt POCreationDate, POOrderDate, Employee_Employee ID ReceivedItemNo -gt DateReceived, Remarks, PIDNo DeliveryNo-gt DeliveryStatus, DeliveryDate, ReceivedItemNo, Datereceived 3NF Decomposition of Purchase Purchase Item Details 3NF handle Name PIDNo PK Quantity PODNo FK Supplier ID FK Cos t Remarks Description POItemNo PIDNo -gt Quantity, PODNo, Supplier ID, Cost, Remarks, Description, POItemNo Purchase Order Details 3NF Field Name PODNo PK POCreationDate POOrderDate Employee ID FK PODNo -gt POCreationDate, POOrderDate, Employee ID ReceivedItem 3NF Field Name ReceivedItemNo PK DateReceived Remarks PIDNo FK ReceivedItemNo -gt DateReceived, Remarks, PIDNo Delivery Item3NF Field Name DeliveryNo PK DeliveryStatus DeliveryDate ReceivedItemNo Datereceived DeliveryNo-gt DeliveryStatus, DeliveryDate, ReceivedItemNo, Datereceived Supplier Table 3NFSupplier ID -gt CompanyName, Address, ContactNo, EmailAddress Employee Table 2NF Employee ID -gt Fname, Lname, Mname, EmpAddress, Work Location, Position ID, Status, Resignation Date, TeamNo, plane sectionNo, Startdate, Enddate, EmploymentTypeNo TeamNo -gt TeamName, DepartmentNo, EmployeeID DepartmentNo gt DepartmentName PositionNo -gt PositionTitle, Level WorkLocationNo -gt WorkLocationName EmploymentTypeNo -gt Emplo ymentType 3NF Decomposition of Employee Employeesummary 3NF Field Name Employee ID PK Fname Lname Mname EmpAddress Work Location FK Position ID FK Status ResignationDate TeamNo FK DepartmentNo FK Startdate Enddate EmploymentTypeNo FK Employee ID -gt Fname, Lname, Mname, EmpAddress, Work Location, Position ID, Status, Resignation Date, TeamNo, DepartmentNo, Startdate, Enddate, EmploymentTypeNo Team 3NF Field Name TeamNo PK TeamName DepartmentNo FK EmployeeID FK TeamNo -gt TeamName, DepartmentNo, EmployeeID Department 3NF Field Name DepartmentNo PK DepartmentName DepartmentNo gt DepartmentName Position 3NF Field Name PositionNo PK PositionTitle Level PositionNo -gt PositionTitle, Level EmploymentType 3NFField Name EmploymentTypeNo PK EmploymentType EmploymentTypeNo -gt EmploymentType IV. Physical Design 1. Team Field Name entropy Type simple primordial Nullable TeamNo INT Yes No TeamName VARCHAR(50) No No DepartmentNo INT No No EmployeeID INT No No a. Indeces Index _01 on TeamNo for primitive find out Index_02 on TeamName b. denotative equity b. 1 Employee. TeamNo on take confine on update shower c. design logical system c. 1 2. Department Field Name entropy Type patriarchal get wind Nullable DepartmentNo INT Yes No DepartmentName VARCHAR(50) No No a. Indeces Index_01 on DepartmentNo for basal aboriginalIndex_02 on DepartmentName b. denotative righteousness b. 1 Employee. DepartmentNo on wipe out secure on update shower b. 2 Team. DepartmentNO on efface strangulate on UP naming fall c. Program system of logic c. 1 Inserting a New Item 3. Work Location Field Name entropy Type primal nominate Nullable WorkLocationNo INT Yes No WorkLocationName VARCHAR(50) No No a. Indeces Index_01 on WorkLocationNo for prime primaeval Index_02 on WorkLocationName b. Referential wholeness b. 1 Employee. WorkLocationNo on scrub border on modify cascade down c. Program Logic c. 1 4. Position Field Name selective information Type ol d Key NullablePositionNo INT Yes No PositionTitle VARCHAR(50) No No Level VARCHAR(50) No No a. Indeces Index_01 on PositionNo for uncomplicated Key Index_02 on PositionTitle Index_03 on Level b. Referential Integrity b. 1 Employee. PositionNo on set off fasten on modify descend c. Program Logic c. 1 5. Employment Type Field Name Data Type Primary Key Nullable EmploymentTypeNo INT Yes No EmploymentType VARCHAR(50) No No a. Indeces Index_01 on Employment TypeNo for Primary Key Index_02 on EmploymentType b. Referential Integrity b. 1 Employee. EmploymentType on score out oblige on UP go through cascade down c. Program Logic . 1 6. Employee Field Name Data Type Primary Key Nullable EmploymentID INT Yes No Fname VARCHAR(50) No No Lname VARCHAR(50) No No Mname VARCHAR(50) No No EmpAddress INT No No WorkLocationNo INT No No PositionID INT No No Status VARCHAR(20) No NO ResignationDate DATE No No TeamNo INT No No DepartmentNo INT No No StartDate DATE No No EndDate DATE No No Contac tNo INT No No EmplomentTypeNo INT No No a. Indeces Index_01 on EmploymentID for Primary Key Index_02 on Fname Index_03 on Lname Index_04 on Mname Index_05 on EmpAddress Index_06 on WorkLocationNoIndex_07 on PositionID Index_08 on Status Index_09 on ResignationDate Index_10 on TeamNo Index_11 on DepartmentNo Index_12 on StartDate Index_09 on EndDate Index_10 on ContactNo Index_11 on EmploymentTypeNo b. Referential Integrity b. 1 Team. EmployeeID on DELETE determine on update Cascade b. 2 PurchaseOrderDetail. EmployeeID on DELETE Restrict on modify Cascade b. 3 CommunicationServices. EmployeeID on DELETE Restrict on UPDATE Cascade b. 4 RenderedItem. EmployeeID on DELETE Restrict on UPDATE Cascade b. 5 DisposedItem. EmployeeID on DELETE Restrict on UPDATE Cascade b. 6 RetiredItem. EmployeeID n DELETE Restrict on UPDATE Cascade b. 7 DonationItem. EmployeeID on DELETE Restrict on UPDATE Cascade b. 8 LostItem. EmployeeID on DELETE Restrict on UPDATE Cascade b. 9 RepairRequest. Employee ID on DELETE Restrict on UPDATE Cascade c. Program Logic c. 1 7. Purchase Order Details Field Name Data Type Primary Key Nullable PODNO INT Yes No POCreationDate DATE No No POOrderDate DATE No No EmployeeID INT No No a. Indeces Index_01 on PODNo for Primary Key Index_02 on POCreationDate Index_03 on POOrderDate b. Referential Integrity b. 1 PurchaseItemDetails. PODNo on DELETE Restrict on UPDATE Cascade . Program Logic c. 1 8. Supplier Field Name Data Type Primary Key Nullable SupplierID VARCHAR(20) Yes No CompanyName VARCHAR(50) No No Address VARCHAR(80) No No ContactNo INT No No EmailAddres VARCHAR(30) No No a. Indeces Index_01 on SupplierID for Primary Key Index_02 on CompanyName Index_03 on Address Index_04 on ContactNo Index_05 on EmailAddress b. Referential Integrity b. 1 PurchaseItemDetails. SupplierID on DELETE Restrict on UPDATE Cascade c. Program Logic c. 1 9. Item Field Name Data Type Primary Key Nullable SerialNo VARCHAR(45) Yes No DeviceTypeNo INT No NoReceivedItemNo INT No No Cost in two ways No No Status VARCHAR(45) No No ItemType VARCHAR(45) No No PIDNo INT No No a. Indeces Index_01 on SerialNo for Primary Key Index_02 on Cost Index_03 on Status b. Referential Integrity b. 1 CommunicationServices. SerialNo on DELETE Restrict on UPDATE Cascade b. 2 RenderedItem. SerialNo on DELETE Restrict on UPDATE Cascade b. 3 DisposedItem. SerialNo on DELETE Restrict on UPDATE Cascade b. 4 RetiredItem. SerialNo on DELETE Restrict on UPDATE Cascade b. 5 DonationItem. SerialNo on DELETE Restrict on UPDATE Cascade b. 6 RepairRequest. SerialNo on DELETE Restrict n UPDATE Cascade b. 7 LostItem. SerialNo on DELETE Restrict on UPDATE Cascade c. Program Logic c. 1 10. DeviceType Field Name Data Type Primary Key Nullable DeviceTypeNo INT Yes No Type VARCHAR(20) No No Model VARCHAR(20) No No Brand VARCHAR(20) No No a. Indeces Index_01 on DeviceTypeNO for Primary Key Index_02 on Type Index_03 on Model Index_04 on Brand b. Referential Integrity b. 1 Item. DeviceType No on DELETE Restrict on UPDATE Cascade c. Program Logic c. 1 11. Purchase Item Detail Field Name Data Type Primary Key Nullable PIDNo INT Yes No Quantity VARCHAR(45) No NoPODNo INT No No SupplierID VARCHAR(20) No No Cost DOUBLE No No Remarks VARCHAR(100) No Yes Description VARCHAR(100) No No POItemNo. INT No No DateReceived DATE No No DeliveryDate DATE No Yes DeliveryStatus VARCHAR(45) No No a. Indeces Index_01 on PIDNO for Primary Key Index_02 on Quantity Index_03 on Cost Index_04 on Remarks Index_05 on Description Index_06 on POItemNo Index_07 on DateReceived Index_08 on DeliveryDate Index_09 on DeliveryStatus b. Referential Integrity b. 1 Item. PIDNO on DELETE Restrict on UPDATE Cascade c. Program Logic c. 1 V. final Class Diagram