Data Management Foundations WGU C175 Study Guide 2023

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 field in a file system. entity relationship - The _______ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. entity relationship - The _______ model uses the term connectivity to label the relationship types. 1980s - The object-oriented data model was developed in the _______ . network - In the _______ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent. constraints - _______ are important because they help to ensure data integrity. Crow's Foot notation - In ________, a three pronged symbol represents the "many" side of the relationship. data definition language (DDL) - A(n) _______ enables a database administrator to describe schema components. file system data model - VMS/VSAM is an example of the _______. 1960s - The hierarchical data model was developed in the _______. hierarchical - One of the limitations of the _______ model is that there is a lack of standards. entity - A(n) _______ represents a particular type of object in the real world. data manipulation language (DML) - A(n) ________ defines the environment in which data can be managed and is used to work with the data in the database. constraint - A(n) _______ is a restriction placed on the data. They are not based on the relational model. - Which of the following is true of NoSQL databases? provide fault tolerance. - NoSQL databases: relationship - A verb associating two nouns in a business rule translates to a(n) _______ in the data model. business rule - A(n) _______ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization. business rules - From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _______ . It does not have standards - Which of the following is a disadvantage of the hierarchical data model? relation - The relational model's foundation is a mathematical concept known as a relationship - A(n) _______ is bidirectional. 1970s - The relational data model was developed in the _______. hierarchical - In the _______ model, each parent can have many children, but each child has only one parent. client node - Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS? attribute - Each column in a relation represents a(n) method - In object oriented terms, a(n) ________ defines an object's behavior. tuple - Each row in a relation is called a(n) data model - A(n) ________ is a relatively simple representation of more complex real-world data structures. constraints - _______ are normally expressed in the form of rules.