Lab Resources Management System

1
Lab Resources Management System

• Team Members
• Chiu Sim Wah
• Choi Pak Hung
• Lau Yan Man

Group 2
2
Presentation Schedule

• Analysis of Problem Findings
• Logical Data Flow Diagram
• Process Descriptions
• Database Descriptions
• Entity Relationship Diagram
• Data Dictionary
• Summary

Group 2
3
Problem Findings

• Keep details of rooms, including lab number,
  location of lab, capacity, facility, have in an
  inefficient way.
• Control the manual system is not efficient
• Waste too much time in initial setup at the
  beginning.
• Exhaust time for making decision on assigning
  duties to technicians.

Group 2
4
Problem Findings (Cont)

• Time for keep track of the inventory control too
  long.
• Waste a lot of time in the procedure of borrowing
  materials to users.
• Unable to generate different kinds of reports for
  analysis and supporting decision-making in
  future.
• Updated lab information cannot be retrieved.

Group 2
5
Logical Data Flow Diagram

• Context Diagram
• Level 0 Diagram
• System Overview
• Level 1 Diagram
• Login Process
• Initial Setup Process
• Computer Configuration Process
• Borrowing Process
• Query Process

Group 2
6
Context Diagram
Group 2
7
Level 0Diagram(System Overview)
8
Process Descriptions

• Login Process
• The first step of the system when the user uses
  the system and check the identify of the user
• Verify User ID, and Password
• If it is valid, Authority is offered

Group 2
9
Process Descriptions (Cont)

• Initial Setup Process
• Setup all the information when the system is not
  already yet.
• Staff Setup
• Administrator give different access right to the
  users and define users details
• Hardware Setup
• Administrator creates Hardware record and stores
  in the database

Group 2
10
Process Descriptions (Cont)

• Initial Setup Process (Cont)
• Software Setup
• Administrator creates Software record and stores
  in the database
• Tools Setup
• Administrator creates Tools record and stores in
  the database
• Facilities Setup
• Administrator create a new tools record and
  stores it in the database

Group 2
11
Process Descriptions (Cont)

• Initial Setup Process (Cont)
• Configuration Standard Setup
• Administrator sets the standard type of computer
  configuration
• Lab Setup
• Administrator sets the lab room information for
  each lab
• The standard configuration and technician room
  associated are also assigned to each lab room

Group 2
12
Process Descriptions (Cont)

• Initial Setup Process (Cont)
• Consumable Setup
• Administrator create a new consumable inventory
  record and stores details in the database

Group 2
13
Process Descriptions (Cont)

• Computer Configuration Process
• To modify the standard of all configuration of
  the system.
• Hardware Configuration
• Technician creates and modifies the hardware
  record and stores in the database
• Software Configuration
• Technician creates and modifies the software
  record and stores in the database

Group 2
14
Process Descriptions (Cont)

• Computer Configuration Process (Cont)
• Tools Configuration
• Technician creates and modifies the tools record
  and stores in the database
• Facilities Configuration
• Technician creates and modifies facilities record
  in the database
• Lab Configuration
• Technician modifies computer configuration
  standard for the lab, and assign extra resources
  for the lab

Group 2
15
Process Descriptions (Cont)

• Computer Configuration Process (Cont)
• Technician Room Configuration
• Technician assigns resources and configuration
  standard to technician room
• Consumable Inventory Configuration
• Technician keep track and update consumable
  inventory

Group 2
16
Process Descriptions (Cont)

• Borrowing Process
• Update the information of the borrower and
  borrowing things.
• Hardware Borrowing
• Technician handles borrowing procedures of
  hardware devices and update the respective
  database with borrowers details

Group 2
17
Process Descriptions (Cont)

• Borrowing Process (Cont)
• Software Borrowing
• Technician handles borrowing procedures of
  software devices an update the respective
  database with borrowers details
• Tools Borrowing
• Technician handles borrowing procedures of tools
  and update the respective database with
  borrowers details

Group 2
18
Process Descriptions (Cont)

• Query Process
• Allow system manager and technician to query
  information about the system.
• Hardware Query
• Administrator and system manager can generate
  hardware reports from this process
• Software Query
• Administrator and system manager can generate
  software reports from this process

Group 2
19
Process Descriptions (Cont)

• Query Process (Cont)
• Tools Query
• Administrator and system manager can generate
  tools reports from this process
• Facilities Query
• Administrator and system manager can generate
  facilities reports from this process

Group 2
20
Process Descriptions (Cont)

• Query Process (Cont)
• Consumable Query
• Administrator and system manager can generate
  consumable inventory reports from this process
• Borrowing Query
• Administrator and system manager can generate
  borrowing reports from this process

Group 2
21
Database Descriptions

• The style of database description is as follow

Group 2
22
Database Descriptions (Cont)

• Its a sample of database record

Primary Key
Group 2
23
Entity Relationship Diagram
Group 2
24
Entity Relationship Diagram (Cont)
borrow

• One or no borrower borrows one or many software.
• At least one technician room associate one or
  many lab room(s).

Group 2
25
Data Dictionary

• A sample of data dictionary

Group 2
26
Data Dictionary (Cont)

• Another sample of data dictionary

Group 2
27
Summary

• After this analysis phase, the proposed system
  have the following advantages
• System Manager keeps track of resources in
  efficient way
• Administrator uses less time to initialize system
  setup
• Technicians can handle the borrowing procedure
  efficiently
• Reports can be generated from the computerized
  system for future plan

Group 2
28
Summary (Cont)

• Advantages (Cont)
• The licenses of software are easier to maintain
  with the computerized system
• With efficient inventory control
• Computer configuration and any updating of
  resources can be controlled by technician in an
  easy way
• Papers are saved for conservation

Group 2
29
The End
Group 2