WGU C175 (WGUC175)

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 systems? Sequentially from simple files In which...

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 entity types. Unary Relat...

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 relationship? It means that a single occurrenc...

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 result of a query of a database system C) Facts that 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 committee Application Programming Interface (API) Soft...

From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _______ . A business norms B business goals C business plans D business rules business rules In a SQL-based relational database, each table is dependent on every other table. True or False? False A(n) ______'s main function is to help one understand the complexities of the real world environment. A entity B node C database D model model The object-oriented data model was...

3 Vs (3 basic characteristics of Big Data databases) - answer Volume, velocity, and variety Abstract Data Type (ADT) - answer 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) - answer The group that accepted the DBTG recommendation and augmented database standards in 1975 through its SPARC committee Application Pr...

Associative Entity - answer An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - answer An attribute is a property or characteristic of an entity. Binary relationship - answer A binary relationship is a relationship between two entity types. Candidate Key - answer Is any column or a combination of columns that can qualify as unique key in database. Cardinality - answer Cardinality represents the...

What is a broad definition of data? Correct Answer Raw facts that are captured on printed or digital media What are data? Correct Answer Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? Correct Answer It does not follow a data model. Which is true about flat files? Correct Answer They contains no internal hierarchical organization. Which technology has no internal hierarchy? Correct Answer Flat files How data were ...