Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please complete, thank you. hw help. Topics: Database Design and Relational Model Instructions . Complete Section 1 and submit 1-FirstLastWame-Lab.txt .Complete Section 2 and submit
please complete, thank you. hw help.
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)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started