All Notes on BCA

Graphics Programming Dev C++

Even though some peoples somehow managed to port it outside the turbo. Some people hacked their own version of graphics.h. One such person is Micheal main, he ported some of borland graphics functions and library. Micheal main modified BGI library for windows application to be used under MinGW. This BGI library is renamed as WinBGIm. Now you can use all the borland specific functions under Dev-C++.

Using the WinBGIm Graphics Library with Dev-C++

Installation Notes:

Install Dev-C++. I installed from the Version 4.9.9.2 Setup File.
Download graphics.h to the include/ subdirectory of the Dev-C++ directories.
Download libbgi.a to the lib/ In order to use the WinBGIm subdirectory of the Dev-C++ directories.

#include <graphics.h>

int main( )
{
    initwindow(400, 300, "First Sample");
    outtextxy(200,300,"My first Graphics Program in Dev C++...");
    while (!kbhit( ))
    {
        delay(200);
    }
    return 0;
}

4. You can now compile and run programs that use the WinBGIm graphics library, such as this one that opens a small window, draws a circle and waits for the user to press a key:

Some Basic Programs Using Graphics

1. Draw a filled rectangle.
2. Draw a rectangle unfilled.
3. Draw concentric circles.

Some Programs Using Graphics

1. Car Moving
2. Kite Moving
3. Pie Chart Drawing

Some Programs Using Graphics Algorithm

1. Bresenham Line Draw Algorithm With Program.
2. Mid Point Circle's Algorithm With Program.
3. Mid Point Line Draw Algorithm With Program
4. Boundary Fill's Algorithm With Program.
5. Flood Fill Algorithm With Program.
6. Translation Perform on 2D Transformations With Program.

7. Scaling Perform on 2D Transformations With Program.
8. Refletion Perform on 2D Transformations With Program.
9. Shear Perform on 2D Transformations With Program.
10. Rotation Perform on 2D Transformations With Program.

11. BRESENHAM'S CIRCLE GENERATION ALGORITHM
12. Ellipse Generating Algorithm

Saturday 13 February 2016

Posted by Pratik Badala

1 Comment

SQL ORACLE QUERIES

►

Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user's request. This chapter provides background information on SQL as used by most database systems.

Oracle SQL Developer provides a SQL Worksheet that you can use to query data, by writing simple or complex SQL statements. In this How-To, we look at the most basic of these, select all the data in a table, and restricting this query by reducing the columns or rows you retrieve.

TASK - 1:

1. Create the following table customer
2. Create the following table product
3. Create the following table cust_prod

TASK - 2:

1. Find out the names of all customers

2. Retrieve the list of names and cities ofall customers

3. List the various products available in Product table.

4. List all the customers who are located in‘Chennai’

5. Display the details of Customer number 1001

6. Find the details of the products withdescription “XXX” and “YYY”

7. Find all the products whose unit price is greater than 2000.

8. Find the list of customers who stay in ‘Chennai’ or ‘Bangalore’ or ‘Hyderabad’.

9. Find the product whose unit price isgreater than 1000 and less than or equal to 5000.

10. Increase the unit price of productnumber ‘0001’ by Rs.100.

11. Delete the customer number 005 fromthe customer table.

13. Find out the customers who stay in ‘Chennai‘andwhose name starts with ‘S’

14. Find out the details of customers whosename contains ‘a’ as the second letter.

15. List the customer name in the sorted order.

16. Count the total number of products
17. Calculate the average price of the products
18. List the product which has minimum price
19. List the product that has maximum price
20. Count the number of products having the unit price greater than 2000.

TASK - 3:

1. Create Table Salesman
2. Create Table order
3. Create Table sales_order_details

TASK-4:

1. How many days are taken to deliver the product from ordered date?
2. Display one month later than the order date.
3. Print the month of delivery date of all the products.

4.   Display the customer name in upper case.
5.   Print the product description with right padded symbols.
6.   Print the first three characters of customer names.
7.   Print the length of longest customer name.
8.   Print the delivery date in the format 22nd January 2016.

9. Replace the ‘e’ character present in the customer name with ‘a’.

10. Display the next occurrence of ‘Sunday’ to the ordered date.

11. Display the first character of the customer name to capital letter.

12. Print the string from the second position to sixth position of the customer name.

13. Display the current date.

14. Find the total sales of all the products.

