Inf3707 - database design and implementation Study guides, Class notes & Summaries

Question 1 (Lesson 4) a. The Human Resources department needs a report that displays the job ID and the average monthly salary for each job that has an average payroll that is between 5000 and 10000. The report should not include clerks. Sort the list in descending order of average salary. Sample results are shown below. Save your query as Q1A.SQL. [6] JOB_ID Average Salary IT_PROG 5760 MK_REP 6000 HR_REP 6500 ST_MAN 7280 FI_ACCOUNT 7920 AC_ACCOUN...

INF3707 - Database Design And Implementation (INF3707)

Exam (elaborations) INF3707 - Database Design And Implementation

INF3707 EXAM PACK 2020 - 2021. INF3707 - Database Design And Implementation

INF3707 EXAM PACK 2020. Database Design And Implementation.

INF3707 EXAM NOTES. Database Design And Implementation. Difference between inner & outer join: Both inner & outer are used to combine rows for different tables into a single result. The difference is that inner join does not allow/retrieve non-matching rows (matched by PK & FK) where outer join does. The outer join will display ALL records from the table selected (by LEFT or RIGHT keyword) as well as the matching records from the other table that is in the query. The inner join will only di...

INF3707 SCHOOL OF COMPUTING TUTORIAL LETTER 202/1/2010. The Human Resources department needs a report that displays the job ID and the average monthly salary for each job that has an average payroll that is between 5000 and 10000. The report should not include clerks. Sort the list in descending order of average salary. Sample results are shown below. Save your query as Q1A.SQL. [6] Solution select job_id, avg(salary)"Average salary" from employees where job_id not like '%CLER%' gr...

INF3707 - Database Design & Implementation Summary 2014 Ref. Lesson Title Page 1. 1-L1 Retrieving data using the SQL select statement 2 2. 1-L2 Restricting and sorting data 7 3. 1-L3 Using single row functions to customize output 15 4. 1-L4 Reporting aggregated data using the group functions 25 5. 1-L5 Displaying data from multiple tables 30 6. 1-L6 Using sub-queries to solve queries 37 7. 1-L7 Using the set operators 42 8. 1-L8 Manipulating data 46 9. 1-L9 Using DDL statements to cr...

Summary for the course INF3707 - Database Design and Implementation at Unisa

100% correct answers for the INF3707 Semester 2 Assignment 2 for the year 2020. Only answers are provided.