Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions

Question

4. Who should be invited to attend?

Answered: 1 week ago

Question

7. How will you encourage her to report back on the findings?

Answered: 1 week ago