Logical Data Model

What happens to an entity in a Entity Relationship Model when we convert it into a logical data model?

• It becomes to a logical table
• It becomes to a database
• It becomes to a column

If we have a binary relationship with a cardinality that says 1 to M (M= Many) or M (M=Many) to 1. How many tables will we create when we convert it into a logical data model?

•  1 table
• 2 tables
• 3 tables
• 4 tables

If we have a binary relationship with a cardinality that says M (M = Many) to M (M = Many). How many tables will we create when we convert it into a logical data model?

• 1
• 2
• 3
• 4

If we have a binary relationship with a cardinality that says 1 to 1 and a relationship that has one attribute. How many tables will we create when we convert it into a logical data model?

• 1
• 2
• 3
• 4

What happens to an attribute in a Entity Relationship Model  when we convert it into a logical data model?

• It becomes to a table
• It becomes to a database
• It becomes to column

What happens to the id attribute in a Entity Relationship Model when we convert it into a logical data model?

• It becomes the primary key column in the new table
• It becomes the foreign key column in the new table
• It becomes a simple column in the new table

Is it possible to have multiple instances of the same foreign key in a table?

• Yes
• No

Is it possible to have multiple instances of the same primary key in a logical table?

• No
• Yes

What is data types?

• It specifies what type of data is expected inside of each column in a table (ef. number, date, string)
• It specifies how many tables you will create when you convert your Entity Relations Model to a Logical Data Model
• It specifies the database-name
• It counts how many attributes you have

What does the data-type INT contain

• Whole numbers
• Decimal numbers
• Characters
• Date