Lab 6 .SQL Oliery doox- Saved to this PC ut References Mailings Review Tell me what you want to do Let us consider the following relational database: Departments dantName, building, budget) deptName Building Budget 3123 Price 90000 Information Technolopy 4111 Smith 100000 Computer Technology3111 Price $5000 name email id name Office Phone dob email tNa 016 Stnith | 336-255-3143 1957-10-19 12323-123 tcoddancat edu 123Pnce--33-2553154|1977-10-10.121-11-1234 Ahopperencat edu ter T 50650456 James Smith 3116 Smith 336-285-3543 1966-06-06 222-33-4444 50550111 Nikole Suits 2233 Price 396255342 1 xs5071 1 Jones Kellv 3 01 Smith 336-255340-19009 42-624-kelletnatedu- bso550620lThomas Duran|40015mith-36-255-355 1957-01-2 tdunnancat edu pre o Students(ed, name, address, dob emait, advisor) id nameAddress Dob email Advisor 950850123 , Ann Smith Karen Peters 4 Market St Jun Mama 1Main S 1997-10-19 kpeters Geggles ncat edu 9050999 1 11444 21 Firstst 1902-0.04 mattuage neat edu studentI dep tName enteredT er Information Technolory Fall 2015 Fall 2014