WGU C175 Guides d'étude, Notes de cours & Résumés

WGU C175 Data Management Foundation Questions and Answers 100% Pass Associative Entity An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute An attribute is a property or characteristic of an entity. Binary relationship A binary relationship is a relationship between two entity types. Candidate Key Is any column or a combination of columns that can qualify as unique key in database. Cardinality Cardin...

01 WGU C175 Data Management Foundations Chapter 1 Questions and Answers field A _____ is a character or group of characters that has a specific meaning query result set The response of the DBMS to a query is the ______ file A _____ is a collection of related records semistructured Most data that can be encountered are best classified as _____ ad hoc query A(n) ____ is a spur-of-the-moment question data Information is produced by processing ____. information _____ is the result of reveal...

WGU C175 Data Management Foundations Latest Rated A They can serve as a communication tool between the users and designers. Which of the following is true of business rules? entity A(n) _______ is anything about which data are to be collected and stored. XML/Hybrid data model Oracle 11g is an example of the _______. entity instance Each row in the relational table is known as a(n) relational data model MySQL is an example of the _______. attribute A(n) _______ is the equivalent of a fie...

WGU C175 Data Management Foundations Questions and Answers Already Passed ad hoc query A "spur-of-the-moment" question analytical database A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making availability In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes centralized database A database located at a single site cloud database A d...

WGU C175 Final+1+2 Latest Already Passed What is a broad definition of data? Raw facts that are captured on printed or digital media What are data? Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? It does not follow a data model. Which is true about flat files? They contain no internal hierarchical organization. Which technology has no internal hierarchy? Flat files How were data retrieved before database management syste...

WGU C175 Pre-Assessment Questions and Answers Already Passed What is a broad definition of data? Raw facts that are captured on printed or digital media What are data? Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? It does not follow a data model. Which is true about flat files? They contain no internal hierarchical organization. Which technology has no internal hierarchy? Flat files How were data retrieved before databa...

WGU C175 Study Notecards Flat Files a file having no internal hierarchy Hashed Files A file that has been encrypted for security purposes. Heap File An unsorted set of records. Information The transformation of raw data into useful facts. Punch Card A card that is perforated and can hold commands or data. Structured Data Information with a high degree of organization. Unstructured Data Information that does not have structure (such as text) Binary Relationship A relationship between two ...

WGU C175 Vocab Latest Graded A+ E-R Model It is well named, as it diagrams entities (together with their attributes) and the relationship among them. Describe the ER model for "A salesperson works in one office." - What is the name of this relationship? exists when two entities are associated/relationship - Ex. A professor teaches many classes. - One-to-one binary relationship Describe the ER model for "A salesperson sells to many customers." - What is the name of this relationshi...

WGU C175 – PA Questions and Answers Already Passed What is a broad definition of data? A) Numbers that are captured on digital media B) Raw facts that are captured on printed or digital media C) Alphanumeric combinations that can be captured on media that a computer can read D) Any information that can be transferred from print to digital Raw facts that are captured on printed or digital media What are data? A) Facts that have been organized in a meaningful way B) Facts that are the ...

WGU C175 - Chapter 2: Data Modeling Latest Graded A+ 3 Vs (3 basic characteristics of Big Data databases) Volume, velocity, and variety Abstract Data Type (ADT) Data type that describes a set of similar objects with shared and encapsulated data representation and methods. An abstract data type is generally used to describe complex objects American National Standards Institute (ANSI) The group that accepted the DBTG recommendation and augmented database standards in 1975 through its SPARC...