Back to the 2022 paper
Similar questions
Database Management SystemWhat are four main differences between file-processing system and a DBMS?20207mDatabase Management SystemIt is better to use files than a DBMS when there are (i) stringent real-time requirements (ii) multiple users wish to access the data (iii) complex relationships among data (iv) All of the above20202mDATABASE MANAGEMENT SYSTEMIllustrate the database characteristics, How they are different from File systems.20247mDatabase Management SystemCompare the traditional file-based systems and relational database management system approaches.20197m
PreviousConsider 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.NextWhat is weak entity set? Explain with suitable example. How weak entities are represented as relational schemas.