Transcript Genetic Engineering Benefits

Design of a Relational
Database Schema for
Magnet Inventory Data
Catherine Pao
July 26, 2006
Agenda
 Relational databases
 Database organization
 What’s been done
 How to:
- View / lookup data
- Access phpMyAdmin
- Enter new data into the database
What is a relational database?
It’s a database system in which
any database file can be a
component of more than one of
the database's tables.
Example
This is one table of a database…
Magnet
CORE ID
1
12423
2
456
3
23463
Picture
This page utilizes another table in the SAME database…
Magnet- 1
CORE ID- 12423
Hence, the word RELATIONAL…
Yet another…
Magnet- 2
CORE ID- 456
And another…
Magnet- 3
CORE ID- 23463
mySQL vs. Excel
 DATA
 Dynamic
 Interrelated
Tables
 CENTRAL
 ANALYSIS
 NOT Dynamic
 Distinct Tables
 SCATTERED
Old vs. New
OLD:
http://www.jlab.org/MagTest/www/Sp
areItemsIndex.html
NEW
http://www.jlab.org/MagTest/www/In
ventory/
What’s Been Done

PHP Programming
 Internet based front end database
management system
 Input of all current magnet inventory
 Initial field maps
How to…
View and lookup data through the
web pages
START: www.jlab.org/MagTest
Scroll down. Under Magnet Measurement on
the left panel, click Magnet Measurement
Facility Inventory .
You can now do one of two things-
1. Click ‘SEE ALL’ to view ALL inventory.
OR
2. Indicate type and name by selecting from
the drop down bars.
You should now see a table for either all
inventory or the specified search.
Magnet
Style
Core
ID
Location
On
Operational
Loan
Drawing
Number
Coil
QD 21
Test Lab
no
yes
0
Coil
34-98
Test Lab
no
yes
0
Click to see
pictures
Picture
How to….
Enter new data into the database
through phpMyAdmin
START:
https://jmysql.jlab.org/phpMyAdmin/
Type in username & password.
Select ‘MagtestDB’ on the left panel drop
down bar.
Select a table. Choose an action.
 BROWSE
 INSERT
 STRUCTURE
 EMPTY
 SEARCH
 DELETE
Another method…
http://www.jlab.org/MagTest/www/Inventory/
Magnet Inventory
Insert
Billet/Misc. Inventory
Field Maps
Comments
Conclusion