Assignment Task
Question 1
a) Explain various Aggregate functions in Relational Algebra and demonstrate their usage in relational algebra operations.
b) Define Theta Join, Equi Join, and Natural Join in Relational Algebra.
Question 2
a) Identify the various categories of database users.
b) Analyze the advantages of Database Management Systems (DBMS) for each category of users. Evaluate the diverse applications of DBMS in
Question 3
a) List and explain the different Database languages available.
b) Analyze each Database language in detail. Evaluate their functionalities and applications in database management.”
Question 4
a) Describe the elements of an E-R diagram for a university database system monitoring students, courses, and instructors, with representations of relationships between students and courses, as well as instructors and courses.
b) Draw an E-R diagram illustrating the connections between students, courses, and instructors, and justify your design choices regarding entity relationships and attributes.”
Question 5
a) Define Relational Model Constraints and enumerate various types of constraints.
b) Provide an example for each type of constraint, explaining how it is applied within a relational database schema.”
Question 6
a) Define the ER Model, and list out different keys available in databases.
b) Explain various types of attributes available in the ER Model. Provide an example for each type to demonstrate their usage.
