Inf 3703 - Study guides, Class notes & Summaries

_______ 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 influences the choice of database design strategies. [1] The company’s ma...

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

INF 3703databases-2-inf3703-summaries. BEST DOCUMENT FOR EXAM Chapter 9 Database Design 9-1 The Information System [p.440] A database is a carefully designed and constructed repository of facts. The database is part of a large whole known as an Information System, which provides for data collection, storage, transformation, and retrieval. Systems analysis is the process that establishes the need for an information system and its extent. The process of creating an information system is k...

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