INF3707 Database Design and Implementation (INF3707)
University of South Africa
Hier vind je de beste samenvattingen om te slagen voor INF3707 Database Design and Implementation (INF3707). Er zijn o.a. samenvattingen, aantekeningen en oefenvragen beschikbaar.
Alle 19 resultaten
Sorteer op:
-
Samenvatting
DETAILED INF3707 Summary
-
---230november 20212021/2022
- Objectives 
After completing this lesson, you should be able to do 
the following: 
• List the course objectives 
• Describe the sample tables used in the course 
Copyright © 2004, Oracle. All rights reserved. 
Course Objectives 
After completing this course, you should be able to do 
the following: 
• Use advanced SQL data retrieval techniques to 
retrieve data from database tables 
• Apply advanced techniques in a practice that 
simulates real life 
Copyright © 2004, Oracle. All righ...
-
$3.99 Meer Info
LOVELY01
-
Tentamen (uitwerkingen)
INF3707 Exam Notes
-
---7november 20212021/2022A+
- INF3707 Exam Notes 
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 chara...
-
$3.99 Meer Info
DoctorReinhad
-
Tentamen (uitwerkingen)
INF3707 Exam Notes
-
---7november 20212021/2022A+
- INF3707 Exam Notes 
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 c...
-
$3.99 Meer Info
DoctorReinhad
-
Tentamen (uitwerkingen)
inf3707_summary notes
-
---111november 20212021/2022A+
- 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...
-
$3.99 Meer Info
ExellentStudyResources
-
Tentamen (uitwerkingen)
INF3707 MCQ Exam Revision.
-
---22november 20212021/2022A+
- 1) The goal of the planning phase of the systems development life cycle (SDLC) is to define the 
business need for a project. 
true 
10) A project- and issue-tracking software offers customizable dashboards to developers that help 
them see at a glance how a project is coming along. 
true 
9) End-users with disabilities should be considered in the design phase of the SDLC. 
true 
8) A use case diagram will show the series of steps involved in the implementation process of a 
system. 
false 
7) T...
-
$3.99 Meer Info
ExellentStudyResources
-
Tentamen (uitwerkingen)
INF3707 ALL_MCQ exam pack
-
---150november 20212021/2022A+
- 1. Choose the correct option in terms of Issues related to professional responsibility 
a) Confidentiality 
b) Intellectual property rights 
c) Both a & b 
d) Managing Client Relationships 
View Answer 
Answer:c 
Explanation: Engineers should normally respect the confidentiality of their employers or clients irrespective 
of whether or not a formal confidentiality agreement has been signed. 
They should be aware of local laws governing the use of intellectual property such as patents, copyright,...
-
$3.99 Meer Info
ExellentStudyResources
-
Tentamen (uitwerkingen)
INF3707 exam prep
-
---132november 20212021/2022A+
- Chapter 2 
2.1 Suggest the most appropriate generic software process model that might be 
used as a basis for managing the development of the following systems: 
 A system to control antilock braking in a car 
 A virtual reality system to support software maintenance 
 A university accounting system that replaces an existing system 
 An interactive travel planning system that helps users plan journeys with 
the lowest environmental impact 
Generic software process model for: 
 A s...
-
$3.99 Meer Info
ExellentStudyResources
-
Tentamen (uitwerkingen)
INF3707 Exam Notes
-
---7november 20212021/2022A+
- 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...
-
$3.59 Meer Info
ExellentStudyResources