design of a relational database schema for magnet inventory data catherine pao july 26, 2006
TRANSCRIPT
![Page 1: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/1.jpg)
Design of a Relational Design of a Relational Database Schema for Database Schema for
Magnet Inventory DataMagnet Inventory Data
Catherine Pao
July 26, 2006
![Page 2: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/2.jpg)
Agenda Relational databases Database organization What’s been done How to:
- View / lookup data
- Access phpMyAdmin
- Enter new data into the database
![Page 3: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/3.jpg)
It’s a database system in which any database file can be a component of more than one of the database's tables.
What is a relational database?
![Page 4: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/4.jpg)
Example
Magnet CORE ID Picture
1 12423
2 456
3 23463
This is one table of a database…
![Page 5: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/5.jpg)
Magnet-Magnet- 1 1
CORE ID-CORE ID- 12423 12423
This page utilizes another table in the SAME database…
Hence, the word RELATIONAL…
![Page 6: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/6.jpg)
Magnet-Magnet- 2 2
CORE ID- 456CORE ID- 456
Yet another…
![Page 7: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/7.jpg)
Magnet-Magnet- 3 3
CORE ID- 23463CORE ID- 23463
And another…
![Page 8: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/8.jpg)
mySQL vs. Excel DATA Dynamic Interrelated
Tables CENTRAL
ANALYSIS NOT Dynamic Distinct Tables SCATTERED
![Page 9: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/9.jpg)
Old vs. NewOLD: http://www.jlab.org/MagTest/www/
SpareItemsIndex.html
NEWhttp://www.jlab.org/MagTest/www/
Inventory/
![Page 10: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/10.jpg)
PHP Programming
Internet based front end database
management system Input of all current magnet inventory Initial field maps
What’s Been Done
![Page 11: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/11.jpg)
How to…
START: www.jlab.org/MagTest
View and lookup data through the web pages
![Page 12: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/12.jpg)
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.
![Page 13: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/13.jpg)
You should now see a table for either all inventory or the specified search.
Magnet Style
Core
ID
Location On
Loan
Operational Drawing Number
Picture
Coil QD 21 Test Lab no yes 0
Coil 34-98 Test Lab no yes 0
Click to see pictures
![Page 14: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/14.jpg)
How to….Enter new data into the database
through phpMyAdmin
https://jmysql.jlab.org/phpMyAdmin/
START:
![Page 15: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/15.jpg)
Type in username & password.
Select ‘MagtestDB’ on the left panel drop down bar.
Select a table. Choose an action.
BROWSE
STRUCTURE
SEARCH
INSERT
EMPTY
DELETE
![Page 16: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/16.jpg)
Another Another method…http://www.jlab.org/MagTest/www/Inventory/
Insert
Magnet Inventory
Billet/Misc. Inventory
Field Maps
Comments
![Page 17: Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006](https://reader036.vdocuments.us/reader036/viewer/2022062423/5697c00f1a28abf838cca960/html5/thumbnails/17.jpg)
Conclusion