Please help me answer the below questions, thank you so much.The magazine distributor company has several branches throughout Malaysia. The

data identifying each branch address, telephone number $($maximum up to $2$ telephone

numbers$),$ and fax number. Each branch is given a branch number which is unique

throughout the company. Each branch has staff and the data identifying on each staff

is the name, position, salary, and the data a staff joined. Each member of staff is given

staff number, which is unique throughout the company.

The company distributes a variety of magazines, which are identified by the magazine

code. Data identifying each magazine are number of issues per year, price of each

issue, and nature of language. When a customer orders a magazine, order duration,

total payment, and payment method are recorded.

Each customer is given a unique number throughout the company. The data accorded

to each customer is the name, adders, and contact number.

Number of orders from each branch varies each month; therefore, month and year

$($as single attribute$),$ and number of copies are recorded for each branch one each

magazine title.

Question $1$

$($a$)$ Database design consists of three phases which are known as conceptual,

logical and physical.

Use a diagram to illustrate this database modeling concept. Compare and

contrast all the three phases with the use of MAGAZINE DISTRIBUTOR

COMPANY as the example.

$[10$ marks$]$

$($b$)$ Describe the following with examples when tables are designed and created $($use

the scenario$)$:

i$.$ Data Manipulation Language $($DML$)$

$[2$ marks$]$

ii$.$ Data Definition Language $($DDL$)$

$[2$ marks$]$

iii. Data Control Language $($DCL$)$

$[2$ marks$]$

$($c$)$ Describe with an example, the approach taken for the handling of data in early

file$-$based systems that are used before the MAGAZINE DISTRIBUTOR

COMPANY proposal.

$[4$ marks$]$

Question $2$

Draw an $($Object Oriented Entity Relationship$)$ OOER diagram to represent thedata

requirement of MAGAZINE DISTRIBUTOR COMPANY.

The OOER diagram should consist of entities, relationships, attributes associatedwith

the entities or relationships, cardinality and optionality for the relationships and the

primary key.