What are the major inputs into the physical database design and build process?

Discuss in detail thedecisions that are influenced bythose inputs?

$(7$marks$)$

b$)$ With an Oracle Database in mind, outline the basic data storage options

avallable, discuss primary and secondary storage and the options available

today.

$(5$ marks$)$

c$)$ What are the many benefits of usingTablespaces? Give examples. $(5$ marks$)$

d$)$ What is the role and benetit of an Index? $(3$ marks$)$

e$)$ Explain query optimisation as implemented in an Oracle environment. $(5$ marks$)$

$($