In an SQL-based relational database, each table is dependent on every other table. |
False |
An implementation-ready data model needn’t necessarily contain enforceable rules to guarantee the integrity of the data. |
Falsea dis |
Today, most relational database products can be classified as object/relational. |
True |
Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain. |
True |
An implementation-ready data model should contain a description of the data structure that will store the end-user data. |
True |
Business rules must be rendered in writing. |
True |
M:N relationships are not appropriate in a relational model. |
True |
Database designers determine the data and information that yield the required understanding of the entire business. |
False |
The hierarchical model is software-independent. |
False |
Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. |
False |
In an SQL-based relational database, rows in different tables are related based on common values in common attributes. |
True |
The external model is the representation of the database as "seen" by the DBMS. |
False |
Each row in the relational tables known as an entity instance or entity occurrence in the ER model. |
True |
The relational model is hardware-dependent and software-independent. |
False |
The network model has structural level dependence |
True. |
A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user. |
False |
Even when a good database blueprint is available, an applications programmer’s view of the data should match that of the manger and the end user. |
False |
Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS? |
d) Client Node |
A verb associating two nouns in a business rule translates to a(n) _____ in the data model. |
b) Relationship |
In the _____ model, each parent can have many children, but each child has only one parent. |
b) Hierarchical |
The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. |
b) Entity Relationship |
The _____ data model is said to be a semantic data model. |
c) Object-oriented |
NoSQL databases: |
b) Provide fault tolerance |
From a database point of view, the collection of data becomes meaningful only when it reflects properly defined ______. |
b) Business Rules |
_______ are normally expressed in the form of rules. |
b) Constraints |
MySQL is an example of the ____. |
c) relational data model |
The hierarchical data model was developed in the _____. |
c) 1960s |
Chapter 2 Quiz- Data Models
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price