what do u mean by lossiess join in dbms
multivalued data
sdfsfas
save point saves the dbms and check point simply check the database thats it simple
TUPLE : Is the "ROW" in a table
the number of tuple in a relation is called the cordinality of a relation?
difference between relation sehema and relation instance in dbms
d_id,d_name
Third normal form.
A software system that facilitates the creation and maintenance and use of an electronic database
It is the number of attribute of its relation schema. Its is an association among two or more entities..
In DBMS, a relation instance refers to a particular set of data rows within a database table at a given point in time. It represents the actual values stored in the database for that specific table. Each row in a relation instance corresponds to a record or tuple within the table, containing values for each attribute.
To create an unnormalized table, you can combine multiple related entities and their attributes into a single table without splitting them into separate tables. This violates the principles of database normalization, leading to redundancy and potential data anomalies. Unnormalized tables can be created by directly designing the database schema without following normalization rules.
A table that contains one or more repeating groups.
Since relation is a set, and tuples are element of a set, according to set theory, the elements of a set are not ordered.
NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced 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.