0
converting er diagram to table in dbms?
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
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
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
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.
table?
used to store info about entity
Is the schema describes record relationship?
A database schema describes the overall logical structure and relationship of data within the database. Such a schema will include all joins within the database and describe the relational sets. It is best thought of as a written description in formal terms describing the entities/tables, their attributes and the relations between individual tables in terms of primary (local) keys, foreign keys. A primary key is the attribute (or set of attributes) whose value(s) is unique within an individual entity/table to access all data in a single record. A foreign key, is a key from another table/entity that is used to join an entity/table with another entity/table, so that all data records related to the primary key can be displayed.
