0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is an attribute of a corporation share?
They are transferrable
What is the main difference between activity based costing and attribute based costing?
activity based costing does not promote TQM(total quality management) and continuous improvement but attribute based costing promotes the both.
What is the primary key for the properties table?
Primary key is to set property ID as the primary key for the properties table.
What is key field?
A field in a part or record that holds the value of a key to that record.
What are the key areas in accounts receivables?
Identify and explain the key areas of accounts receivable management.
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.
Non-prime attribute in DBMS?
Prime attribute are part of any candidate key. Non-prime attribute are not part of any candidate key.
What is the prime attribute in a database?
It is an attribute that does not occur in some candidate key.
Is foreign key a non key attribute?
a key to a different table
A condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?
transitive dependency
How would you describe a condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?
Transitive Dependency
What is difference between primary key and foreign key?
A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. A primary key is designated by underlining the attribute name. The primary key of an entity set allows us to distinguish among the various entities of the set. A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.
foreign key?
when a primary key from one table is stored as an attribute of another table
What are the requirements for a relation to be in Second Normal Form?
A relation is in second normal form (2NF) if any of the following conditions apply: The primary key consists of only one attribute No non-primary key attribute exists in the relation Every non-primary key attribute is functionally dependent on the full set of primary key attributes
Why is a Key important in a database?
a key is important in a database because using of that key only we can identify a unique attribute.
Discuss the difference between a composite key and a composite attribute.How would each be indicated in an ERD?
Attribute is the property of entity.The composite attribute is like address(where street no,house no,town name all include).Composite key is also an attribute,but only which attribute are work as a unique identifier. Example:> In an ERD if vendor placed with orders then order(order day, order number) vendor(vendor code,vendor address) Here, order and vendor both are entity and order number, vendor code both are Composite key(because those are unique)but vendor address is a Composite attribute and order day(may be not unique)is an attribute only. So, we can conclude that all attribute not Composite key.
Difference between partial dependency and fully functional dependency?
The difference is that partial dependency is when a database's attribute is only partially dependent on the primary key. Fully functional dependency is when the attribute is entirely dependent on the key.
