Inf 3703 Study guides, Class notes & Summaries

inf3703 Quiz Database Systems inf 3703

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

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

INF3703 ASSIGNMENT 2 Semester 1 Updated 2019 INF 3703 ASSIGNMENT 2 Updated 2019 Semester 1