WGU C170 Terms With Complete Solution

WGU C170 Terms With Complete Solution 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 (... ...

WGU C170 Terms With Complete Solution 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 relationship 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, and so forth. DML Ans- (...) refers to the four basic operations that can and must be performed on data stored in any DBMS: data retrieval, data update, insertion of new records, and deletion of existing records. EER (enhanced entity-relationship) diagram Ans- (...) is a conceptual data model incorporating extensions to the original entity-relationship model used in the design of databases. SQL Ans- Is a comprehensive database management language which incorporates DML and DDL BLOB (binary large objects) Ans- (...) is a collection of binary data stored as a single entity in a database management system. It holds up to 65,535 bytes of data. ENUM Ans- (...) is a special data type that enables for a variable to be a set of predefined constants. REAL Ans- (...) is a numerical data which contains decimal numbers. MySQL treats ... as a synonym for DOUBLE, unless the REAL_AS_FLOAT SQL mode is enabled. SET Ans- (...) is a string object that can have zero or more values (up to 64 items). TEXT Ans- (...) data type holds a string with a maximum length of 65,535 characters. TIMESTAMP Ans- (...) is a special data type provided by MYSQL that enables you to track when changes were last made to a row. VARCHAR Ans- (...) data type holds a variable length string (up to 255 characters) that contains letters, numbers, and special characters. Definer Ans- (...) is a MySQL term where AuthID is the same for another DBMS Event Ans- (...) is an entity that executes on a time-activated basis according to a schedule. Stored functions Ans- (...) is a special kind of stored program which is compiled and executed every time when called and returns a single value.