User

This is a database assignment. the question is :

Institute of Information Technology $($IIT$)$ is an Information Technology institute with hundreds of students. It is necessary to keep track of all the different classes that are being offered, who is assigned to teach each class, who is qualified to teach each course, and which students take each class. Also, it is important to track the progress of each student as they advance.

a$.$ IIT offers three certificate programs, namely, Certificate in Information Technology, Certificate in Cybersecurity, and Certificate in Business Analytics. Each certificate consists of six courses. Basic IT courses such as Programming and Database Management are required for all three certificate programs. A list of courses for each certificate is stored. Each course has a code, title, and description.

b$.$ Each time a particular course is offered, it is called a $$class$$ of the course. IIT offers several classes of each course.

c$.$ Each class is offered during a given semester. Semester defines the year and the term that the class will be offered $($e$.$g$.,$ Spring $2022).$

d$.$ Students are given a student identification number when they join the institute. This is stored along with their name, date of birth, address, contact number, and the date they joined. A student can register for only one certificate program at a time. A student may enroll in several classes and each class may have several students.

e$.$ IIT maintains records about all instructors including their name, address, contact number, email address, and rank. An instructor may be assigned to teach up to $3$ classes, but each class has one and only one assigned instructor.

f$.$ IIT also keeps track of courses that a particular instructor is qualified to teach. An instructor can be qualified to teach more than one course. There can be more than one qualified instructor to teach a course.

$1.$ Identify all the entities in this company. $(5$ points$)$

$2.$ For each entity, list its attributes. $(5$ points$)$

$3.$ Describe the possible relationships between the various entities. $(5$ points$)$

$4.$ Now you are ready to create a Crow$$s Foot notation E$-$R diagram for this case. For each entity, include the attributes, the primary key, and foreign keys $($if any$).$ Name each relationship and indicate both the minimum and maximum cardinalities. If you cannot infer the cardinalities from the case description, make your own assumptions. Use MySQL Workbench to draw your ERD. $(15$ points$)$

Also please assign cardinality$($min$,$ max$).$

Also assign relationships and connectivity.

Also, assign primary and foreign keys.

Shared below doc for cardinality is what It i meant by cardinality:

Cardinality: expresses the minimum and maximum number of entity occurrences associated with one occurrence of related entity

In the ERD, cardinality is indicated by placing the appropriate numbers beside the entities, using the format $($x$,$ y$).$