Lesson 2 Data Modeling
Terms in this set (64)
Q: A data model is usually graphical.
Q: An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data
Q: An implementation-ready data model should contain a description of the data structure that will store the end-user data.
Q: Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.
Q: A(n) ______'s main function is to help one understand the complexities of the real world environment.
A data model is a relatively simple representation of more complex real-world data structures.
Q: Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user.
Q: In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.
Q: A(n) _______ represents a particular type of object in the real world.
Q: A(n) _______ is anything about which data are to be collected and stored.
Q: A(n) _______ is bidirectional.
Q: A(n) _______ is a restriction placed on the data.
Q: _______ are important because they help to ensure data integrity.
Q: _______ are normally expressed in the form of rules.
Q: Students and classes have a _______ relationship.
Q: Database designers determine the data and information that yield the required understanding of the entire business.
Q: Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.
Q: Business rules must be rendered in writing.
Q: From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _______ .
Q: Which of the following is true of business rules?
They can serve as a communication tool between the users and designers.
Q: A noun in a business rule translates to a(n) _______ in the data model.
Q: A verb associating two nouns in a business rule translates to a(n) _______ in the data model.
A business rule is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.
Q: In an SQL-based relational database, each table is dependent on every other table.
Q: In an SQL-based relational database, rows in different tables are related based on common values in common attributes.
Q: A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.
Q: Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
Q: In Chen notation, entities and relationships have to be oriented horizontally; not vertically.
Q: M:N relationships are not appropriate in a relational model.
Q: Today, most relational database products can be classified as object/relational.
Q: The network model has structural level dependence.
Q: The hierarchical model is software-independent.
Q: The relational model is hardware-dependent and software-independent.
Q: A(n) _______ is the equivalent of a field in a file system.
Q: The hierarchical data model was developed in the _______.
Q: The object-oriented data model was developed in the _______ .
Q: VMS/VSAM is an example of the _______.
file system data model
Oracle 11g is an example of the _______.
XML/Hybrid data model
In the _______ model, the basic logical structure is represented as an upside-down tree.
In the _______ model, each parent can have many children, but each child has only one parent.
The relational data model was developed in the _______.
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.
The _______ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
A(n) _______ enables a database administrator to describe schema components.
data definition language (DDL)
Which of the following types of HDFS nodes stores all the metadata about a file system?
Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?
Which of the following is a disadvantage of the hierarchical data model?
It does not have standards.
Provide fault tolerance
The _______ model uses the term connectivity to label the relationship types.
Which of the following is true of NoSQL databases?
They are not based on the relational model.
The _______ data model is said to be a semantic data model.
The _______ data model uses the concept of inheritance.
One of the limitations of the _______ model is that there is a lack of standards.
A segment in a hierarchical model is the equivalent of a record in a file system.
A schema is the conceptual organization of an entire database as viewed by a database administrator.
The relational model's foundation is a mathematical concept known as a relation.
Each row in a relation is called a tuple.
Each column in a relation represents an attribute.
A data manipulation language (DML) defines the environment in which data can be managed and is used to work with the data in the database.
Each row in the relational table is known as an entity instance.
In Crow's Foot notation, a three pronged symbol represents the "many" side of the relationship.
A class is a collection of similar objects with a shared structure and behavior.
In object oriented terms, a method defines an object's behavior.
MySQL is an example of the _______.
relational data model
YOU MIGHT ALSO LIKE...
Academic Word Lists - AWL Sublists
Chapter 2: Review Q&A
Chapter 2 DBMS
OTHER SETS BY THIS CREATOR
CHAPTER 7 Security - C259
CHAPTER 6 Medical Business Operations - C259
CHAPTER 5 IT Operations - C259
CHAPTER 4 Organizational Behavior - C259
THIS SET IS OFTEN IN FOLDERS WITH...
WGU C175 Lesson 2
Lesson 6 Fundamentals of SQL
Lesson 7 Business Intelligence