logo-home
logo
  2. University Of South Africa
  3. INF3707 - Database Design And Implementation

INF3707 Database Design and Implementation

University of South Africa

Hier vind je de beste samenvattingen om te slagen voor INF3707 Database Design and Implementation. Er zijn o.a. samenvattingen, aantekeningen en oefenvragen beschikbaar.

Pagina 2 van de 19 resultaten

Sorteer op:

INF3707 - Notes (Summary)

  • Tentamen (uitwerkingen)

    INF3707 - Notes (Summary)

  • -
    -
    -
    111
    november 2021
    2021/2022
    A+
  • 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 create and manage tables 54 10. 1-L10 Creating other schema ...
  • ExellentStudyResources
    $3.99 Meer Info
INF3707 SCHOOL OF COMPUTING TUTORIAL LETTER 202/1/2010.

  • Tentamen (uitwerkingen)

    INF3707 SCHOOL OF COMPUTING TUTORIAL LETTER 202/1/2010.

  • -
    -
    -
    11
    november 2021
    2021/2022
    A+
  • 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...
  • DoctorReinhad
    $3.99 Meer Info
INF3707 EXAM NOTES.

  • Tentamen (uitwerkingen)

    INF3707 EXAM NOTES.

  • -
    -
    -
    7
    november 2021
    2021/2022
    A+
  • 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...
  • ExcelAcademia2026
    $3.99 Meer Info
INF3707 EXAM PACK 2020.

  • Tentamen (uitwerkingen)

    INF3707 EXAM PACK 2020.

  • -
    -
    -
    92
    oktober 2021
    2021/2022
    A+
  • INF3707 EXAM PACK 2020. Database Design And Implementation.
  • ExcelAcademia2026
    $4.19 Meer Info
INF3707 Exam Notes

  • Tentamen (uitwerkingen)

    INF3707 Exam Notes

  • -
    -
    -
    7
    oktober 2021
    2021/2022
    A+
  • INF3707 Exam Notes Oct/Nov 2017 MQC 1.1 b.View – virtual table, not table on its own but mirrors table(temp table). Multiple tables – complex, single table – simple. In addition, the function and GROUP BY clause prevent changing the displayed data because each record might represent more than one row in the underlying key-preserved Reasons for view table – security, not direct DB access, efficiency – less direct DB hits table. CH. 13, text book pg 517 e-book pg 539 1.2 c. _ a...
  • LOVELY01
    $3.59 Meer Info
INF3707 EXAM PACK 2020

  • Tentamen (uitwerkingen)

    INF3707 EXAM PACK 2020

  • -
    -
    -
    92
    oktober 2021
    2021/2022
    A+
  • INF3707 EXAM PACK 2020
  • LOVELY01
    $4.19 Meer Info
INF3707

  • Voordeelbundel

    INF3707

  • -
    -
    -
    2
    oktober 2021
  • SUMMARY INF3707 Exam Notes 2 Exam (elaborations) INF3707 EXAM PACK 202
  • lectdenis
    $4.49 Meer Info
INF3707 Exam Notes

  • Samenvatting

    INF3707 Exam Notes

  • -
    -
    -
    7
    oktober 2021
    2021/2022
  • MQC 1.1 b.View – virtual table, not table on its own but mirrors table(temp table). Multiple tables – complex, single table – simple. In addition, the function and GROUP BY clause prevent changing the displayed data because each record might represent more than one row in the underlying key-preserved Reasons for view table – security, not direct DB access, efficiency – less direct DB hits table. CH. 13, text book pg 517 e-book pg 539 1.2 c. _ and % allows white characters - _ a...
  • lectdenis
    $3.99 Meer Info
INF3707 EXAM PACK 2020

  • Tentamen (uitwerkingen)

    INF3707 EXAM PACK 2020

  • -
    -
    -
    92
    oktober 2021
    2021/2022
    A+
  • INF3707 EXAM PACK 2020
  • lectdenis
    $3.99 Meer Info
Extra geld verdienen doe je zo!
Wist je dat een verkoper gemiddeld €76 per maand verdient met het verkopen van samenvattingen? Hint, hint.
Meer info Aan de slag