INF3703 Databases II (INF3703)

INF3703 REVISION PACK. INF 3703 - DATABASES II Ref Chap Title Page 1. 10 Distributed Databases 2 2. 11 Interacting with Databases Through the Web 8 3. 12 Database Administration & Security 15 4. 13 Managing Transactions and Concurrency 33 5. 14 Managing Database and SQL Performance 38 6. 15 Databases for Decision Support 43 Database Principles: Fundamentals of Design, Implementation, and Management 10th Edition - Coronel C, Morris S, Rob P. v1.00 September 2013 Ron Barnard Chapter 1...

INF3703 Summary Exam. DBLC – Database Life Cycle. Basically, a database is a carefully designed and constructed repository of facts. The database is a part of a larger whole known as an information system, which provides for data collection, storage, and retrieval. Systems analysis is the process that establishes the need for and the extent of an information system. The process of creating an information system is known as systems development. DBLC – Database Life Cycle. DBLC has 6 ...

INF3703 EXAM PACK LATEST. BEST DOCUMENT FOR EXAM INF3703/201 5 2. _______ has been enhanced with extensions that support OLAP type processing and data generation. [1] SQL [2] DBMS [3] DBLC [4] SDLC. 3. Data stored in the company database must be protected from access by unauthorized users. Data measures include all of the following EXCEPT…. [1] User authentication [2] Physical security [3] Data encryption [4] Top down authentication 4. The following is NOT a factor that influ...

INF 3703 - DATABASES II Summary 2013 Ref Chap Title Page 1. 10 Distributed Databases 2 2. 11 Interacting with Databases Through the Web 16 3. 12 Database Administration & Security 28 4. 13 Managing Transactions and Concurrency 44 5. 14 Managing Database and SQL Performance 60 6. 15 Databases for Decision Support 72 Database Principles: Fundamentals of Design, Implementation, and Management 10th Edition - Coronel C, Morris S, Rob P. v1.00 September 2013 Ron Barnard Chapter 10 - Dist...

2015-6 SECTION B Question 2 [22] ABC is a company on the street of Soweto. You have been appointed by ABC Company as a Database Administrator (DBA) after the completion of your IT qualification. As a DBA, one of your managerial roles in the Company is to ensure backup and full recovery database data in case of loss. As a Database Administrator (DBA) do the following: 2.1. State and explain to the Company at least SIX (06) measures you would put in place to ensure backup and recovery of th...

INF3703 SUMMNOTES ON – DATABASE SYSTEMS INF3703/2012 Chapter 1 and 2 – just read as background not examined Chapter 3: The relational Database Model Properties: 1. A table is a two-dimensional structure composed of rows and columns 2. Each row (tuple) represents a single entity – duplicate rows are not allowed 3. Each column represent a attribute and has a name 4. Each cell (column/row) contain only an atomic value – a single data value 5. All values in a column must conform to t...

INF3703Answers to Review Questions 1. Explain the following statement: a transaction is a logical unit of work. A transaction is a logical unit of work that must be entirely completed of aborted; no intermediate states are accepted. In other words, a transaction, composed of several database requests, is treated by the DBMS as a unit of work in which all transaction steps must be fully completed if the transaction is to be accepted by the DBMS. Acceptance of an incomplete transaction will ...

INF3703 Exam Summary. INF3703 - Databases II. Basically, a database is a carefully designed and constructed repository of facts. The database is a part of a larger whole known as an information system, which provides for data collection, storage, and retrieval. Systems analysis is the process that establishes the need for and the extent of an information system. The process of creating an information system is known as systems development. DBLC – Database Life Cycle. DBLC has 6 phases: ...

INF3703 STUDY NOTES. An informaton system is composed of people, hardware, software, databases, applicatons and procedures  Systems analysis is the process that establishes the need for and the scope of an informaton system  Systems development – is the process of creatng an informaton system  The performance of an information system depends on DB design and implementaton; app design and implementation; and administrative procedures  DB Design objectves – create complete, ...