answersLogoWhite

0

converting er diagram to table in dbms?

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What are the difference between Entity Relationship Program and Flow Chart?

ER diagram is Entity Relationship Diagram which shows relationship between different entities in a process.... Data Flow diagram is a symbolic structure which shows the flow of data how it is used in diff stages in a particular process....


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).


Explain child Relationships in dbms?

A child relationship refers to an entity or table that cannot exist without the existence of another entity or table. An example of this would be a table that is created to address a many-to-many relationship between two other tables.


What are the steps to convert text to a table?

Yes you can convert it and put into the table. You need to parse the data and decide where to put it.


Difference between entity and entity set?

Entity - Table Entity Set - Rows in Table


When do you have to use an intersection entity in database?

If you have a many-to-many relationship between two entities you create an intermediate entity between.Now, the relationship between the first entity and intersection entity is one-to-many, and the relationship between the second entity and intersection entity is one-to-many also.


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 difference between relation and relationship in database?

Relation: In Database a relation represents a table or an entity that contain diffrenet attributes.An Entity constructs a relation(table) in DBMS . Relationship: In Data base relationship is that how the two entities are connected to each other ,i.e what kind of relationship type they hold between them.Primary/Foreign key is used to specify or hold this relationship. By Tanzeel Ur Rahman Bhatti


When an E-R diagram is mapped to tables the representation is redundant for?

One-to-many relationships. In the table representation, the many-side entity will have repeated data related to the one-side entity, causing redundancy. By normalizing the tables, this redundancy can be reduced.


What are the basic concepts of a database management system?

This list could easily be expanded: Tables Columns Rows Data types Normalization 3rd normal form Primary key Foreign key Relationship Entity Relationship (ER) diagram Structured Query Language (SQL) Table joins Indexing Clustered index Secondary index Views


What is strong entities vs weak entities?

The table that has primary key is strong entity and the table that has no primary key is weak entity


What is one to many relationship in database er diagram?

A one-to-many relationship means that one row in one of the tables will relate directly to many rows in the other table.