joi, 21 februarie 2013

Section 10 Database Design

DRAWING CONVENTIONS FOR READABILITY
It is a good idea to group your entities in a diagram according to the expected volumes. By grouping high volume entities together, the diagrams could become easier to read. True or False?
True
          
You must make sure all entities of a proposed system can fit onto one diagram. It is not allowed to break up a data model into more than one diagram. True or False?
False
          
There are no formal rules for how to draw ERD's. The most important thing is to make sure all entities, attributes and relationships are documented on diagram. The Layout is not significant. True or False?
False
          
Which of the following statements are true for ERD's to enhance their readability.
There should be no crossing lines.
All crows feet (Many-ends) of relationships should point the same way.
          

GENERIC MODELING
Generic models are generally less complex than a specific model. True or False?
False
          
All data models MUST have some portions of the model modeled as a generic component. True or False?
False
         
When you transform a specific model to be generic, which of the following statements are true?
You tend to end up with fewer entities in the generic model than you had in the specific model
Either all or none of the original attributes make it into the generic model

Niciun comentariu:

Trimiteți un comentariu