please answer this. thank you.
1. Problem for Chapter 4: Conceptual Modeling of Databased with ER Professor Smith would like to assign m projects to n students in a database class. Each project can be described by its name, description, deadline and status (completed or in progress); each student has a student id, a name, and an emai. Students can work in groups of several persons on one of the m projects. Different groups will take different projects (assume more projects than students, so some projects will have no students assigned) and each student participates in exactly one group. After the project for a group is finished, a grade for the project is determined and given to all students in the group. Assume each group is identified by a unique group name. In the following, you are asked to help Dr. Smith design a database system to facilitate the assignment and grading of the projects, (a) Draw an E-R diagram for the system, in particular, use arrows or thick lines to represent constraints appropriately. Write down your assumptions if you need to make any. (b) Translate the above E-R diagram to a re lational model, in particular, specify your primary key and foreign key constraints clearly. Tha is, give SQL CREATE statements that define the tables you need (c) Write an SQL statement to create a view that gives the project name and group name of completed projects. 1. Problem for Chapter 4: Conceptual Modeling of Databased with ER Professor Smith would like to assign m projects to n students in a database class. Each project can be described by its name, description, deadline and status (completed or in progress); each student has a student id, a name, and an emai. Students can work in groups of several persons on one of the m projects. Different groups will take different projects (assume more projects than students, so some projects will have no students assigned) and each student participates in exactly one group. After the project for a group is finished, a grade for the project is determined and given to all students in the group. Assume each group is identified by a unique group name. In the following, you are asked to help Dr. Smith design a database system to facilitate the assignment and grading of the projects, (a) Draw an E-R diagram for the system, in particular, use arrows or thick lines to represent constraints appropriately. Write down your assumptions if you need to make any. (b) Translate the above E-R diagram to a re lational model, in particular, specify your primary key and foreign key constraints clearly. Tha is, give SQL CREATE statements that define the tables you need (c) Write an SQL statement to create a view that gives the project name and group name of completed projects
