|1) When is an entity in 2nd Normal Form?
a) When all non-UID attributes are dependent upon the
entire UID. (*)
2) Any Non-UID must be dependant on the entire UID. True or False?
3) As a database designer you do not need to worry about where in the datamodel you store a particular attribute, as long as you get it onto the ERD your job is done. True or False?
4) Until all attributes are single-valued, the database model is said to be:
5) An entity without repeated values is said to be on 1st Normal Form. True or False?
6) All entities must be given a new artificial UID. True or False?
7) A unique identifier must be made up of more than one attribute. True or False?
8) There are formal rules for how to draw ERD's, even though they are only guidelines, you should always try to follow them. True or False?
9) Which of the following statements are true for ERD's
to enhance their readability. (Choose Two)
a) Is is OK to break a big ERD down into subsets of the
overall picture. This way you end up with more than one ERD, that together
documents the entire system.
10) All datamodels must be transformed from specific to generic. True or False?
11) Generic models are generally far more complex than a specific model. True or False?
12) You are doing a data model for a computer sales company, where the price of postage is dependent on what day of the week goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?
a) Use a Delivery Day entity, which holds prices against
week days, and ensure the we also have an attribute for the Requested Delivery
Day in the Order Entity.
9) a, b
Do you have an Oracle Question?
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.