Database example

Needed By 11pm tonight EST Design an ER-Model and draw the ER-Diagram. For each entity propose at least 3 attributes. You should have at least a weak entity, a generalization-specialization hierarchy, and a multivalued attribute. Propose a Relational model (a set of tables) implementing your ER-diagram, and draw the relational diagram. Write a Relational Algebra Query to retrieve the list of exams available for student “Isabella”, listing: the class name, semester, name of test, deadline of test, type of test, the number of possible attempts, the last attempt already taken, and the grade. Write a Relational Algebra Query to retrieve the list of test attempts already taken in the past by student “Bader”, listing: the class name, semester, name of test, deadline of test, test type, the attempt number, the date of the attempt, and the grade. Write a Relational Algebra Query to retrieve the list of tests in the classes of instructor “Silaghi”, listing: the class name, semester, name of test, deadline of test, and the date of the last attempt by some student. Write a Relational Algebra Query to retrieve the list of student names for all students who took all tests posted by instructor Silaghi. Write a SQL DDL query for creating the table for entity test. Write a SQL query to retrieve the list of exams available for student “Erika”, listing: the class name, semester, name of test, deadline of test, type of test, the number of possible attempts, the last attempt already taken, and the grade. Write a SQL Query to retrieve the list of student names for all students who took all tests posted by proff.