1. [50 points] Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students transcripts. Draw an Entity-Relationship (E-R) diagram for this application. Specify key attributes (identifiers) of each entity type and constraints on each relationship type. Note any unspecified requirements, make appropriate assumptions to make the specification complete.

(a) The university keeps track of each students name (consisting of firstname, middlename, and lastname), student number, social security number, address (consisting of street address, city, state, and zip code), phone number, birth date, gender, class, major department, minor department (if any), and degree program. Both social security number and student number have unique values for each student. All students will have at least a major department.

(b) Each department is described by a name, department code, office number, office phone, and college. Both name and code have unique values for each department.

(c) Each course has a course name, description, course number, number of credits, level and offering department. The value of course number is unique for each course.

(d) Each section has an instructor, semester, year, course, and section number. The section number depends on different sections of the same course that are taught during the same semester/year; its value is an integer (1, 2, 3, . . . up to the number of sections taught during each semester).

(e) A grade report must be generated for each student. The report also lists the section, letter grade, and numeric grade (0,1,2,3, or 4) for each student and calculates his or her average GPA.

2. [50 points] Consider the following ER diagram shown for a BANK database. Each bank can have multiple branches, and each branch can have multiple accounts and loans.

(a) List the strong or regular entity types in the ER diagram.

(b) Is there a weak entity type? If so, give its name, partial key, and identifying relationship.

(c) What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram?

(d) List the names of all relationship types, and specify the cardinality constraint (one-to-one, one-to-many, many-to-many) on each participation of an entity type in a relationship type. Justify your specifications.

Would someone be able to help me with this? And could someone please use this site, https://erdplus.com/standalone ?