Unit 2: Relational Data Model and SQL
- Q1). What do you mean by relational model? Explain with example.
- Q2). What is relational algebra ? Discuss its basic operations.
- Q3). Write the operations in Relational Algebra.
- Q4). What is relational algebra? Describe the tuple and domian relational calculus with suitable example.
- Q5). What do you mean by referential integrity ? Explain the concept of Foreign key with a suitable example.
- Q6). What is Cursor? Write the difference between implicit cursor and explicit cursor.
- Q7). Define the following terms: 1. Super key 2. Candidate key 3. Primary key
- Q8). Write the syntax and purpose of following SQL commands: sysdate, to date(), dual table ,to_number, substr() and initcap().
- Q9). Write the various operation of Relational-Algebra operation.
- Q10). Explain views in relational algebra.
- Q11). Write a short note on SQL.
- Q12). What are the parts of SQL language?
- Q13). Write and explain the various set operations provided by SQL.
- Q14). Explain the aggregate function.
- Q15). Write a note on derived relations.
- Q16). What do you mean by Joins? Explain various types of join with examples.
- Q17). Write the various type of domains in SQL.