Question

Which of the following is used to provide a detailed description of tables within the database...

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

Homework Answers

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.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
QUESTION 1 Which of the following best exemplifies offshoring? A. A U.S. company employs foreign nationals...
QUESTION 1 Which of the following best exemplifies offshoring? A. A U.S. company employs foreign nationals at its U.S. based headquarters. B. A U.S. company translates novels originally written in foreign languages into English for distribution in the U.S. market. C. A U.S. company starts a chain of fusion restaurants to cater to the American public’s evolving palates. D. A U.S. company purchases footwear made in Europe to distribute to retailers in the United States. E. A U.S. company that...
Which architectural pattern is most appropriate for the following multi-user, web-based system for providing a film...
Which architectural pattern is most appropriate for the following multi-user, web-based system for providing a film and photograph library?(1 Point) Please read textbook Chapter 6.3 Architectural Patterns MVC Pattern which separates presentation and interaction from the system data Layered architecture which organizes the system into layers, with related functionality associated with each layer Repository architecture - all data in a system is managed in a central repository that is accessible to all system components. Components do not interact directly, only...
The purposes of this article, capital assets are defined as tangible or intangible assets that are...
The purposes of this article, capital assets are defined as tangible or intangible assets that are used in operations and that have useful lives of more than one year, such as land and improvements to land, buildings and building improvements; vehicles; machinery; equipment; and sewer, water and highway infrastructures. Risk Assessment: A municipality’s capital assets are subject to a number of risks. Local officials must be cognizant of these risks as they seek to effectively manage their municipality’s capital assets....