0
When an E-R diagram is mapped to tables the representation is redundant for?
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
Meaning of external representation of data?
External representation of data refers to how information is presented or encoded in a format that can be accessed or understood by users or systems outside of its original source. This can include visual representations, such as graphs, charts, or tables, as well as file formats, such as PDFs or spreadsheets, that allow for sharing and manipulation of the data.
Which one of the following diagrams is the most helpful in designing a relational database in which to store object data?
The Entity-Relationship diagram is the most helpful in designing a relational database to store object data. It visually represents entities, their attributes, and the relationships between them, providing a clear understanding of the database structure and enabling effective planning of tables and relationships.
What is the process of streamlining data to minimize redundancy and awkward many to many relationships?
The process typically involves normalizing the database by breaking down data into separate tables to eliminate redundant information and creating one-to-many relationships instead of many-to-many relationships. This helps reduce data duplication and ensures efficient data storage and retrieval. The use of foreign keys can also help establish relationships between different tables, leading to a more streamlined database design.
What is the representation of data?
Representation of data refers to the way information is structured and displayed in a format that can be easily understood and processed by machines or humans. This can include using tables, charts, graphs, or other visual aids to present data in a meaningful way for analysis and decision-making.
What is the database that contains tables linked by common fields?
A relational database is a database that contains tables linked by common fields. These common fields are used to establish connections between the tables and to retrieve related data across multiple tables using queries.
What should be the erd for website design?
ERD is an Entity Relationship Diagram which is a graphical representation of database entities (tables, table columns, table definitions, attributes) and inter-relationships between these entities (how the tables are connected).
What is a number being multiplied over and over?
Times tables =/ Or maybe a redundant number.
Explain First NormalForm in RDBMS?
Eliminates redundant data. Splits larger into smaller tables.
Showing dependencies with a data flow diagram?
If you are asking can you show dependencies in a data flow diagram; the answer would be yes. Under traditional guidelines however you would use a UML diagram for this purpose. A UML Diagram will be used to show detailed database architecture. A data Flow diagram will show the FLOW representation of data; from the application, through the middle tier, and database. This is used as the name represents to demonstrate the FLOW from point A to point Z. UML will show the actual structure of your database; the tables, fields in the tables, relationships, etc. this will typically be accompanied by full database documentation which will detail the intended use of the database, external system dependencies.
What are the problems associated with redundency?
The problems associated with redundant data can be addressed by data normalization. Normalized tables generally can contain no redundant data because each attribute only appears in one table. Also, normalized tables do not contain derived data and instead, the data contained can be computed from existing attributes which has been selected as an expression based on the said attributes.
Why are tables and graphs usful for organnizing scientific data?
Tables and graphs are useful because they help u visual and representation and organize information to show patterns andrelationship.
How are the twelve tables a like with the bill of rights?
There is no comparison These were very archaic laws (dating to 450 BC) and applied to a very archaic society. Even the Romans modified their laws over the centuries so comprehensively that the Twelve tables became redundant.
What kind of analytical tool allows a systems analyst to present graphic representation of a system?
Modeling Tools are analytical tools such as charts, tables and diagrams used by systems analysts to present graphic, representation of a system.
How do you document a database?
Two standard ways to document a database are to create a relational diagram and a data dictionary.A relational diagram will display all the tables in a database with links to joining tables utilizing the primary and foreign keys. For a more detailed description visit- http://www.utexas.edu/its/windows/database/datamodeling/dm/erintro.htmlA data dictionary is a reference guide of all the tables and fields in a database and the use of each object.
What are the merits of tabular representation of data?
They are:1] it is useful to distinguish between raw data tables and analytic tables2] It is a way of conveying information to a reader or to readers
How do you draw an entity-relationship model?
to draw an Er-diagram you need >> objects >> relationship between these objects >>database associated with each object and relationship er digram is a graphical representation of a database and its tables first u hav to create database needeed for entire system after this identify primarykey/key attribute for each table and establish relationship between objects
What is the use of er diagrams?
A graphical representation of entities and their relationships to each other. Typically used in computing in making databases or information systems. An entity is a piece of data-an object or concept about which data is stored. A relationship is how the data is shared between entities. There are three types of relationships between entities like one-to-one, one-to-many and many-to-many. Entity Relation Diagram is giving you image of how the tables should connect, what fields are going to be on each table, the tables connection.
