employee ( employee_name, street, city ) key: employee_name works ( employee_name, company_name, salary ) key: employee_name, company_name company ( company_name, city ) key: company_name manages ( employee_name, manager_name ) key: employee_name, manager_nameExpress the following queries in SQL:
pizza ( pid, pname, size ) key: pid soldby ( pid, sname, price ) key: pid, sname store ( sname, phone, quality ) key: snameExpress the following queries in SQL:
You need to submit your homework solution online using the following web form. We do not accept email or hardcopy submissions. You need a username and password to submit your homework. You should have already received an email from your instructor at your mavs.uta.edu account with your username and password. Acceptable document formats are: Microsoft word/powerpoint document, PDF, postscript, and plain text. You may submit multiple files, if you like, as long as they have different names. These files are automatically uploaded directly into your personal class account for this particular homework, so you don't have to include your name or student ID or homework number in the file name. You may submit your files as many times as you like, but only the most recently submitted files will be retained and evaluated (newly submitted files replace the old files under the same file name). After you submit the files, please double-check that your submitted files are correct by clicking on the Status link and by downloading your submitted homework. If you cannot login or have a problem submitting the homework using this form, ask the GTA for help.
Last modified: 9/15/11 by Leonidas Fegaras