Back to the 2022 paper
Similar questions
Software Engineering"An ordering system may be adapted to cope with a centralized ordering process in one company and a distributed process in another." Which category the example belongs to? (i) Process specialization (ii) Platform specialization (iii) Environment specialization (iv) Functional specialization20212mSoftware EngineeringDifferentiate between cohesion and coupling, and explain their types in brief.20237mDatabase Management SystemWhat is the need of normalization? How many types of normalization exist? Explain in detail with suitable examples.20198mSoftware EngineeringExplain coupling and cohesion with their types and significance in software design. Explain with examples.20257m
PreviousExplain the terms ‘partial functional dependency’ and ‘transitive dependency’. Define 2NF and 3 NF in relation with these terms.NextConsider the following employee database, primary keys are underlined. Employee (ename, street, city) Works (ename, cname, salary) Company (cname, city) Manages (ename, manager-name) Write SQL queries to (i) Find the names of all the employees who work for XYZ. (ii) Find all employees who live in the same city as the company for which they work. (iii) Find all employees who live in the same cities and on the same streets as do their managers. (iv) Find all employees who earn more than the average salary of all employees of their company.