0
relationship instance is an association of entity instances
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What is extension and intension in dbms?
extension in a relation is set of tuples appearing in relation at any given instance . it varies with time .it changes tuple are created ,destroyed and update
Dbms and rdbms?
DBMS and RDBMS both are used for storing data. DBMS is the database management system that refers to the collection of interrelated data. RDBMS define relation between the tables in the database
What is the difference between relation and relationship in dbms?
Relationship is purely a construct of the er data model.Relation is a structure of the relational data model.
What are three types of dbms?
Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.
What is relation between sql and dbms?
As we all know that SQL stand for sequence query language. it is a unique language use for control or manipulate data in DB. And DBMS is a software. So they both are noting without each other. There is a relationship of compiler and language in between them.(written bySYED FATEHYAB AHMEDfrom biit)
What is the Difference between relation schema and relation instance?
difference between relation sehema and relation instance in dbms
What is extension and intension in dbms?
extension in a relation is set of tuples appearing in relation at any given instance . it varies with time .it changes tuple are created ,destroyed and update
What is the cordinality of dbms?
the number of tuple in a relation is called the cordinality of a relation?
What do extension and intentions of relations mean in dbms?
ExtensionThe extension of a given relation is the set of tuples appearing in that relation at any given instance. The extension thus varies with time. It changes as tuples are created, destroyed, and updated.
Give entity relation diagram for hospital system in dbms?
d_id,d_name
What is decomposition in dbms?
Decomposition means replacing a relation with a collection of smaller relations.
What is minimal normal form a relation must satisfy in dbms?
Third normal form.
Dbms and rdbms?
DBMS and RDBMS both are used for storing data. DBMS is the database management system that refers to the collection of interrelated data. RDBMS define relation between the tables in the database
Why relation have key in DBMS?
A software system that facilitates the creation and maintenance and use of an electronic database
What do you mean by degree in DBMS?
It is the number of attribute of its relation schema. Its is an association among two or more entities..
What is the difference between relation and relationship in dbms?
Relationship is purely a construct of the er data model.Relation is a structure of the relational data model.
Why duplicate tuples are not allowed in DBMS?
Since relation is a set, and tuples are element of a set, according to set theory, the elements of a set are not ordered.
