[GTU] SQL & PL/SQL SET - 4

Definition of SET - 4

Supplier (sid, sname, contactnum)
Parts (pid, pname, color, unit rate)
Catalog (sid, pid, qty)
A)

1. Find the top three Parts been ordered and have the highest sale till date.

B)

1. Create a PL/ SQL block to prepare invoice in following format.
   Display the invoice in the following format. Use parameterized cursor.
   
   Invoice ::: <Supplier’s Name>
   Part Id Part Name Quantity Unit Price Total Price
   ----------------------------------------------------------------------------------------
   ----------------------------------------------------------------------------------------
   Total: _______
   ----------------------------------------------------------------------------------------
   
   

[GTU] SQL & PL/SQL SET - 3

Definition of SET - 3

Account (ac_no, ac_name, act_type)
Transaction (ac_no, trans_date, tran_type, tran_amount, balance)

Note: Act_type may be ‘S’ for saving or ‘C’ for current and tran_type may be ‘D’ for deposit
or ‘W’ for withdrawal
Implement the following:

A)

1. Find out those saving transactions that took place between 10th January 2011 and
   20th January 2011 and have withdrawn an amount greater than Rs. 50,000.
2. Create a Sequence that can be used to enter new account number into the account
   table. Add a new record into Account table using the created sequence.

B)

1. Create a trigger not allowing insertion, deletion or updation on Saturday and before
   8:00 AM & after 6:00 PM on Account table.
2. Create a package for the following :
   Create a function to return the current balance for a given account number.
   
   

[GTU] SQL & PL/SQL SET - 2

Definition of SET - 2

Customer (Cust_Id, Cust_Name, Cust_Addr, Cust_City, EmailID,Contact_No)
Magazine (Mag_Id, Mag_Name, Unit_Rate, Type_of_subsciption[weekly, monthly, etc.])
Subscription (Cust_Id, Mag_Id, start_date, end_date)

A)

1. Create a View that displays Customer name, Magazine name along with its rate
   which was subscribed during 01-Sept-2010 to 01-Feb-2011.
2. Find top three magazines having the highest sale during last one month of time.

B)

1. Create a function to return No. of customers in city Gandhinagar who have subscribed
   the magazine ‘Outlook’ after August 2010. If no such customer exists, throw a user
   defined exception with appropriate message.
2. Create a trigger that is fired after an INSERT statement is executed for the Customer
   table. The trigger writes the new customer’s code, name and the sysdate in a table
   called Customer_Log.(create the table Customer_Log)
   
   
   

[GTU] SQL & PL/SQL SET - 1

Definition of SET - 1

Competition (Comp_code, Comp_name (Dancing, Painting, GK, etc.) )
Participants (Part_no, Part_name, DOB, Address, EmailID, Contact_number )
Scorecard (Part_no, Comp_code, Judge_no , Marks)Implement the following:
A)

1. Find those participants who have registered both for ‘Dancing’ and ‘Painting’ (Note:
   Use set operator).
2. Find the average score, scored in each competition event.

B)

1. Create a PL/ SQL block to prepare report in following format.
   Display the score card in the following format, for the Participant whose
   ID/ Name should be provided by the user.
   
   
   Talent Winner 2011 ::: <Participant’s Name>
   Competition name Judge1 Judge2 Judge3
   --------------------------------------------------------------------------------------------
   1. Painting
   2. Dancing
   --------------------------------------------------------------------------------------------
   Total Marks: _______
   --------------------------------------------------------------------------------------------
   
   
   

[Book] Programming ANSI C++ by Bhusan Trivedi

Programming with ANSI C+ + Book Description

Designed to serve as a textbook for undergraduate engineering, BCA, and MCA students, Programing with ANSI C++ provides an in-depth coverage of elementary as well as advanced topics of the language. The book starts with a philosophical background and an overview of C++ followed by a systematic discussion of concepts such as classes, objects, functions, constructors, destructors, overloading, standard template library, and templates. An in-depth discussion of topics such as exception handling, in heritance, polymorphism, RTTI, file handling, and namespaces has been presented with suitable examples. To reinforce the understanding of concepts, diagrams and program listings have been included wherever appropriate. The theory is well supported with plenty of application-oriented programs, complete with their source codes and test cases, and exercises in each chapter.

Table of Contents

• Preface
• Introduction to C++
• Overview of the C++ Language
• Classes and Objects
• Functions
• Constructors and Destructors
• Operator Overloading and User Defined Conversions
• Templates
• Exception Handling
• Inheritance
• Runtime Polymorphism by Virtual Functions
• Run Time Type Information and Different Casting Operators
• Streams and Formatted IO
• Using Files for IO
• Namespaces
• ANSI String Objects
• Standard Template Library
• Appendix: Case Study
• Index

About the Author :

Bhushan Trivedi has contributed to Programming with ANSI C+ + as an author. Bhusan Trivedi, currently a faculty member at GLS Institute of Computer Technology, Ahmedabad, has about 20 years experience in teaching postgraduate students of computer applications. During the course of his career, the author has taught papers on C++, C, Data Structures, Computer Networks, DBMS, and Artificial Intelligence. Having also held the prestigious position of the Director of Gujarat Vidyapith, he has been involved in formulating rules for entrance to MCA as also revising syllabi for various courses offered in MCA.

Buy This Book at 19% Discount ( Only in Rs.  255 )

  Buy This Book in Free Cash on Delivery

Why Buy from iAmLearningHere ?

Before reading this , i am sure you must have inquired this book on any book stall, you find this book in Rs. 315 in your local book stall. you have to go there to buy book. but by ordering from here you get this book at your door in only Rs. 255 (No shipping or No courier charges). so why should not buy from here?
You have to pay only Rs. 255 only at delivery time, No Advance Payment, No Risk

Order Now