Consider a SQL database$$diploma$$with a table named$$modules$.$ The$$modules$$table has the following columns:

$-$code$,$ which is the primary key of the table for storing unique $7-$character module codes

$-$name$,$ which stores module names

$-$lecturer$,$ which stores the names of the primary lecturers for the modules

$$

Assume that the$$modules$$database table has been populated with the following information:

$$

ICT$2612$ Interactive Programming Dr S Bheki

ICT$2613$ Internet Programming Dr A Thomas

ICT$2632$ Digital Logic Dr D Smit

$$

Answer the questions that follow:

$($a$)$ Can the database$$diploma$$have additional tables? Explain your answer. $(2$ marks$)$

$($b$)$ Can two rows of data in$$modules$$have the same value for the field$$lecturer$?$ Explain your answer. $(2$ marks$)$

$($c$)$ What data given in the description of this question is unnecessary to create a PDO object? $(2$ marks$)$

$($d$)$ Assume that a database connection is established using a PDO object named$$$db$.$ Write the necessary PHP code to extract all the data in the$$modules$$database table and display the data in a format of your choice. $(8$ marks$)$