1. Explain me what is reverse engineering in a data model?

☛ Reverse Engineering is a process useful for creating the data modes from database and scripts.
☛ In this tools have options to connect the database by which we can reverse engineer a database into a data model.

2. Tell me what is basic elements of ERD?

☛ There are three basic elements
☛ Entities which we seek information
☛ Attributes the data collect about the entities.
☛ Relationship provide the structure needed to draw information from multiple entities.

3. What is a Table (entity)?

☛ Data stored in a form of rows and column is called as table.
☛ Each column has data type and based on the situation, integrity constraints are enforced on columns.

4. Tell me what is a composite foreign key constraint?

☛ Foreign key constraint is a column, that is used to establish and enforce a link between the data in two tables.
☛ It is defined as constraint create or modify a table.

5. Explain what is cardinality?

In a database, high cardinality means more unique values are stored in a column and vice versa.One to One, One to many, and many to many are different types of cardinalities.

6. What is data model repository?

☛ A Data modelling repository is storage area, where metadata of a data model is stored.
☛ The data is stored in different from the software perspective, organization's perspective and usage perspective.
☛ Repository can be stored any, where either in a data base or locally within any system.

7. Explain what is self – recursive relationship?

Standalone column is a table will be connected to the primary key of the same table. It is called recursive relationship.

8. Tell me what is a constraint? And its types?

☛ Constraint is a rule imposed on data.
☛ Different types of constraint:
☛ Primary key
☛ Unique
☛ Not null
☛ Foreign key
☛ Composite foreign key
☛ Check constraint

9. What is a foreign key?

In relational databases, a foreign key is a field in one table which is used to uniquely identify a row of another table.

10. Tell me what is a unique constraint?

Unique constraint is imposed on the column data to avoid duplicate values, but it will contain NULL values.

Download Interview PDF