ppt课件-geneticengineeringbenefits-jeffersonlab.pptVIP

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 databases tables. Example mySQL vs. Excel DATA Dynamic Interrelated Tables CENTRAL Old vs. New OLD: /MagTest/www/SpareItemsIndex.html NEW /MagTest/www/Inventory/ What’s Been Done PHP Programming ? Internet based front end database management system Input of all current magnet inventory Initial field maps How to… You should now see a table for either all inventory or the specified search. How to…. Type in username password. Select ‘MagtestDB’ on the left panel drop down bar. Select a table. Choose an action. Another method… /MagTest/www/Inventory/ Conclusion * * 23463 3 456 2 12423 1 Picture CORE ID Magnet This is one table of a database… Magnet- 1 CORE ID- 12423 This page utilizes another table in the SAME database… Hence, the word RELATIONAL… Magnet- 2 CORE ID- 456 Yet another… Magnet- 3 CORE ID- 23463 And another… ANALYSIS NOT Dynamic Distinct Tables SCATTERED START: /MagTest View and lookup data through the web pages 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. 0 yes no Test Lab 34-98 Coil 0 yes no Test Lab QD 21 Coil Picture Drawing Number Operational On Loan Location Core ID Magnet Style Click to see pictures Enter new data into the database through phpMyAdmin /phpMyAdmin/ START: BROWSE STRUCTURE SEARCH INSERT EMPTY DELETE Insert Magnet Inven