Business Scenario:

You are required to build a database for a university with students and courses. Each student has an ID$,$ name, GPA, and address. A student can register multiple courses. Each course is identified with a course ID $($No$),$ name, and credits.

Q$)$ For the business scenario given above, write the business rules that describe all entities, relationships, and constraints. You can follow the below format or use any other preferred format. Make sure you satisfy the requirements.

For each Entity:

Entity name and an attribute list, with the attribute name and the following information:

Attribute domain and size, e$.$g$.$ CHAR$(10),$ INT, VARCHAR$(30)$

Required$/$Optional $($i$.$e$.,$ not Null$)$

Unique$/$Duplicated

Key constraints $($PK$,$ FK$,$ PF$/$FK$,$ or None$)$

For each Relationship:

A given name of the relationship and the following information:

Involved entities

Relationship type $(1$:$1,1$:M$,$ M:$1,$ M:M$)$

Special participation and cardinality $((0,1),(1,10),...)$

Relationship strength $($Weak$/$Strong$)$

Example of Entity:

Student

ID: INT, Required, Unique, PK

Name: VARCHAR$(20),$ Required, Duplicated, None

$...$

Example of Relationships:

Relationship name: Course$\_$Registration

Between Student and Course

M:M

$(0,$ m$)$ and $(0,$ m$)--$ i$.$e$.,0$ or many students can take a course and a course can have $0$ or many students

Strong