solve using oracle

Below is a database schema, which is used for a social networking website.

$1.$ Users$($login$,$ firstName, lastName, password, description, dateJoined$)$

$2.$ Links$($user$,$ linkNo, link$)$

Foreign key:

$-$ user $\backslash (\backslash$rightarrow $\backslash )$ Users.login

$3.$ Entries$($entryId$,$ user, time$)$

Foreign key:

$-$ user $\backslash (\backslash$rightarrow $\backslash )$ Users.login

$4.$ Comments$($entry$,$ parentEntry, rootEntry,text$)$

Foreign keys:

$-$ entry $\backslash (\backslash$rightarrow $\backslash )$ Entries.entryId

$-$ parentEntry $\backslash (\backslash$rightarrow $\backslash )$ Entries.entryld

$-$ rootEntry $\backslash (\backslash$rightarrow $\backslash )$ Entries.entryId

$5.$ Images$($entry$,$ caption, image$)$

Foreign key:

$-$ entry $\backslash (\backslash$rightarrow $\backslash )$ Entries.entryId

$6.$ Blurbs$($entry$,$text$)$

Foreign key:

$-$ entry $\backslash (\backslash$rightarrow $\backslash )$ Entries.entryld

$7.$ Friends$($user$,$ friend, sinceDate$)$

Foreign keys:

$-$ user $\backslash (\backslash$rightarrow $\backslash )$ Users.login

$-$ friend $\backslash (\backslash$rightarrow $\backslash )$ Users.login Your main task is to create a "Database Schema Documentation $($DSD$)"$ that fulfills$/$contains the following:

$1)$ An introduction to explain the database represented in the provided schema.

$2)$ Implement the database using a Database Management System $($DBMS$)$ of your choice, such as MySQL$,$ Oracle $...$ etc. Then add all the SQL code $--$ which was used to create the DB schema, tables and insert basic data $-$ to your DSD report.

$3)$ Based on the inserted data, you need to provide examples that clarifies the following SQL joins concepts: left outer join, right outer join, and full outer join.

$4)$ Write an SQL to retrieve the names of users who have posted comments on entries made by their friends. Use a subquery to identify the entries created by each user's friends.

$\backslash (\backslash$rightarrow $\backslash )$ The query should display a logical relation with three columns:

UserName,

FliendName

Comment Text

$5)$ Write an SQL query to display the users and the number of friends for each user. Use the COUNT aggregate function with GROUP BY$.$

$\backslash (\backslash$rightarrow $\backslash )$ The query should display a logical relation with three columns:

UserLogin,

EirstName

FriendCount