Modeling Data

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

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

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

What are you supposed to do in the database implementation stage/(step)?

• In this stage we will be creating our database with the database language SQL. It includes the specification of data elements, data types, indexing, primary and foreign keys, constraint etc. 
• In this stage we will be creating our database with the database language SAS. It includes modeling the database design.
• In this stage we will be designing and creating the Front-End of the database.