Question

Which of the following is used to provide a detailed description of tables within the database by recording all attribute names, data types, formats, data domains, key indicators, and similar details of user/designer-created objects?

1)	data dictionary

2)

ERD model

3)

SQL query

Answer 1

Dear Student ,

As per requirement submitted above kindly find below solution.

Question :

Answer :1) data dictionary

Explanation :

• Data dictionary is created to list the all tables in the database along with their attributes , data types , description , constraints like primary key , foreign key , not null etc.
• ERD (Entity Relationship Diagram) contains only attributes and entities
• SQL query filter the records based on the given condition

NOTE :PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.