Associative Entity - ANS-An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many.
Attribute - ANS-An attribute is a property or characteristic
...
Associative Entity - ANS-An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many.
Attribute - ANS-An attribute is a property or characteristic of an entity.
Binary relationship - ANS-A binary relationship is a relationship between two entity types.
Candidate Key - ANS-Is any column or a combination of columns that can qualify as unique key in database.
Cardinality - ANS-Cardinality represents the maximum number of entities that can be involved in a particular relationship.
Cartesian product - ANS-Usually the result of a missing join condition or a method of expanding the data of 1 table by the number of rows in the second table.
Cascade Delete - ANS-Will delete all records that reference the primary key
column subquery - ANS-Returns a single column of one or more values.
data encryption - ANS-When data is encrypted, 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
Database - ANS-A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.
DCL - ANS-Data control language is used to control access to data stored in a database.
DDL - ANS-Data definition language - 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.
Definer - ANS-Definer is a MySQL term where AuthID is the same for another DBMS
[Show More]
.png)
