Structuring Database for Accounting
Chapter 14: Structuring Database for Accounting · ACCOUNTANCY · EN medium
From your actual textbook ✓
What does your textbook say about Structuring Database for Accounting?
IV. Ambiguous Attribute Names and Renaming ( Aliasing ) : SQL allows the use of homonyms (that is same name for two or more attributes) as long as such attributes are in different relations. If the use of a common attribute with a particular name across the relations prevails, it becomes necessary to qualify the attribute name with relation name in which it exits. This is achieved by prefixing the relation name to the attribute name and separating the two by a period symbol dot. In Model-II, the attribute Vno, referring to voucher number in vouchers relation, also exists in details
📖 Accounts 14 (1) · Page 39
Read from the source
Complete lesson
IV. Ambiguous Attribute Names and Renaming ( Aliasing ) : SQL allows the use of homonyms (that is same name for two or more attributes) as long as such attributes are in different relations. If the use of a common attribute with a particular name across the relations prevails, it becomes necessary to qualify the attribute name with relation name in which it exits. This is achieved by prefixing the relation name to the attribute name and separating the two by a period symbol dot.
In Model-II, the attribute Vno, referring to voucher number in vouchers relation, also exists in details
Related topics
Want this shaped for your exam marks?
Get an AI answer grounded in your actual textbook — with the exact page reference.
Ask AI about this topic →