Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

29 / 63 D 42% Question 1. Create the following tables: Challan Header Column name datatype Challan_Do vauchar2 size 6 Attributes Primary key $_order_10 varchar2

image text in transcribed

29 / 63 D 42% Question 1. Create the following tables: Challan Header Column name datatype Challan_Do vauchar2 size 6 Attributes Primary key $_order_10 varchar2 6 Foreign ley references S_order_no of sales_order table challan_date date 20 not mull buled_y char 1 Values ("Y". N). Default 'N Challan Details Column name data type size Attributes Challan_10 varchar2 6 Primary key Foreign key references Product_no of product_master Qty_disp mumber 42 Botti Q2. Insert the following values into the challan header and challan_details tables: Clau_NO S order o Billed Challan_Date 12-DEC-95 CHOUT 019001 Y CH865 046865 12-NOV-95 Y CH3965 010008 12-OCT-93 Page 29 0502241-3 Fundamentals of Database Data for challan_details table Challan No Product No Ory Disp CH9001 CH9001 CH9001 CH6865 CH6865 CH6865 CH3965 CH3965 P00001 P07965 P07885 P07868 P03453 P00001 P00001 P07975 1 3 4 10 5 2 Answer the following Questions? Q2. Add a new columm phone_no in the client_master table. Q3. Add the not mull constraint in the product_master table with the columns description prot percent, and sell price and cost price Q4. Change the size of client_no field in the client_master table Q5. Select product_no, description where profit percent is between 20 and 30 both Inclusive

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

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

More Books

Students also viewed these Databases questions

Question

What are the objectives of Human resource planning ?

Answered: 1 week ago

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago

Question

LO1 Summarize the organizations strategic planning process.

Answered: 1 week ago