×
The best revenge is massive SUCCESS
--Your friends at LectureNotes
Close

Database Management System

by Umesh KumarUmesh Kumar
Type: PracticalInstitute: Guru Ghasidas Viswavidhyalaya Specialization: Computer Science EngineeringOffline Downloads: 4Views: 62Uploaded: 1 month ago

Share it with your friends

Suggested Materials

Leave your Comments

Contributors

Umesh Kumar
Umesh Kumar
GURU GHASIDAS VISHWAVIDYALAYA BILASPUR(C.G) Session : 2018-2019 A ASSIGNMENT REPORT ON “Relational Database ManageMent systeM” (ORACLE) SUBMITTED BY SUBMITTED TO UMESH KUMAR MRS. SUSHMA JAISWAL MCA 3ND SEM. DEPT. CSTI ROLL NO. - 40 GGV BILASPUR (CG) By Umesh Kumar (Assignment on RDBMS)Page | 1
I -N - D - E - X S./ N o 1 Page No. Title 2 Given the following table as 3 C_MASTER, P_MASETER AND S_MASETER Write SQL statement for the following 5 3 Write the given question to answer 9 4 Pattern Matching 10 5 Aggregate Function 11 6 Numeric Function 13 7 String Function 15 8 Explain join function with types and 18 example? Teacher’s sign./remarks By Umesh Kumar (Assignment on RDBMS)Page | 2
Q1. Given the following tables name as:• C_MASTER Column name Datatype Size Client_no varchar2 6 Name varchar2 20 Addrs1 varchar2 30 Addrs2 varchar2 30 City varchar2 15 Pin_code integer 8 State varchar2 15 Balance_due integer 10,2 Datatype Size • P_MASTER-: Column name Product_no Description Varchar2 Varchar2 6 15 Profit_percent Varchar2 4,2 unit_mesure Varchar2 10 qty_on_hand Varchar2 8 record_lvl Varchar2 8 sale_price Number 8,2 cost_price Integer 8,2 By Umesh Kumar (Assignment on RDBMS)Page | 3
• S_MASTER Column name Datatype Size Sman_no S_name Varchar2 Varchar2 6 15 Addres1 Varchar2 4,2 Addres2 Varchar2 10 City Varchar2 8 Pin_code Number 8 State Number 8,2 Sal_amt Number 8,2 Remarks Number 4,5 By Umesh Kumar (Assignment on RDBMS)Page | 4

Lecture Notes