Question $1$Construct an entity relationship diagram $($ERD$)$ for the following situation. $[15$ marks$]$A person may own any number of cars, including noneEach car has exactly one ownerEach car must be registered in a particular countryCars are identified by registration numbersCars can have different engine sizesA person may hold only one passportA passport is issued by a single countryEach person has a name and addressNo two people have the same national numberEach country has an official nameEach passport has a unique passport numberQuestion $2$ PART A Normalize the form into a database design, clearly showing the stages of UNF, $1$NF$,2$NF and $3$NF$.$ State any assumptions you make about the data particularly in relation to any data which you feel is redundant, superfluous, missing or incomplete. $(20$ marks$)$ Please complete the following FOUR $(4)$ parts:Based on Form shown above, write down the unnormalized form. $(5$ marks$)$Identify the repeating group of attributes and transform part $($i$)$ into tables that are in $1$st Normal form. $($Explain the rationale for your decision$).(5$ marks$)$Identify any partial dependencies in part $($ii$)$ and transform into tables that are in $2$nd Normal Form. $($Explain the rationale for your decision$).(5$ marks$)$Identify any transitive dependencies in part $($iii$)$ and transform into tables that are in $3$rd Normal Form. $($Explain the rationale for your decision$).(5$ marks$)$ PART B Create the database for Duraware and softlights based on the normalized tables you obtained in question $2.$ The physical database can be created using DDL $($Data Definition Language$)$ and manipulated using DML $($Data Manipulation Language$),$ which enable users to access or manipulate data as organized by the appropriate model. $(35$ marks$)$i$)$ Using the CREATE TABLE in any dialect of SQL$,$ show the corresponding SQL tables. Indicate the primary key, foreign keys, column names, constraints etc.ii$)$ Insert $($at least$)10$ sample rows for each identified table. Student must test their database using at least the following:Restriction and ProjectionAliasesNULL value handlingConcatenationComparison OperatorLogical OperatorSortingFunction $()$Group function & Single Row FunctionJoinsSubqueries $($iii$)$ Write SQL statements and queries for each using the following:DDL Data Definition Language. $($CRETATE$,$ DROP, ALTER, TRUNCATE$)$DQL Data Query Language. $($SELECT$)$DML Data Manipulation Language.$($INSERT$,$ UPDATE, DELETE, CALL, LOCK$)$DCL Data Control Language. $($ GRANT, REVOKE$)$TCL Transaction Control Language.$($COMMIT$,$ SAVEPOINT, ROLLBACK, SET TRANSACTION, SET CONSTRAINT$)$