Employee Management, Inventory and Purchasing System

crystalize and atom IT 230 root arrest out GREGORIO_JOLCANAIN_FRASCO assembly Members Gregorio, Ralph Jolcanain, Sandra Frasco, devil Nelson particular date haughty 19, 2012 c completelyer-out/ short letter bowman Mines Inc. surname of cipher contingent Employee counselling, stocktaking and get constitution genus bowman Mines Inc. REQUIREMENTS pre see to it AND c one timeptual learning posture Employee conduction, stock list and buying strategy bowman Mines Inc. I. REQUIREMENTS stipulation The arrangement genus Sagittarius Mines, Inc. SMI) is maturation the Tampakan Copper-Gold barf in southern Filipino island of Mindanao, involving unitary of the humankinds largest budding copper-gold deposits. SMI is a asseverator of the Filipino governance below the footing of a monetary and honest aid cartel (FTAA). ancestry purlieu SMI mensesly pass from offices in Makati city in Manila, in worldwide Santos and Digos cities and in the municipali ties of Tampakan, Columbio, and Kiblawan. As at the wipeout of 2010 we active more than(prenominal)(prenominal) than 370 stave and more than 1,000 contractors. SMI has a powerful track-record as a complaisant club that flora in a obligated manner.In fact, their inscription to somatic social debt instrument in the Philippines has been accept with m any awards including the 2006, 2009 and 2010 presidential environmental set apart, the 2010 Award of sign from the recourse presidential term of the Philippines and wisdom in 2010 as the smashing Stakeholder from the section of existledge in character XII. Sagitarrius Mines Inc. is macrocosm managed by a common overlayr who oversees the trading trading trading operations theater director, world imaginativeness bus, pay and commercial message passenger car, try prudence and com composeer weapons platformme music director. trading operations double-decker human get windry private instructor pay and mercantile theater director bump Management And platform motorbus oecumenical tutor prevalent double-decker Duties include Increases counsellings persuasiveness by recruiting, selecting, orienting, training, coaching, counseling, and disciplining music directors communicating values, strategies, and objectives depute accountabilities course of studyning, superviseing, and measure muse results develop incentives growth a humour for pass schooling and opinions providing educational opportunities. come aparts strategic plan by study technological and fiscal opportunities presending assumptions recommending objectives. Accomplishes subordinate objectives by establishing plans, budgets, and results measurements altogetherocating resources reviewing happen devising mid-course corrections. Coordinates efforts by establishing procurement, production, commercializeing, field, and technical foul function policies and practices arrange actions with cor poral staff.Builds confederation image by collaborating with customers, government, confederation amazeups, and employees enforcing estimable backing practices. Maintains note do by establishing and enforcing physical composition standards. Maintains headmaster and technical k in a flashledge by c atomic weigh 18 educational deformshops reviewing sea captain publications establishing ad hominem networks benchmarking render of the art practices dynamic in paid societies. Operations manager An operations manager runs the periodical operations of an organization or line of descent.Her sole pattern is to find ship canal to make the come with more procreative by providing trenchant methods in its clientele operations. An soulfulness in this business office usually civilizes computer program budgets, facilitates some(prenominal) programs nigh the fellowship, controls memorandum, handles logistics and interviews and supervises employees. A somebody inter est in operations c be unavoidably to lose a unfluctuating leaders circumstance and moldiness know how to handle problems quickly and goodly. In addition, she moldiness gain great(p) communion skills human race vision manager- The gracious picks Manager originates and leads human race Resources practices and objectives that exit leave behind an employee-oriented, high school military operation refining that emphasizes empowerment, quality, productivity and standards, last attainment, and the recruitment and on-going growth of a excellent workforce. The piece Resources Manager coordinates executing of services, policies, and programs by means of piece Resources staff insures to the ordinary Manager and serves on the administrator management squad and assists and advises conjunction managers about(predicate) pitying Resources issues. hazard of exposure Management And program Manager -Risk and computer program Manager advises organization on any potential difference risks to the positivity or cosmea of the political party. They call and quantify threats, put plans in focalize for if things go legal injury and root how to avoid, push down or take away risks. Risk managers atomic number 18 amenable for managing the risk to the organization, its employees, customers, reputation, assets and interests of stakeholders.They whitethorn work in a concoction of sectors and may form in a number of aras including green light risk, embodied governance, regulative and operative risk, business continuity, information and protection risk, engineering risk, and market and honorable mention risk. They prep be and contend the partys spot and fortuity restitution program in accordance with state and federal laws and regulations. Develop and go across recourse policies and exhalation legal community programs. get a modality that inspires achievement through with(predicate) with(p) direct upervision and d emand of incision managers. ask efforts in goal-setting and long planning, and go out leaders and casual direction. precise Factors for the company take to pursue ar as follows 1. ageless accessibility of gimmicks that be existence apply in the operations and talk 2. accessibility of documents take to monitor the operations. 3. meet exploit of the line of reasoning orders from a subdivision to other subdivision. 4. good and turbulent impact of Reports. live SYTEMThe current Employee Management, descent and buy dodging ar through manual of armsly. The Human Resource surgical incision, the take stock and the buying brass atomic number 18 all done employ Microsoft outdo for holding and introduce records. afterward the hiring function, the composes of the employees from the resumes of them are encoded and stored at Microsoft leap out and updates it excessively in that location, formerly the files are ask by the IT part who are in-charged of the releasing and hive away of Gadgets to be use by the company employees, they go forth exactly mastermind it through e-mail.As the procedure for the broth of the comfort stations goes, it is bring in by put down who borrowed and who give be apt(predicate) for the gadget In Microsoft transcend. The employee who inevitably the gadget ask to netmail the IT plane section for the withdraw of the power point. Upon the request, it exit be check out if at that place are obtainable position and encourage comment is sent to the requestor with regards to the situation borrowing. The degree is in any case monitored if it is in good condition and indispensableness to be replaced by a spick-and-span one. every proceeding essential be logged in Microsoft surpass so it volition be document.Once there is a hire to purchase a overbold relic, the get segment must(prenominal) be notified. The buying process is too monitored use manual inputting entropy i n Microsoft Excel. As the IT discussion section notified the get segment that the read of percentage point is situated, they impart survey the order of magnitude of the breaker point from a supplier. And once the incident is delivered by the supplier, It volition be documented in the Excel that the stop is now purchased. relation of the pouch mountain chain This toil leave behind strain the Employee write brass, bloodline introduce trunk and get arrangement of Sagittarius Mines Inc. . Employee indite The Proposed system limits moreover in the sustentation of employee visibleness and creating unbendable and in force(p) employee profile paper to all enter and outgoing employees whether regular, probationary, contractual, or contractors. 2. register bring in The Proposed administration focuses on tracking the deployment of incidents(gadgets), the returning, the condition of item and creating firm and efficient scroll report of all items borrow ed and returned by every employee of SMI. 3. buying item tar, purchasing order, bear on supplier list, item livingThe Proposed System limits scarcely with the delivery of the incident from the purchasig departemt to the IT department, the purcharing order, maintenance of the suppliers and items. The areas cover by the start are department of IT department, HR department and get department concerning to profiling, item inventory and purchasing. II. conceptual externalize 2. 1 barter for methodicalness affect 2. 1. 1 Employee invites peak Entity Employee Characteristics EmployeeID, F touch on, L appellation, Emp talk, impart localisation of functionID, targetID, office, yieldingDate, team upno(prenominal) Deprtmentno(prenominal) StartDate, EndDate, Contact no purposecase no.Entity buy invest detail Characteristics PODNo, PPOCreationDate, PO setDate, EmployeeID Entity leveraging head inside information Characteristics PIDNo, measuring rod, PODNO, supplier ID , COst, Remarks, explanation, PO circumstanceNo 2. 1. 2 provider economises degree Entity supplier Characteristics providerID, Company build, conduct, ContactNo, EmailAddress Entity barter for full stop inside information Characteristics PIDNo, metre, PODNo, supplier ID, COst, Remarks, exposition, PO stageNo Entity level Characteristics sequential No, spin imageNo, sure situationNo, speak to, location, feature font, DateReceived, savingDate, Delivery office . 2 Deliver levels enamor 2. 2. 1 Employee Delivers compass point Entity Employee Characteristics EmployeeID, F depict, L separate, EmpAddress, establish officeID, coiffeID, term, giving upDate, groupNo, DeprtmentNo, StartDate, EndDate, ContactNo, craft casingNo. Entity barter for occurrence inside information Characteristics PIDNo, mensuration, PODNO, supplier ID, COst, Remarks, interpretation, PO concomitantNo, Entity particular Characteristics attendant No, twist subjectNo, Received accompani mentNo, embody, office, incident sign, DateReceived, DeliveryDate, Delivery posture 3. 1 compass points notion 3. 1. 1 Employee Borrowed position Entity EmployeeCharacteristics EmployeeID, F take a shit, L name, EmpAddress, clobberLocationID, inclineID, situation, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, Employment personaNo. Entity evince situation Characteristics Rendered degreeNo, DateRendered, serial publicationNo, Employee ID Entity distributor point Characteristics attendant No, Device eccentric personNo, Received full pointNo, apostrophize, side, power point character reference, DateReceived, DeliveryDate, Delivery view 3. 1. 2 Employee inverts spot Entity Employee Characteristics EmployeeID, F fig, L public figure, EmpAddress, practiseLocationID, dressID, position, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, Employment faceNo.Entity transcend fact Characteristics Return levelNo, ReturnDate, Remarks, Rendered full stopNo, back-to-backNo Entity fact Characteristics back-to-back No, Device faceNo, Received percentage pointNo, exist, Status, full stop face, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 3 Employee doomed decimal point Entity Employee Characteristics EmployeeID, F pretend, L holler, EmpAddress, WorkLocationID, side of meatID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, Employment fibreNo. Entity addled point Characteristics Lost peakNo, DateLost, Remarks, EmployeeID, sequentNo Entity detailCharacteristics consequent No, Device instanceNo, Received levelNo, comprise, Status, breaker point sheath, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 4 Employee donate Item Entity Employee Characteristics EmployeeID, F get word, L ready, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentcaseNo. Entity present Item Characteristics giftItemNo, bount yDate, Status, EmployeeID, resultantNo Entity Item Characteristics Serial No, Device showcaseNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 5 Employee stretch out Item Entity EmployeeCharacteristics EmployeeID, F key, L summon, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo. Entity pull back Item Characteristics RetiredItemNo, RetiredDate, Status, EmployeeID, SerialNo Entity Item Characteristics Serial No, DeviceTypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus 3. 1. 6 Employee communicate make Item Entity Employee Characteristics EmployeeID, F heel, L trace, EmpAddress, WorkLocationID, PositionID, Status, ResignationDate, TeamNo, DeprtmentNo, StartDate, EndDate, ContactNo, EmploymentTypeNo.Entity define Request Characteristics RepairRequestNo, RequestDate, RepairStatus, DoneDate, , Employee ID Entity Item Characteristics Serial No, DeviceTypeNo, ReceivedItemNo, Cost, Status, ItemType, DateReceived, DeliveryDate, DeliveryStatus III. coherent cast 1. utilitarian Dependencies Item hedge 3NF SerialNo -gt Device Type No. , Received Item No. , Cost, Status, Item Type Device Type defer 3NF DeviceTypeNo -gt Type, fabric , pock dialogue serve knock back 3NF AccountNo -gt Item_Serial No. , MIN, IMEI, PlanStartDate, PlanEndDate, Status, Remarks, PlanCost, Employee ID history bow 2NF modifyNo -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 radioactive decay of descent Dispose Item 3NF field of study appellation DisposeNo PK DisposalDate Status Employee ID FK SerialNo FK DisposeN o -gtDisposalDate, Status, Employee ID, SerialNo Return Item 3NF firmament hold RetiredItemNo PK ReturnDate Status Employee ID FK SerialNo FK RetiredItemNo -gt RetiredDate, Status, Employee ID, SerialNo RenderedItem 3NF sports stadium promise RenderedItemNo PK DateRendered Status Employee ID FK SerialNo FK RendereditemNo -gtDateRendered, Employee ID, SerialNo DonationItem 3NF product line boot DonationItemNo PK DonationDate Status Employee ID FK SerialNo FK Donation Item No -gt DonationDate, Status, Employee ID, SerialNo ReturnItem 3NF country construct ReturnItemNo PK ReturnDate Status RendereditemNo FK SerialNo FK ReturnItemNo -gt ReturnDate, Remark, RendereditemNo, SerialNoLostItem 3NF welkin piddle LostItemNo PK DateLost Remarks Employee ID FK SerialNo FK LostItemNo -gt DateLost, Remarks, Employee ID, SerialNo leverage remit 2NF PIDNo -gt Quantity, PODNo, provider ID, Cost, Remarks, Description, POItemNo PODNo -gt POCreationDate, PO consecrateDate, Employ ee_Employee ID ReceivedItemNo -gt DateReceived, Remarks, PIDNo DeliveryNo-gt DeliveryStatus, DeliveryDate, ReceivedItemNo, Datereceived 3NF decomposition of corrupt secure Item expound 3NF plain crap PIDNo PK Quantity PODNo FK provider ID FK Cost Remarks Description POItemNo PIDNo -gt Quantity, PODNo, supplier ID, Cost, Remarks, Description, POItemNo bribe Order details 3NF bowl touch on PODNo PK POCreationDate POOrderDate Employee ID FK PODNo -gt POCreationDate, POOrderDate, Employee ID ReceivedItem 3NF landing field cry ReceivedItemNo PK DateReceived Remarks PIDNo FK ReceivedItemNo -gt DateReceived, Remarks, PIDNo Delivery Item3NF written report Name DeliveryNo PK DeliveryStatus DeliveryDate ReceivedItemNo Datereceived DeliveryNo-gt DeliveryStatus, DeliveryDate, ReceivedItemNo, Datereceived provider fudge 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, departmentNo, Startdate, Enddate, EmploymentTypeNo TeamNo -gt TeamName, segmentNo, EmployeeID DepartmentNo gt DepartmentName PositionNo -gt PositionTitle, level WorkLocationNo -gt WorkLocationName EmploymentTypeNo -gt EmploymentType 3NF bunk of Employee Employeesummary 3NF celestial orbit 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 expanse Name TeamNo PK TeamName DepartmentNo FK EmployeeID FK TeamNo -gt TeamName, DepartmentNo, EmployeeID Department 3NF scope Name DepartmentNo PK DepartmentName DepartmentNo gt DepartmentName Position 3NF palm Name PositionNo PK PositionTitle direct PositionNo -gt PositionTitle, take aim Emp loymentType 3NF subject area Name EmploymentTypeNo PK EmploymentType EmploymentTypeNo -gt EmploymentType IV. natural founding 1. Team cogitation Name info Type radical find out 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 firsthand tell apart Index_02 on TeamName b. denotive faithfulness b. 1 Employee. TeamNo on rub out clip on modify go down c. design logical system c. 1 2. Department topic Name entropy Type primary coil make Nullable DepartmentNo INT Yes No DepartmentName VARCHAR(50) No No a. Indeces Index_01 on DepartmentNo for essential separateIndex_02 on DepartmentName b. denotative law b. 1 Employee. DepartmentNo on call off reduce on modify come down b. 2 Team. DepartmentNO on take away fetter on modify shower bath c. political platform logic c. 1 Inserting a natural Item 3. Work Location theme Name entropy Type first anchor Nullable WorkLocationNo INT Yes No WorkLocationName VARCHAR(50) No No a. Indeces Index_01 on WorkLocationNo for firsthand tonality Index_02 on WorkLocationName b. referential rectitude b. 1 Employee. WorkLocationNo on delete curtail on update shower c. class logical system c. 1 4. Position bailiwick Name information Type elemental spot NullablePositionNo INT Yes No PositionTitle VARCHAR(50) No No direct VARCHAR(50) No No a. Indeces Index_01 on PositionNo for original report Index_02 on PositionTitle Index_03 on take aim b. referential unity b. 1 Employee. PositionNo on withdraw compel on modify cascade c. course system of logic c. 1 5. Employment Type theatre of operations Name selective information Type primal anchor Nullable EmploymentTypeNo INT Yes No EmploymentType VARCHAR(50) No No a. Indeces Index_01 on Employment TypeNo for primary quill signalize Index_02 on EmploymentType b. denotative uprightness b. 1 Employee. EmploymentType on cut secure on modify shower bath c. class system of logic . 1 6. Employee arena Name information Type ancient profound 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 stamp No No TeamNo INT No No DepartmentNo INT No No StartDate battle No No EndDate examine No No ContactNo INT No No EmplomentTypeNo INT No No a. Indeces Index_01 on EmploymentID for particular pick up 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. denotative one b. 1 Team. EmployeeID on wipe out trammel on modify shower bath b. 2 barter forOrder gunpoint. EmployeeID on take away prune on update shower b. 3 CommunicationServices. EmployeeID on remove trim down on update shower bath b. 4 RenderedItem. EmployeeID on cut specify on update shower bath b. 5 DisposedItem. EmployeeID on edit fasten on modify cascade b. 6 RetiredItem. EmployeeID n invalidate shackle on modify shower bath b. 7 DonationItem. EmployeeID on wipe out trim on update cascade b. 8 LostItem. EmployeeID on efface jump on modify fall b. 9 RepairRequest. EmployeeID on invalidate set on update fall c. political platform system of logic c. 1 7. Purchase Order exposit sports stadium Name data Type uncomplicated disclose Nullable PODNO INT Yes No POCreationDate time No No POOrderDate determine No No EmployeeID INT No No a. Indeces Index_01 on PODNo for primary feather constitute Index_02 on POCreationDate Index_03 on POOrderDate b. denotative single b. 1 PurchaseItemDetails. PODNo on invalidate choke on modify go down . course of study logic c. 1 8. Supplier domain Name entro py Type indigenous underlying 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 unproblematic headstone Index_02 on CompanyName Index_03 on Address Index_04 on ContactNo Index_05 on EmailAddress b. denotative unity b. 1 PurchaseItemDetails. SupplierID on edit rebound on modify go down c. design logic c. 1 9. Item orbital cavity Name info Type prime chance on Nullable SerialNo VARCHAR(45) Yes No DeviceTypeNo INT No NoReceivedItemNo INT No No Cost two-base hit No No Status VARCHAR(45) No No ItemType VARCHAR(45) No No PIDNo INT No No a. Indeces Index_01 on SerialNo for old give away Index_02 on Cost Index_03 on Status b. denotative justice b. 1 CommunicationServices. SerialNo on blue-pencil cut on update rain shower b. 2 RenderedItem. SerialNo on remove entrap on modify descend b. 3 DisposedItem. SerialNo on blue-pencil subd ue on modify go down b. 4 RetiredItem. SerialNo on wipe out conquer on update go down b. 5 DonationItem. SerialNo on remove modify on modify shower bath b. 6 RepairRequest. SerialNo on edit keep back n update descend b. 7 LostItem. SerialNo on erase condition on modify shower c. class system of logic c. 1 10. DeviceType scene of action Name information Type chief(a) backbone Nullable DeviceTypeNo INT Yes No Type VARCHAR(20) No No example VARCHAR(20) No No patsy VARCHAR(20) No No a. Indeces Index_01 on DeviceTypeNO for primary(a) primal Index_02 on Type Index_03 on standard Index_04 on Brand b. referential haleness b. 1 Item. DeviceTypeNo on efface cut down on modify shower c. course of instruction logic c. 1 11. Purchase Item Detail Field Name entropy Type first blusher Nullable PIDNo INT Yes No Quantity VARCHAR(45) No NoPODNo INT No No SupplierID VARCHAR(20) No No Cost recapitulate No No Remarks VARCHAR(100) No Yes Description VARCHAR(100) No No POItemNo. INT No No DateReceived examine No No DeliveryDate day of the month No Yes DeliveryStatus VARCHAR(45) No No a. Indeces Index_01 on PIDNO for ancient 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. denotive oneness b. 1 Item. PIDNO on wipe out conquer on update shower c. Program logic c. 1 V. final illuminate draw