1 / 17

Design of a Relational Database Schema for Magnet Inventory Data

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.

jereni
Download Presentation

Design of a Relational Database Schema for Magnet Inventory Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Design of a Relational Database Schema for Magnet Inventory Data Catherine Pao July 26, 2006

  2. Agenda • Relational databases • Database organization • What’s been done • How to: - View / lookup data - Access phpMyAdmin - Enter new data into the database

  3. 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.

  4. Example This is one table of a database…

  5. This page utilizes another table in the SAME database… Magnet- 1 CORE ID- 12423 Hence, the word RELATIONAL…

  6. Yet another… Magnet- 2 CORE ID- 456

  7. And another… Magnet- 3 CORE ID- 23463

  8. DATA Dynamic Interrelated Tables CENTRAL mySQL vs. Excel • ANALYSIS • NOT Dynamic • Distinct Tables • SCATTERED

  9. Old vs. New OLD: http://www.jlab.org/MagTest/www/SpareItemsIndex.html NEW http://www.jlab.org/MagTest/www/Inventory/

  10. What’s Been Done • PHP Programming  Internet based front end database management system • Input of all current magnet inventory • Initial field maps

  11. How to… View and lookup data through the web pages START:www.jlab.org/MagTest

  12. 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.

  13. You should now see a table for either all inventory or the specified search. Click to see pictures

  14. How to…. Enter new data into the database through phpMyAdmin START: https://jmysql.jlab.org/phpMyAdmin/

  15. 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

  16. Another method… http://www.jlab.org/MagTest/www/Inventory/ Magnet Inventory Billet/Misc. Inventory Field Maps Comments Insert

  17. Conclusion

More Related