B.Sc. (Computer Science) Sem 1 Fundamentals of Database Systems Oct 2024 Question Paper - Mumbai University | munotes

Questions asked in this paper

SECTION I - Q.1 Attempt any two from the following questions: 10 Marks

1. 1 Differentiate between Entities and Relationship.
   Read the model answer
2. 2 List and explain any 3 advantages of DBMS in detail.
   Read the model answer
3. 3 Write a short note on group by and having clause with appropriate syntax and example.
   Read the model answer
4. 4 Define the following terms: a. Strong entity b. Relation c. Attribute d. Weak entity e. Primary key
   Read the model answer

SECTION II - Q.2 Attempt any two from the following questions: 10 Marks

1. 1 Explain the difference between left and right join with appropriate table.
   Read the model answer
2. 2 Explain any 5 math functions with appropriate example.
   Read the model answer
3. 3 What is 2NF? Elaborate it.
   Read the model answer
4. 4 Define subquery. Explain the use of IN and Exists clause in subquery.
   Read the model answer

SECTION III - Q.3 Attempt any two from the following questions: 10 Marks

1. 1 Explain the Role of DBA in detail.
   Read the model answer
2. 2 Explain any 5 date functions in detail.
   Read the model answer
3. 3 Define view. Explain how to create and alter a view with example.
   Read the model answer
4. 4 Explain the following terms with example: a) Generalization b) Aggregation
   Read the model answer

Read from the scan above, so a character or two may differ. The scan is the original.