FIT9132 PASS week 6

Given the terms in the conceptual model, what are the related terminologies in the logical model?
Entity -> ​ (a)  
Attribute -> ​ (b)  
Instance -> ​ (c)  

Identifier(KEY) -> ​ (d)   ​

• Relation
• Attribute
• Tuple
• Primary Key
• Secondary Key
• Foreign Key
• Column
• Table
• Row
• Relationship

What's the correct order of steps to map a conceptual model to logical level ?
1. Map binary relationships
2. Map weak entities
3. Map strong (regular) entities
4. Map ternary relationships
5. Map associative entities
6. Map unary relationships

• 3, 2, 1, 5, 6, 4

• 2, 3, 1, 6, 4, 5

• 3, 2, 5, 1, 4, 6

• 2, 6, 3, 5, 1, 4

Suppose we have a 1:M binary relationship in the conceptual model. When we convert it into a logical model, how many relations will be involved in representing it?

• 3

• 2

• 1

• it depends

Suppose we have a M:N binary relationship in the conceptual model. When we convert it into a logical model, how many relations will be involved in representing it?

• 3

• 2

• 1

• it depends

Suppose we have a M: N Unary relationship in the conceptual model. When we convert it into a logical model, how many relations will be involved in representing it?

• 3

• 2

• 1

• it depends