1. Which of the following is a purpose of logical model and physical database de
ID: 3582714 • Letter: 1
Question
1.
Which of the following is a purpose of logical model and physical database design?
Please provide your answer in the rich text box.
A
Structure the data in unstable structures that are likely to change over time and that have extensive redundancy
B
Develop a logical database to help identify a steering committee
C
Develop a logical database design from which we can do physical database design
D
Translate a relational database model into network database models
E
Develop a marketing plan for both logical and physical database design
2.
For a binary one-to-one relationship between two entities A and B, the relationship is represented by
Please provide your answer in the rich text box.
A
Adding the primary key of A as a foreign key of B
B
Adding the primary key of C as a foreign key of D
C
Combining the two entities into one relation
D
Creating a third relation to represent the relationship between the two entities
E
Deleting the primary keys
3.
____ describe what objects need to know about each other, how objects respond to changes in other objects, and the effects of membership in classes, superclasses, and subclasses.
Please provide your answer in the rich text box.
A
Aggregates
B
Relationships
C
Clusters
D
Linkages
4.
A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data refers to a(n)
Please provide your answer in the rich text box.
A
Attribute
B
Data element
C
Relationship
D
Entity
E
Process
5.
Which of the following determines how the system performs on the range of possible environments in which it may be used?
Please provide your answer in the rich text box.
A
Performance testing
B
Recovery testing
C
Stress testing
D
Range testing
E
Security testing
6.
When transforming an E-R diagram into normalized relations, the identifier of the entity type becomes
Please provide your answer in the rich text box.
A
The primary key of the corresponding relation
B
The foreign key in the corresponding relation
C
A nonkey attribute in the corresponding relation
D
A secondary key in the corresponding relation
E
A homonym in the corresponding relation
7.
If two processes are connected by a data flow, they are said to
Please provide your answer in the rich text box.
A
Exhibit cohesion
B
Share the same data
C
Be coupled to each other
D
Be strapped to each other
E
Be intertwined
8.
One problem in a file processing environment is ____, which means that data common to two or more information systems is stored in several places.
Please provide your answer in the rich text box.
A
Rigid data structure
B
Data integrity
C
Referential integrity
D
Data redundancy
9.
Which of the following is not a true statement regarding paper versus electronic reports?
Please provide your answer in the rich text box.
A
Ink-jet printers and laser printers produce reports that look identical to the display screen
B
Impact printers can exactly replicate a screen report to paper
C
Impact printers are very fast, very reliable, and relatively inexpensive
D
Impact printers are mainly used for producing large batches of reports
E
When designing forms and reports for use with impact printers, you may be limited in the range of formatting, text types, and highlighting options
10.
A file folder containing orders would be represented on a data-flow diagram as a
Please provide your answer in the rich text box.
A
Process
B
Source
C
Data flow
D
Data store
E
Relationship
Which of the following is a purpose of logical model and physical database design?
Please provide your answer in the rich text box.
A
Structure the data in unstable structures that are likely to change over time and that have extensive redundancy
B
Develop a logical database to help identify a steering committee
C
Develop a logical database design from which we can do physical database design
D
Translate a relational database model into network database models
E
Develop a marketing plan for both logical and physical database design
Explanation / Answer
1.
C.Develop a logical database design from which we can do physical database design
Logical modeling deals with gathering business requirements and converting those requirements into a model.Physical modeling involves the actual design of a database according to the requirements that were established during logical modeling.
2.
A.Adding the primary key of A as a foreign key of B
The answer can be either adding the primary key of A as a foreign key of B or adding the primary key of B as a foreign key of A.
3.
D. Linkages
Linkages in a database is use to find formal relationships between different classes/ objects.
4.
D. Entity
An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.