please complete in full.

Topics: Database Design and Relational Model Instructions . Complete Section 1 and submit 1-FirstLastWame-Lab.txt .Complete Section 2 and submit 1-FirstLastName.pdf Section 1 This section covers the practical implementation of a database schema using DDL and data manipulation using DML (50 points) .Login in to the Linux Oracle server and access the database using sqlplus (refer to Oracle Linux Server Instructions) Modify line size using: SET LINESIZE 300 Display the SQL commands using: SET ECHO ON Create your homework submission log file using: SPOOL 1-FirstLastName-Lab.txt command . monikarathod- mrathod oraclelinuxssh 131x34 Inrathod@oraclelinux -s sqlplus mrathod/oracle SQL Plus: Release 12.1.0.1.8 Production on Mon Sep 18 13:14:52 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved Last Successful login time: Mon Sep 18 2017 13:11:40 -04:90 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.8-64bit Production With the Partitioning, OLAP. Advanced Analytics and Real Application Testing options SQL> set linesize 30e SQL> spool 1-MonikaRathod-Lab.txt SQL> To terminate log file after working on parts A), B) and C) use: SPOOL OFF command . A) Using SQL, construct DDL statements that create the relational schema below. Include all the necessary domain key, and referential integrity constraints (25 points) artist(ar id: integer, name: string, gender. string, genre: string) album(al id integer, ar id: integer, year. name: string, cost number) song (s_id: integer, al id: integer, title: string, duration: number)