INF3707 Database Design And Implementation

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...

INF3707-Examination - 2021 Exam for INF3707

INF3707-Examination - 2021 Exam for INF3707

INF3707 EXAM PACK 2021. PAST PAPER REVISION. UPDATED. INF3707 EXAM PACK

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 ...

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,...

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...

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...

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...

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...