Assignment Title: ORDBMS and NOSQL Database Design and Comparison

Objective: This assignment is designed to compare database structures and data handling in two advanced database models: Object$-$Relation DBMS $($ORDBMS$)$ representing PostgreSQL$/$Oracle and NoSQL DBMS representing MongoDB. You will observe and compare how these databases manage different database structures, including mandatory, optional, multi$-$valued, composite and complex attributes.

Part $1$: Define and Structure Data

Create an entity with the following attributes, divided into mandatory and optional fields:

Mandatory Fields $($Single$-$valued$)$:

ID: Unique identifier for each entry.Name:

First NameMiddle NameLast Name

Date of BirthCGPATotal CreditsDepartmentAddress:

Present Address:

House NumberStreetThanaDistrict

Permanent

House NumberStreetThanaDistrict

$$

Mandatory Fields $($Multi$-$valued$)$:

Phone Number$($s$)$Email Address$($es$)$

Optional Fields $($Multi$-$valued$)$:

Memberships: Any memberships the individual holds.Research Interests: Fields of research interest.Programming Knowledge: Specify languages known $($e$.$g$.,$ C$,$ Java$).$Educational Qualifications:Structure a record to store academic qualifications $($degree$,$ institution, and year of graduation$).$

Family tree

Father and father of father and othersMother and mother of mother and othersSon$/$Daughter and children of sons and daughters

Part $2$: Database Comparison: ORDBMS $($ PostgreSQL$/$Oracle$)$ vs$.$ NoSQL $($MongoDB$)$

Implement and store data in both MongoDB and$$ PostgreSQL$/$Oracle using the following cases:

Case $1$: Only mandatory fields are filled. Insert sample data with $1-2$ entries.

Case $2$: All fields $($both mandatory and optional$)$ are filled. Insert sample data with $1-2$ entries.

Case $3$: Mandatory fields and a random subset of optional fields are filled. Insert sample data with $2-3$ entries.

MongoDB JSON Structure Observation:

For each case, observe the JSON structure generated by MongoDB for storing the data. Take screenshots or notes on the structure for comparison purposes.

PostgreSQL$/$Oracle Data Structure Observation:$$

For the same entries, insert data into PostgreSQL$/$Oracle$.$ Take screenshots or notes on the PostgreSQL$/$Oracle structure and record any necessary adjustments for multi$-$valued and nested fields.

Comparison & Analysis:

Compare the data structure differences between MongoDB and PostgreSQL$/$Oracle for each case.

Describe any structural advantages or disadvantages of using MongoDB vs$.$ PostgreSQL$/$Oracle for the given data type and multi$-$valued fields.

Summarize your findings with insights on the best use cases for each database system based on this exercise.

Submission Requirements:

A report in pdf format summarizing the above activities including the following:

Screenshots or notes documenting the data structure in both MongoDB and PostgreSQL$/$Oracle$.$

A comparison table summarizing key differences in structure, storage efficiency, and data handling for each case.

An analysis explaining which database would be more efficient or convenient for each case and why.