Transcript Presentation - cason.co.uk

Chemical Storage Information
System
James Cason
Supervisor: Dr Pedro Sampaio
James Cason
What is the system?
• Store information about the storage and
processing of chemicals.
• Make this data accessible to both employees
and customers.
• Customers can check on their orders.
• Employees can see the current state of the
business, i.e. chemical stored in a given
location.
James Cason
System Architecture
Host Machine
Client
Server
Application
Software
Data Store
James Cason
Implementation Strategy
System Attributes
• Web based.
• Implemented using Java.
• Web browser acting as interface to software based on central
server.
• Database stored on central server.
Technology Employed
•
•
•
•
Java
MySQL
PHP scripting language
Linux based web server
James Cason
Functional Requirements
• Storage of chemicals in each individual container.
• Processes to be performed on individual quantities of
chemicals.
• Contact details for individual companies (customers).
• Reports on current and future storage levels.
• Authenticate users as either customers or staff, directing
them to the appropriate system interfaces.
• Reports on tasks to be completed on a given day, i.e.
chemicals arriving, orders completed, processing to take
place.
James Cason
Integrity Constraints
• Identification numbers are to be unique.
• If a contract is to be created the chemicals it refers to
must already be listed in the system.
• If a contract is to be created the company it refers to
must already be listed in the system.
• A chemical cannot be stored in a tank with a capacity
less than the amount of the chemical.
• A chemical cannot be listed as to be stored in a tank
which will still be in use when it arrives. (It will take a day
to prepare a used tank for further storage).
• A company or chemical cannot be removed from the
system while a referenced contract is still in effect
James Cason
Use Case Diagram for Internal Users
System
Add New Contract
«uses»
Add New User
Internal Users
«uses»
«uses»
Add New Storage
Location
Add New Chemical
Move Chemical
Produce Task List
Produce Storage
Location Summary
James Cason
«uses»
Add New Company
Use Case: Add New User
•
•
1.
2.
3.
4.
Intent: The registration of a new user for the
system.
Main Flow of Events:
Specify type of account – internal, external,
administrator, etc.
Record CompanyID.
Assign Username.
Assign Password.
James Cason
Use Case: Add New User
System Users
Internal Users
Ordinary
Administrator
External Users
Mobile
External
• Variation: Requires entry of supervisor username
and password. If not entered the Add New User
process will end.
James Cason
Relationship Diagram
Processing
-ProcessingID
-ProcessingType
-ContractID
-DateProcessing
-ProcessingComplete
StorageLocation
-LocationID
-capacity
-LocationType
*
1
1
Contract
-ContractID
-CompanyName
-ChemicalName
-LocationID
-Amount
1
-Processing
-StartDate
1 -EndDate
Company
-CompanyName
-Address
-PhoneNum
-FaxNum
1
-Email
-website
1
*
1
1
Transfer
-TransferID
-ChemicalName
-LocationID
-ToLocation
-DateToTakePlace
-TransferComplete
1
Chemical
-ChemicalName
-StorageRequirement
James Cason
User
1
-UserID
-password
-UserType
-lastLogonTime
-CompanyName
Implementation
• Database implemented using MySQL.
• Hosted on Linux based web server at
db280.oneandone.co.uk and port 330.
• Database accessed through a set of PHP server side
scripts.
• Main application created as a Java applet.
• Accessed through a HTML web page.
James Cason
Conclusions
• HTML and JavaScript possibly better tools for
implementation.
• Shown strengths and weaknesses of Java applets when
used for this type of application.
• A range of new skills learnt. E.g. PHP, MySQL, More
Java, distributed system.
• Pros and Cons of solo work over teamwork.
James Cason
Further Work
• Having used UML once, now use different methos such
as WebML.
• Possible Team based project to highlight differences
between group and solo work.
James Cason
My Views
• Generally successful.
• Expansion of knowledge in specified domain.
• Experience in using new development tools.
James Cason
Any Questions?
James Cason
Demonstration
James Cason