Database Management in Construction Quiz

Data administrator (DA)

Better protection against unintentional loss and unlawful access

Implementing the data administrator's decisions and ensuring system performance

<p>Data is what's stored in a database system and is crucial for decision-making.</p> Signup and view all the answers

<p>Decentralized control of data</p> Signup and view all the answers

<p>Basic understanding of database system capabilities at a technical level</p> Signup and view all the answers

<p>A system in which one user can access the database at any given time.</p> Signup and view all the answers

<p>A system in which many users can access the database at any given time.</p> Signup and view all the answers

<p>Data can be both integrated and shared.</p> Signup and view all the answers

<p>The database can be thought of as a unification of several distinct files, with any redundancy among those files eliminated.</p> Signup and view all the answers

<p>The database can be shared among different users, allowing access to the same data, possibly even concurrently.</p> Signup and view all the answers

<p>SQL is a programming language for storing and processing information in a relational database.</p> Signup and view all the answers

<p>To make decisions that provide the best use of resources for the organization as a whole.</p> Signup and view all the answers

<p>By ensuring all applicable standards are followed.</p> Signup and view all the answers

<p>A property that allows changing the database schema at one level without affecting the schema at the next higher level.</p> Signup and view all the answers

<p>Deals with changes in the physical storage of data without affecting the logical structure or data presentation to users.</p> Signup and view all the answers

<p>Changes to the logical structure of the data without impacting the applications using the data.</p> Signup and view all the answers

<p>To facilitate changes in the database schema without disrupting the applications built on top of it.</p> Signup and view all the answers

<p>Different applications need different views of the same data and changes to the database can require major modifications to applications.</p> Signup and view all the answers

<p>A stored field is the smallest unit of stored data, identified by a field name, such as age or car registration number.</p> Signup and view all the answers

<p>A collection of related stored fields that contain all the information stored about a person or thing.</p> Signup and view all the answers

<p>A stored file is a collection of all currently existing occurrences of one type of stored record, forming a table with records of the same structure.</p> Signup and view all the answers

<p>A system where any given logical record seen by an application is identical to some corresponding stored record.</p> Signup and view all the answers

<p>To cater to the specific requirements and interface design of each application.</p> Signup and view all the answers

<p>Representation of Numeric Data, Representation of Character Data, Units of Numeric Data, Data Materialization</p> Signup and view all the answers

<p>In internet arithmetic form or as a character string</p> Signup and view all the answers

<p>Relational systems perceive data as tables and derive new tables from old ones, while nonrelational systems may use other data structures in addition to tables.</p> Signup and view all the answers

<p>Because 'relation' is a mathematical term for a table</p> Signup and view all the answers

<p>Constructing an occurrence of the logical field from the corresponding stored field occurrence and presenting it to the application</p> Signup and view all the answers

<p>Derive 'new' tables from 'old' ones</p> Signup and view all the answers