Database

Database systems must provide capabilities for efficiently executing queries and updates. Because the database is typically stored on disk, the DBMS must provide specialized data structures and search techniques to speed up disk search for the desired records. Auxiliary files used for this purpose are called: O Schema O Indexes O Tables O Arrays In the ER diagram below depicting WORKS_FOR relationship between EMPLOYEE and DEPARTMENT, the EMPLOYEE entity has participation in WORKS_FOR relation? (0,N) EMPLOYEE Department FOR (1,1) WORKS O a. Partial b. Total OC. Incomplete d. Complete Consider the Cartesian product of relation A with relation B. If A has k tuples and N columns, B has r tuples and M columns, then the total number of tuples present in the result is: KNX OM Okur O K+rn kxr