Settlement by accepting a bill of exchange 811002 , Goods Returned by M/s Kumbley & Co. 651001 , Withdrawal by proprietor for household expenses 712006 , Expenses during tour: Support Vouchers - 712007 , Expenses during tour: Support Vouchers - 712008 , Expenses during tour: Support Vouchers - 641002 Final settlement of Refer to J.V no. / 651001 , Goods taken for private use 411001 , Furniture purchased from S.N. Furniture 411001 , Goods purchased for trading put to office use 712001 , Salary to Aditya Apr.
712001 , Salary to Bimal Apr. after adjustment 712001 , Salary to Smith Apr. 712001 , Salary to Sunil Apr. 712009 , Telephone bill 711011 , Payment of Wages Test Your Understanding A.
Indicate against each of the following statements, True or False : (a) Every relation has at least one super key by default, which is the combination of all its attributes. (b) Data transformation is called Information. (c) Referential integrity constraint arises because of relationships between various entities. (d) The complete absence of WHERE clause in SELECT statement implies that no tuples of a relation shall be selected.
(e) ER model is an example of representational data model. B. Fill in the blanks, an appropriate word(s) (a) A ........... does not have key attributes of its own.
(b) The ........... for binary relationship specifies the number of relationship instances that an entity can participate in. (c) Each simple attribute of an entity type is associated with a value set called ........... of values.
(d) When structure of AIS is based on both human and computer resources, it is called ........... AIS. (e) An ........... is a collection of all entities of a particular entity type.
(f) A weak entity type always has a ........... constraint with respect to its identifying relationship. (g) When a relation has more than one attribute with unique values, each such attribute is called ............ After appreciating the way accounting data