Question $1)$ Make a comprehensive $($ERM$)$ for Student as an example with combine a Key

attribute, Composite attribute, Multivalued attribute, and Derived attribute.

Use support keywords: Stud$-$id$,$ Name, Major, Age, Address, Zip$-$code, City, Country,

Phone$\_$no$,$ Email.

Question $2)$ Represent the following different relationships by giving a clear example using

ERM

One to One

One to Many

Many to One

Many to Many

Question $3)$ Suppose that you have an employees are working in a company and you want to

create a relational database for employees with their departments and human resource

management department.

Use support keywords: FirstName, LastName, DateOfBirth, Gender, ContactNumber, Email,

HireDate, Position, Salary, DepartmentName, HRDepartmentName.

Make a data schema for above

$-$write an SQL statement to create a relationship between them.

Questions $4)$ Imagine you are the architect of a futuristic city where information

management is crucial. In this high$-$tech metropolis, the decision$-$makers are considering

adopting a database system. Craft an imaginative about the advantages of relational

databases, highlighting their significance in this advanced urban environment.