Database Management System Unit 2 Notes AKTU (BCS501)

AKTU · BTECH · Semester 5 · Database Management System · Unit 2 · Notes

AKTU Database Management System (BCS501) Unit 2 notes for B.Tech Semester 5 – Relational Model and SQL. Topics: Relational Data Model, SQL Basics and…

Open the interactive reader to study this resource on AcademicArk.

Unit 2: Relational Model and SQL – AKTU syllabus topics

  • Relational Data Model: Entity Referential Integrity Constraints, Relational Algebra, Tuple and Domain Calculus
  • SQL Basics and Commands: SQL Data Types Commands, Tables Views Indexes
  • SQL Queries and Operations: Aggregate Functions Subqueries, Joins Unions Intersection Minus, Insert Update Delete Operations
  • Cursors Triggers Procedures

Most asked AKTU PYQ questions from Unit 2

  1. Q4a. What is Aggregate Function in SQL? Write SQL query for different Aggregate Function. (10 marks, 2020-21)
  2. Q2b. What is Relational Algebra? Explain Different Operations of Relational Algebra with Example. (10 marks, 2020-21)
  3. Q4a. Consider the following schema for institute library: Student (RollNo, Name, Father_Name, Branch), Book (ISBN, Title, Author, Publisher), Issue (RollNo, ISBN, Date-of-Issue). Write the following queries in SQL and relational algebra: (i) List roll number and name of all students of the branch… (10 marks, 2022-23)
  4. Q4a. Consider the following relational DATABASE. Give an expression in SQL for each following queries Underline records are Primary Key Employee (person_name, street, city) Works (person_name, Company_name, salary) Company (Company_name, city) Manages (person_name, manager_name) a) Finds the names of… (7 marks, 2025-26)
  5. Q4b. Explain different types of Triggers in SQL/PL SQL. (10 marks, 2022-23)
  6. Q2b. What are Joins? Discuss all types of Joins with the help of suitable examples. (10 marks, 2022-23)
  7. Q2b. Which relational algebra operations require the participating tables to be union-compatible? Give the Reason in detail. (10 marks, 2021-22)
  8. Q4a. Employee (ename, street, city) Worksfor (ename, company_name, salary) Company (Company_name, city) Construct the SQL statements for the following (i) Create the above given tables with suitable data types and size. (ii) Find the name of employees who live in the same city where they work. (iii)… (7 marks, 2024-25)
  9. Q2b. Explain Joins? Discuss all types of Joins with the help of proper example of each. (7 marks, 2024-25)
  10. Q4b. Consider the following three relation schema S, P and SP in which S# is supplier code, P# part number and qty is quantity and others carry their respective meanings: S(S#, SNAME, SCITY, TURNOVER) P(P#,WEIGHT, COLOR, COST, SELLING PRICE) SP(S#, P#, QTY) Construct the appropriate RA statement for… (7 marks, 2024-25)

AKTU paper codes: BCS501, KCS501, RCS501

Other Database Management System units

Database Management System previous year papers

More Database Management System resources

More versions of this resource

Browse all notes · Semester 5 notes