Answered step by step
Verified Expert Solution
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
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
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