Computer Science > EXAM > C175 WGU EXAM / WITH COMPLETE SOLUTIONS (All)
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 prope ... rty 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]
Last updated: 3 years ago
Preview 1 out of 5 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Can't find what you want? Try our AI powered Search
Connected school, study & course
About the document
Uploaded On
Oct 24, 2022
Number of pages
5
Written in
All
This document has been written for:
Uploaded
Oct 24, 2022
Downloads
0
Views
85
Scholarfriends.com Online Platform by Browsegrades Inc. 651N South Broad St, Middletown DE. United States.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Scholarfriends · High quality services·