×
REMEMBER THAT THE REASON YOU ARE DOING THIS IS TO MAKE YOUR LIFE BETTER
--Your friends at LectureNotes
Close

Lab Manuals for Database Management System - DBMS By Umesh Kumar

  • Database Management System - DBMS
  • Practical
  • Guru Ghasidas Viswavidhyalaya - GGV
  • Computer Science Engineering
  • 4 Experiments
  • 616 Views
  • 11 Offline Downloads
  • Uploaded 6 months ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

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

Text from page-2

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

Text from page-3

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

Text from page-4

• 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