0
What else can I help you with?
What is the difference between single-valued attributes and simple attributes?
single valued attribute are one character in a record
What is a simple key in database?
A simple key consists of a single attribute to uniquely identify an entity occurrence, for example, a student number, which uniquely identifies a particular student. No two students would have the same student number.
What are key attribute and non key attribute?
Attributes can be classified as identifiers or descriptors. Identifiers, more commonly called keys or key attributes uniquely identify an instance of an entity. If such an attribute doesn't exist naturally, a new attribute is defined for that purpose, for example an ID number or code. A descriptor describes a non-unique characteristic of an entity instance. An entity usually has an attribute whose values are distinct for each individual entity. This attribute uniquely identifies the individual entity. Such an attribute is called a key attribute. For example, in the Employee entity type, EmpNo is the key attribute since no two employees can have same employee number. Similarly, for Product entity type, ProdId is the key attribute. There may be a case when one single attribute is not sufficient to identify entities. Then a combination of attributes can solve this purpose. We can form a group of more than one attribute and use this combination as a key attribute. That is known as a composite key attribute. When identifying attributes of entities, identifying key attribute is very important.
What value is the one that a DBMS initially displays in a field?
a default value
What do you mean by functional dependancy in dbms?
Dependency means that the one entity dependents on another entity. This is also applicable for the Function also. For Example : If you trying to check the general function which tells you about the rooms availability, which consist of checkFreeRooms() and we can have the checkForACRooms() and CheckForSuits(), So the general function for checking Rooms dependents on the other rooms as above
What is complex attribute in dbms?
Complex Attribute: A complex attribute is an attribute that is both composite and multivalued.
What is attribute value in DBMS?
Values of columns
What is derive attribute in DBMS?
Surrogate ID's
Non-prime attribute in DBMS?
Prime attribute are part of any candidate key. Non-prime attribute are not part of any candidate key.
Define attribute in dbms?
In DBMS a table contains one or more columns there columns are the attribute in DBMS FOR EXAMPLE---say you have a table named "employee information"which have the following columns ID,NAME,ADDRESS THEN id ,name address are the attributes of employee..................
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..
Define domain with respect to dbms?
In database technology, domain refers to the description of an attribute's allowed values. The physical description is a set of values the attribute can have, and the semantic, or logical, description is the meaning of the attribute.
What is the more common name for attribute?
In a database management system (DBMS), an attribute may describe a component of the database, such as a table or a field, or may be used itself as another term for a field. Commonly we can say that an attribute is a "propety" of a database field or its a characteristic or facet of the data field..
What is simple and composite attribute?
the term composite identifier
What is difference between check point and save point in DBMS?
save point saves the dbms and check point simply check the database thats it simple
Examples of functional dependency in dbms?
a functionaly dependency is an association between two relational attribute of same relational database.one of the attribute is known as determinant and the other one is determined.for the each value of determinant there is only one value associated of determined. graphicaly it can be represented A----->B .
What is functional dependency in DBMS?
A key is a set of attributes that uniquely identifies an entire tuple, a function dependency allow us to express constraints that uniquely identify the values of certain attribute.