15. Count the number of distinct product sold.

TASK-5

1. Display the number of products in each order
2. Display the order number with number ofproducts more than 2

3. List the Salesman number who had sold maximum products
4. List the minimum, maximum, average and total price of product purchased by each customer (use cust_prod table).
5. List the total price of each customer whose product purchased is more than 5.
6. Display the salesman number who have anorder and whose name starts with ‘A’

7. Display the product number which are notpurchased by any customer

8. Print the description and total quantity sold for each product

9. Find the total value of each productsold.
10. Display the product number and number ofproducts ordered for each product.

TASK-6

1. Find out the product which has been sold to particular customer.
2. Find out the product and their quantities that have to be delivered.
3. Find out the product number and description of ordered products
4. Find out the names of clients who have purchased “CD DRIVE”
5. List the product number and sales order number of customers having quantity ordered less than 5 from the order details table for the product “1.44 floppy”.
6. Find the products and their quantities for the orders placed by particular sales man.
7. Find the products and their quantities for the orders placed by client number “C00001” and “C00002”.

8. Find the order number, client number and salesman number where a client has been received by more than one salesman

9. Display the product names for the order number 019001.

10. Display the customer name with their purchased product names.

TASK-7

1. Find the product_no and description of non-moving products.

2. Find the customer name, address, city and pincode for the client who has placed order number “XXX”.

3. Find the clients who have placed order before the month of May 2016.
4. Find out if product “xxx” is ordered by only client and print the client number, name to whom it was sold.

5. Find the names of client who have placed orders worth Rs. 10000 or more.

6. Select the orders placed by “pratik”.

7. Select all the clients and the salesman in the city of “rajsamand”.

8. Select salesman name in “Bombay” who has atleast one client located at “rajsamand”.

9. Select the product number, description, qty_on_hand, cost_price of non-moving items in the product_master table.

10. Display the details of salesman who does not have any sales order.

Friday 22 January 2016

Posted by Pratik Badala

0 Comments

CPU Scheduling Algorithms

►




In a simple system running a single process, the time spent waiting for I/O is wasted, and those CPU cycles are lost forever. A scheduling system allows one process to use the CPU while another is waiting for I/O, thereby making full use of otherwise lost CPU cycles. The following subsections will explain several common scheduling strategies, looking at only a single CPU burst each for a small number of processes. Obviously real systems have to deal with a lot more simultaneous processes executing their CPU-I/O burst cycles.
1. First-Come First-Serve Scheduling (FCFS)

2. Shortest Job First ( Non Primitive)

3. Priority Scheduling algorithm

4. Round Robin Scheduling algorithm

5. FIFO Page Replacement algorithm

6. Optimal Page Replacement Algorithm

7. Least Recently Use(LRU) Page Replacement Algorithm

8. Banker's Algorithm

Thursday 5 November 2015

Posted by Pratik Badala

0 Comments

C plus plus Programming

►

In the early 1980’s, also at Bell Laboratories, another programming language was created which was based upon the C language. This new language was developed by Bjarne Stroustrup and was called C++. Stroustrup states that the purpose of C++ is to make writing good programs easier and more pleasant for the individual programmer. When he designed C++, he added OOP (Object Oriented Programming) features to C without significantly changing the C component. Thus C++ is a “relative” (called a superset) of C, meaning that any valid C program is also a valid C++ program.

BASIC C++ PROGRAMS :

1. Print "Hello" in C++
2. If - else Condition
3. Factorial Number Using Recursive Function
4. Switch Case Using C++
5. Create Class and Object
6. Making A Constructor
7. Function Overloading
8. Operator Overloading
9. Simgle Inheritance
10. Polymorphism in C++
11. Exception Handling
12. Template Using in C++

Friday 25 September 2015

Posted by Pratik Badala

1 Comment

JAVA Programming

►

Java is a simple and yet powerful object oriented programming language and it is in many respects similar to C++. Java originated at Sun Microsystems, Inc. in 1991. It was conceived by James Gosling, Patrick Naughton, Chris Warth, Ed Frank, and Mike Sheridan at Sun Microsystems, Inc. It was developed to provide a platform-independent programming language. This site gives you an Introduction to Java Programming accompanied with many java examples. Its a complete course in java programming for beginners to advanced java.

BASIC JAVA PROGRAMS :

1. Hello Print in java