Describe the SQL set operations
The SQL set operations are : In essence:
DBMS PYQ
Discuss join and types with suitable example. Define join. Explain different types of join.
Inner Join: Employee.Emp_Name Employee.City Employee_Salary.Salary Hari Pune 10000 Om Mumbai 7000 Jai Solapur 5000 Outer Join: a. Left Outer Join: Employee.Emp_Name Employee.City Employee_Salary.Salary Hari Pune … Read more
Explain how a database is modified in SQL. OR Explain database modification.
1. Delete: 2. Insert: 3. Update:
Explain the following constraints : i. Entity integrity constraint. ii. Referential integrity constraint. iii. Domain constraint.
Entity Integrity Constraint: SID Name Class (semester) Age 8001 Ankit 1st 19 8002 Srishti 1st 18 8003 Somvir 4th 22 8004 Sourabh 6th A Referential … Read more
Explain integrity constraints.
Integrity constraints and Data Consistency: Integrity Constraints in ER Models: In summary, integrity constraints are vital components of database design and management, serving to enforce … Read more
What are the additional operations in relational algebra ?
Set Intersection Operation (⋂): Natural Join Operation (⨝): Division Operation (÷): Assignment Operation (←): These operations provide a way to manipulate and combine relations in … Read more
Consider the following relations:
Student (ssn, name, address, major)Course (code, title)Registered (ssn, code)Use relational algebra to answer the following :a. List the codes of courses in which at least … Read more
Explain constraints and its types.
Constraints Overview: Types of Constraints: 1. NOT NULL: 2. UNIQUE: 3. DEFAULT: 4. CHECK: 5. Key Constraints: a. Primary Key: b. Foreign Key: 6. Domain … Read more
What is relational model ? Explain with example.
Customer Table (Table 2.1.1): cust_id c_name c_city C_101 Ajay Delhi C_102 Amit Mumbai C_103 Alok Kolkata C_104 Akash Chennai Account Table (Table 2.1.2): acc_no balance … Read more
What is Unified Modeling Language ? Explain different types of UML.
Unified Modeling Language (UML) is a standardized way for developers to visually represent and design software systems. It helps in specifying, visualizing, constructing, and documenting … Read more