Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Create new connection on Oracle SQL Developer. The connection name must be your name (example: Joe_Doe). Save a screenshot of the New/Select Database Connection

image text in transcribed

1. Create new connection on Oracle SQL Developer. The connection name must be your name (example: Joe_Doe). Save a screenshot of the "New/Select Database Connection" dialog to show the success status of the connection that you have created. (10 points) 2. Use Oracle SQL Developer to create the following three tables. Submit screenshots to show the tables' columns and constraints (Create Table dialog). (20 points each) A. Table name: ITEMS Column Name Type Size 60 Item_ID Item Name Price Available_Quantity NUMBER VARCHAR NUMBER NUMBER Other Information and Notes Primary key Not null Not null Must be greater than or equal to Zero Supplier VARCHAR 40 Size B. Table name: CUSTOMERS Column Type Name Customer_ID NUMBER First Name VARCHAR Last Name VARCHAR Address VARCHAR Phone NUMBER Other Information and Notes Primary key Not null 50 50 25 Unique C. Table name: TRANSACTIONS Column Name Transaction Number Item_ID Type NUMBER NUMBER Other Information and Notes Primary key Foreign key; must match an Item_ID value in the ITEMS table Foreign key; must match a Customer_ID value in the CUSTOMERS table Customer_ID NUMBER Transaction_Date DATE Page 2 of 3 3. Insert one row in each of the above tables. Use valid data. Use your name for customer first name and last name. Submit a screenshot for each committed insertion process. (15 points) 4. Export SQL script (DDL & insert data) of all tables. The sql file name must be Your Name.Sql (example: AhmedSalem.sql)-(15 points)

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

Database Concepts

Authors: David M Kroenke, David J Auer

6th Edition

ISBN: 0132742926, 978-0132742924

More Books

Students also viewed these Databases questions