The document outlines the mid-term examination for the Database Management Systems course at Annamacharya Institute of Technology & Sciences, detailing the exam structure, questions, and course outcomes. It includes questions on database architecture, types of database users, SQL aggregate functions, and specific SQL queries related to given schemas. The exam is scheduled for January 24, 2024, with a maximum score of 30 marks.
The document outlines the mid-term examination for the Database Management Systems course at Annamacharya Institute of Technology & Sciences, detailing the exam structure, questions, and course outcomes. It includes questions on database architecture, types of database users, SQL aggregate functions, and specific SQL queries related to given schemas. The exam is scheduled for January 24, 2024, with a maximum score of 30 marks.
The document outlines the mid-term examination for the Database Management Systems course at Annamacharya Institute of Technology & Sciences, detailing the exam structure, questions, and course outcomes. It includes questions on database architecture, types of database users, SQL aggregate functions, and specific SQL queries related to given schemas. The exam is scheduled for January 24, 2024, with a maximum score of 30 marks.
The document outlines the mid-term examination for the Database Management Systems course at Annamacharya Institute of Technology & Sciences, detailing the exam structure, questions, and course outcomes. It includes questions on database architecture, types of database users, SQL aggregate functions, and specific SQL queries related to given schemas. The exam is scheduled for January 24, 2024, with a maximum score of 30 marks.
ANNAMACHARYA INSTITUTE OF TECHNOLOGY & SCIENCES, TIRUPATI
MCA I Year I Semester (AK22) I Mid-term Examinations – JAN 2024
Database Management Systems (22MCA0105) Time: 2 Hrs Date: 24.01.2024 (FN) Max. Marks: 30 ---------------------------------------------------------------------------------------------------------------------------------------- S No Questions M CO PO BL PI a Relate the database architecture and its types 5 CO1 1 2 1.3.1 classify the following terms 1 b (a) Tuple (b) Primary Key (c) Foreign Keys 5 CO1 1 2 1.3.1 (d) Physical Data Independence (e) Logical Data Independence a List Different type of Database users? Explain the role of DBA? 5 CO1 1 3 1.3.1 2 b What are the aggregate functions in SQL? Explain with examples? 5 CO2 2 4 2.4.1 Consider the following schema to write queries in SQL. Employee (empno,empname, Deptno, JOB, Salary, Commission, Hiredate ) Dept (Deptno, Deptname, Location) a 5 CO2 4 5 4.2.1 1. Write a query to display the highest salaries in each department. 2. Show all employees hired between 2015 and 2020. 3.Write an SQL query to fetch duplicate records from Employee Details. 3 Consider the following schema Hotel (Hotel_no, Hotel_name, City) Room (Room_no, Hotel_no, Type, Price) Booking (Hotel_no, Guest_no, DateFrom, DateTo, Room_no) b Guest (Guest_no, GuestName, GuestAddress) 5 CO2 4 5 4.2.1 i) Find the average price of a room ii) List the names and address of all guests with bookings for a hotel in London,alphabetically ordered by name iii) Find the total income from all the rooms of the hotels in NewYork Course Outcomes CO1 know the fundamentals of Databases CO2 Implement SQL and PL/SQL Concepts BL- Blooms Level: L1: Remember, L2: Understand, L3: Apply, L4: Analyze, L5: Evaluate, L6: Create * PO- Program Outcome, PI- Performance Indicator
ANNAMACHARYA INSTITUTE OF TECHNOLOGY & SCIENCES, TIRUPATI
MCA I Year I Semester (AK22) I Mid-term Examinations – JAN 2024 Database Management Systems (22MCA0105) Time: 2 Hrs Date: 24.01.2024 (FN) Max. Marks: 30 ---------------------------------------------------------------------------------------------------------------------------------------- S No Questions M CO PO BL PI a Relate the database architecture and its types 5 CO1 1 2 1.3.1 classify the following terms 1 b (a) Tuple (b) Primary Key (c) Foreign Keys 5 CO1 1 2 1.3.1 (d) Physical Data Independence (e) Logical Data Independence a List Different type of Database users? Explain the role of DBA? 5 CO1 1 3 1.3.1 2 b What are the aggregate functions in SQL? Explain with examples? 5 CO2 2 4 2.4.1 Consider the following schema to write queries in SQL. Employee (empno,empname, Deptno, JOB, Salary, Commission, Hiredate ) Dept (Deptno, Deptname, Location) a 5 CO2 4 5 4.2.1 1. Write a query to display the highest salaries in each department. 2. Show all employees hired between 2015 and 2020. 3.Write an SQL query to fetch duplicate records from Employee Details. 3 Consider the following schema Hotel (Hotel_no, Hotel_name, City) Room (Room_no, Hotel_no, Type, Price) Booking (Hotel_no, Guest_no, DateFrom, DateTo, Room_no) Guest (Guest_no, GuestName, GuestAddress) b 5 CO2 4 5 4.2.1 i) Find the average price of a room ii) List the names and address of all guests with bookings for a hotel in London,alphabetically ordered by name iii) Find the total income from all the rooms of the hotels in NewYork
Course Outcomes CO1 know the fundamentals of Databases CO2 Implement SQL and PL/SQL Concepts BL- Blooms Level: L1: Remember, L2: Understand, L3: Apply, L4: Analyze, L5: Evaluate, L6: Create * PO- Program Outcome, PI- Performance Indicator
