Chemical inventory system
Chern Pad Chama Dhard Chem Tracker Mad mentory Toalha Demuth Lab Chemical Containers Showing 1-5 resut CAS Number: Container 101 Location Space Shet: Chemical www Demuth Lab - View Lab Profile Chen Tracker Compliance Dashboard - Manage Members Send Lab Message . Bio Summary Chern Summary - Rad Summary -Rad Request Rad Waste Pickup Set Inspections - Manage Lab Forma Research Tools Training Equipment + My Account Chemical Nane CASE et Amount Unt Location Container Bundesh 32 Liquid 29.000000 14 Bold 500000000 3.2.Choco - od 165.00000000 Bash dh can Lid.com 14 1.000.000 . Bach152 Rad Vies Edt Chemier Dashboard Members Members Mon Actis Parding Man Demuth Lab Members Last Cantimed: 0282017 Designation Final osng ) Demuth Lab Vew Lab Profile Chem Tracker - Compliance Dashboard - Manage Members Send Lab Message - Bio Summary Chem Summary Rad Summary -Rad Request donnay Thomas Brown DP Members Mariage Adventure Open With Google Docs Demuth Lab Members Last Confirmed: 0720-2017 Emel Designation tatutory Piger Theme .. Damuth La - View Lab Profile ChemTracker - Compliance Dashboard - Manage Members Send Lab Message Bio Summary Chem Summary - Rad Summary -Rad Rast - Rad Wash Pickup - Sef inspections Manage Lab Forme Research Tools Training Egulament My Account v hy von wg on Aarately wie BARBAR Duis and Adamobor Reyecan Thompson Designation: ...IBRAT moting Common Et Group Equipment inventory 3p Compliance also Manage Qup Character HAMOes hapur w Chen Job Active Biological Animais Radiological General Works with Vin Vector why Worts with local for Wortswth Boty Lovers Work with Boy Lovciach Bo ochora Putogens Hunn Baroe Was with Boyle Works with Agent Works with Hecomenant and the Nucleo Acids Sri Biological infectious Mas LOM Acous megberegular hookup against a crates and may take 30 seconds PRO Pick Add Creek you for your lo 5. Identify all functional dependencies and any potential repetition/anomalies. Perform the normalization step by step from First Normal Form (INF) until Third Normal Form (3NF). Part 3: Implementation 6. Using MySQL command client, write SQL statement (DDL) to create database, tables required with table's relevant attributes and specify keys as in 5. 7. Insert up to 10 records in each table and print the content of each (using SELECT *). 8. For all SQL statements you execute in 6 & 7, include the SQL statements and the results in your documents 9. Write SQL Query (DML) around 10 or more and you are advised to executes SQL query based on the knowledge you have learn in this course such as (at least one of each). Fail to include all below will affect your marks: SELECT Single Table, Join Table, Sub Query UPDATE . DELETE . ALTER WHERE/HAVING/GROUPBY/AND/OR Use of FUNCTION (MIN, MAX, AVG, COUNT) Include the printouts for all SQL statement executes in 9 together with the results Data Dictionary & References 12 Meeting Report and Peer Review The final report content: All items in Part 1, 2 and 3 Data Dictionary References Appendix (meeting report, relevant figures of application system) 10. 11
