WGU C170 Terms Complete Solutions

Document Content and Description Below

Associative Entity Ans- All relationships for the (...) entity should be many. Attribute Ans- An (...) is a property or characteristic of an entity. Binary relationship Ans- A (...) is a relationshi... p between two entity types. Cardinality Ans- (...) represents the maximum number of entities that can be involved in a particular relationship. Cascade Delete Ans- Will delete all records that reference the primary key Database Ans- A (...) is a collection of information that is organized so that it can easily be accessed, managed, and updated. E-R model Ans- An (...) is a data model for describing a database in an abstract way. Entity Ans- An (...) is an object or event in our environment that we want to keep track of. Intersection Data Ans- Associated with the concatenation of two segments Modality Ans- (...) represents the minimum number of entity occurrences that can be involved in a relationship. Ternary Relationship Ans- A (...) relationship is when three entities participate in the relationship. Unary Relationships Ans- (...) relationships associate occurrences of an entity type with other occurrences of the same entity type. Unique Identifier Ans- A (...) is any identifier which is guaranteed to be unique among all identifiers used for those objects and for a specific purpose. Data encryption Ans- When data is (...), it is changed, bit by bit or character by character, into a form that looks totally garbled. It can and must be reconverted, or decrypted, back to its original form to be of use. Data normalization Ans- Is a methodology for organizing attributes into tables so that redundancy among the non-key attributes is eliminated. Data volatility Ans- Describes how often stored data is updated. Data Volume Assessment Ans- Understanding of how much data will be in a database or a table within a database Denormalization Ans- The act of duplicating data in a database for performance or the preservation of historical information Disaster recovery Ans- Involves rebuilding an entire information system or significant parts of one after a catastrophic natural disaster such as a hurricane, tornado, earthquake, building collapse, or even a major fire Index Ans- Used to help a DBMS find data quickly Logical view Ans- Is a mapping onto a physical table or tables that allows an end user to access only a specified portion of data. Response time Ans- Is the delay from the time that the Enter Key is pressed to execute a query until the result appears on screen. Throughput Ans- Is the measure of how many queries from simultaneous users must be satisfied in a given period of time by the application set and the database that it supports. Client/server architecture Ans- (...) architecture is a network architecture in which the server manages services consumed by the client. It is also known as two-tier architecture. Database directory Ans- (...) is an organized repository of databases that stores attributes such as the database character set and collation. GUI (graphical user interface) Ans- (...) is a computer program that enables a user to communicate with a computer through the use of graphical icons. MySQL Ans- (...) is an open source RDBMS based on SQL (structure query language) and used for adding, removing, and modifying information in the database. Option file Ans- (...) is an appropriate way of specifying commonly used options on the command line while executing a program. RDBMS (relational database management system) Ans- (...) is a program that lets you create, update, and administer a relational database. Schema Ans- In a relational database, a (...) defines tables, fields in each table, and relationships between fields and tables. DB2 Ans- (...) is a relational database management system product from IBM that serves a number of operating system platforms. DCL Ans- (...) is used to control access to data stored in a database. DDL Ans- (...) - involves instructing the DBMS software on what tables will be in the database, what attributes will be in the tables, which attributes will be indexed [Show More]

Last updated: 2 years ago

Preview 1 out of 8 pages