WorksheetsData Modeling - Revision
Total questions: 15
Worksheet time: 8mins
1. What is a NOT in components of ERD ?
Entity
Relationship
Data
Attributes
Entity
Rectangle
Oval
Diamond
3. What is a component in ERD related for this picture?
Strong Entity
Weak Entity
Derived Attributes
Composite Attributes
4. Email and Phone number can be....... Which answer suitable for this statement?
Composite Attributes
Derived Attributes
Multivalued Attributes
Key Attributes
5. Total prices of sales can be considered as ......
Multivalued Attributes
Composite Attributes
Derived Attributes
Key Attributes
6. What type of attributes in this Figure?
Multivalued Attributes
Derived Attributes
Composite Attributes
Key Attributes
7. What type of attributes from this Figure?
Composite Attributes
Derived Attributes
Multivalued Attributes
Key Attributes
8. What type of this attributes of this Figure?
Derived Attributes
Multivalued Attributes
Composite Attributes
Key Attributes
9. What type of this relationship?
One employee can manage many department
Each employee can manage many department
Each employee can manage one department only
Many employee can manage one department
10. What type of relationship is correct based on Figure besides?
One customer can placed only single order at one time
Many customer can placed only single order at one time
One customer can placed one or more order
An order can be placed by many cudtomer
11. Which relationship is Correct based on Figure besides?
Group of student is assign in One Group Only
Each student is assigned in One Group
Every student is assigned in Single Group
12. What type of this attributes
Primary key and Derived attributes
Primary key and Composite attributes
Primary key and Multivalued attributes
Foreign key and Multivalued attributes
