How to make animation video in mobile

 To make an animation video on your mobile device, you can follow these general steps:

1. Choose an Animation App: Search for animation apps on your mobile platform (iOS or Android) and find one that suits your needs and skill level. Some popular animation apps include FlipaClip, Animation Desk, and Toontastic.

2. Plan Your Animation: Before diving into creating the animation, plan your story or concept. Decide on the characters, scenes, and the overall flow of the animation.

3. Create Frames: Start by creating individual frames for your animation. Depending on the app you're using, you can draw directly on your mobile screen or import images.

4. Animate Frames: After you've created the initial frames, use the app's animation tools to bring them to life. You'll typically have options to adjust the timing, playback speed, and transitions between frames.

5. Add Audio: If your animation requires sound effects or a soundtrack, you can add audio to enhance the viewer's experience. Many animation apps allow you to import and sync audio files.

6. Review and Edit: Once your animation is complete, review it to check for any errors or areas that need improvement. Make necessary adjustments to ensure a smooth and engaging animation.

7. Export and Share: Finally, export your animation video in a suitable format and resolution. You can then share it on social media or other platforms to showcase your work.

Remember, creating animation takes practice, so don't be discouraged if your first attempts aren't perfect. Keep refining your skills and experimenting with different techniques to improve over time.

Read More

WINTER – 2018 EXAMINATION

WINTER – 2018 EXAMINATION MODEL ANSWER

MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION

DOWNLOAD PDF
Information Technology Department

POD - Principles of Database

DCO - Data Communication

DSU - Data Structure using C

DTM - Digital Techniques & Microprocessor

OOP - Object Oriented Programming with C++

Read More

Data Manipulation Language Command (DML)

Structured Query Language(SQL) as we all know is the database language by the use of which we can perform certain operations on the existing database and also we can use this language to create a database. SQL uses certain commands like Create, Drop, Insert etc. to carry out the required tasks.

These SQL commands are mainly categorized into four categories as discussed below:

DML (Data Manipulation Language):

Data Manipulation Language (DML) statements or commands are used for managing data within tables.

Some commands of DML are:
INSERT – insert data into a table.
UPDATE – updates existing data within a table.
DELETE – deletes all records from a table, the space for the records remain.
SELECT – retrieve data from the a database.

[1]INSERT:

The insert statement is used to add new row to a table.In insert commands, they have 5 syntax are as follows:

SYNTAX 1:  insert  into table_name
                     values(value1,value2,.....,valuen);

SYNTAX 2:  insert  into table_name(column_Name1,column_Name2,column_Name3)  
                     values(value1,value2,value3);

SYNTAX 3:  insert  into table_name(column_Name1,column_Name2,....)  
                     values(value1,value2,....);

SYNTAX 4:  insert  into table_name
                     values(&column_Name1,&column_Name2,........,&column_Namen);
   
SYNTAX 5:  insert  into table_name
                     select  * from  exiting  table_name;

EXAMPLE:  insert  into emp
                     values(1,'ram');

NOTE: The inserted values must match the table structure exactly in the number of attributes and the data type of each attribute. Character type values are always enclosed in single quotes; number values are never in quotes; date values are often (but not always) in the format ‘yyyy-mm-dd’ (for example, ‘2006-11- 30’).The syntax 4 is not run on  'Oracle Database 10g Express Edition'. This syntax run on  'Run SQL Command Line'are the option of  'Oracle Database 10g Express Edition'.

[2]UPDATE :

The update statement is used to change values that are already in a table.

SYNTAX:  update table_name
                  set  column_Name = new_value
                  where condition;

EXAMPLE:  update emp
                     set  empname = 'rakesh'
                     where empno=11;

NOTE: The update expression can be a constant, any computed value, or even the result of a SELECT statement that returns a single row and a single column.

[3]DELETE :

The delete statement deletes row(s) from a table.

SYNTAX:  delete  from  table_name
                  where condition;

EXAMPLE:  delete  from emp
                     where empno=11;

NOTE: If the WHERE clause is omitted, then every row of the table is deleted that matches with the specified condition.

[4] SELECT :

The SELECT statement is used to form queries for extracting information out of the database.

SYNTAX 1:  select  * from  table_name
                    where condition;

SYNTAX 2:  select  column_Name1,column_Name2  from  table_name
                    where condition;

EXAMPLE:  select  * from emp                   or     select  empname from emp
                      where empname='rajesh';                   where salary< 60000;


Apart from these statements, some statements are also used to control the transaction made by DML statements. The commands used for this purpose are called Transaction Control (TCL) statements. It allows statements to be grouped together into logical transactions.

We are learn TCL and DCL COMMAND in the next tutorial.

If you liked the tutorial then don’t forget to comment and share!

Read More

Data Definition Language command (DDL)

Structured Query Language(SQL) as we all know is the database language by the use of which we can perform certain operations on the existing database and also we can use this language to create a database. SQL uses certain commands like Create, Drop, Insert etc. to carry out the required tasks.

These SQL commands are mainly categorized into four categories as discussed below:

DDL(Data Definition Language) : DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in database.
Examples of DDL commands:

[1] CREATE – is used to create the database or its objects (like table, index, function,              views, store procedure and  triggers).

SYNTAX :     create  table  table_name                                                                                                                             (column_Name1   data_type(size),                                      
                         column_Name2   data_type(size),        
                          .                                                                         
                          .                                                          
                         column_Namen   data_type(size));   

EXAMPLE :    create  table  empolyee
                          (empno  number(5) ,
                           ename  char(20) ,
                           job  varchar2(20),
                           salary  number(10,2),
                           commission  number(10,2),
                           deptno  number(10));                                   



[2] ALTER- is used to alter the structure of the database i.e. modify the structure or schema of the database ( table).

In ALTER command, they have 4 option are as following:

                                                    (1) ADD - add the new column in a table.

     
 SYNTAX :  alter  table  table_name                             
                       add(column_Name1   data_type(size),                                        
                               .
                               .
                               column_Namen   data_type(size));

EXAMPLE :  alter  table  employee
                       add(mobileno number(10));


                                    (2) MODIFY - change the data_type(size) of column in a table.                         

SYNTAX :    alter  table  table_name                             
                       modify(column_Name   data_type(size)); 

EXAMPLE : alter  table  employee
                       modify(name varchar2(20));
                                    

                                                     (3) DROP - drop the column in a table.
     
SYNTAX :   alter  table  table_name                          
                      drop   column  column_name;   

 EXAMPLE :  alter  table  employee
                        drop(mobileno number(10));
                                                                                                           
                                             (4) RENAME- change the name column in a table.

 SYNTAX : alter  table  table_name                              
                     rename  column  old  column_name to  new  column_name; 

 EXAMPLE :  alter  table  employee
                         rename column ename to  empname;



[3] DROP – is used to delete objects from the database and  table structure i.e.we can not have table,this time use drop command.

SYNTAX :   drop  table  table_name  

EXAMPLE :  drop  table  employee

[4] DESC - This commands is used for  display the structure of table.

SYNTAX :   desc  table_name;

EXAMPLE :    desc  employee;

[5]TRUNCATE–is used to remove all records from a table, including all spaces allocated for the records  are removed. It keep the data structure of table and rollback option is not work after truncate  command  use.

SYNTAX :  truncate  table  table_name     

EXAMPLE :    truncate  table  employee


[6]RENAME-is used  to change the name of  table.

SYNTAX :  rename  old  table_name  to new  table_name;

EXAMPLE :  rename  employee to  emp;


[7]CREATE  USER– is used to create user in the database or identified by password.

SYNTAX : create user user-name  identified by password         
                                                                                                                          
EXAMPLE :  create user raj  identified by  raj@123

If you liked the tutorial then don’t forget to comment and share!

Read More

Information And Use Of SQL(Structured Query Language)

WHAT IS RELATIONAL DATABASE MANAGEMENT SYSTEM ?

image resourse

A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Most commercial RDBMS Structured Query Language (SQL) to access the database, although SQL was invented after the initial development of the relational model and is not necessary for its use.

In general, databases store sets of data that can be queried for use in other applications. A database management system supports the development, administration and use of database platforms.

An RDBMS is a type of DBMS with a row-based table structure that connects related data elements and includes functions that maintain the security, accuracy, integrity and consistency of the data.

The most common means of data access for the RDBMS is via SQL. Its main language components comprise data manipulation language (DML) and data definition language (DDL) statements. Extensions are available for development efforts that pair SQL use with common programming languages, such as COBOL (Common Business-Oriented Language), Java and .NET.

WHAT IS SQL ?

Imge Resourse 

SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them. Initially created in the 1970s, SQL is regularly used not only by database administrators, but also by developers writing data integration scripts and data analysts looking to set up and run analytical queries.

The uses of SQL include modifying database table and index structures; adding, updating and deleting rows of data; and retrieving subsets of information from within a database for transaction processing and analytics applications. Queries and other SQL operations take the form of commands written as statements -- commonly used SQL statements include select, add, insert, update, delete, create, alter and truncate.

WHAT IS ORACLE ?

       image resourses

Oracle is one of the largest vendors in the enterprise IT market and the shorthand name of its flagship product, a relational database management system (RDBMS) that's formally called Oracle Database. The database software sits at the center of many corporate IT environments, supporting a mix of transaction processing, business intelligence and analytics applications.

Like other RDBMS software, Oracle Database is built on top of SQL, a standardized programming language that database administrators, data analysts and other IT professionals use to manage databases and query the data stored in them. The Oracle software is tied to PL/SQL, an implementation developed by Oracle that adds a set of proprietary programming extensions to standard SQL -- a common practice among RDBMS vendors. 

Read More

Android - Hello World Example

Let us start actual programming with Android Framework. Before you start writing your first example using Android SDK, you have to make sure that you have set-up your Android development environment properly as explained in Android - Environment Set-up tutorial. I also assume that you have a little bit working knowledge with Android studio.

So let us proceed to write a simple Android Application which will print "Hello World!".

Create Android Application
The first step is to create a simple Android Application using Android studio. When you click on Android studio icon, it will show screen as shown below

You can start your application development by calling start a new android studio project. in a new installation frame should ask Application name, package information and location of the project.−

After entered application name, it going to be called select the form factors your application runs     on, here need to specify Minimum SDK, in our tutorial, I have declared as API15:Android   4.0.3(IceCreamSandwich) −

The next level of installation should contain selecting the activity to mobile, it specifies the default layout for Applications.

At the final stage it going to be open development tool to write the application code.

Anatomy of Android Application

Before you run your app, you should be aware of a few directories and files in the Android project −

Sr.No.	Folder, File & Description
1	Java This contains the .java source files for your project. By default, it includes an MainActivity.java source file having an activity class that runs when your app is launched using the app icon.
2	res/drawable-hdpi This is a directory for drawable objects that are designed for high-density screens.
3	res/layout This is a directory for files that define your app's user interface.
4	res/values This is a directory for other various XML files that contain a collection of resources, such as strings and colours definitions.
5	AndroidManifest.xml This is the manifest file which describes the fundamental characteristics of the app and defines each of its components.
6	Build.gradle This is an auto generated file which contains compileSdkVersion, buildToolsVersion, applicationId, minSdkVersion, targetSdkVersion, versionCode and versionName

Following section will give a brief overview of the important application files.

The Main Activity File

The main activity code is a Java file MainActivity.java. This is the actual application file which ultimately gets converted to a Dalvik executable and runs your application. Following is the default code generated by the application wizard for Hello World! application −

package com.example.helloworld;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;

public class MainActivity extends AppCompatActivity {
   @Override
   protected void onCreate(Bundle savedInstanceState) {
      super.onCreate(savedInstanceState);
      setContentView(R.layout.activity_main);
   }
}

Here, R.layout.activity_main refers to the activity_main.xml file located in the res/layout folder. The onCreate() method is one of many methods that are figured when an activity is loaded.

The Manifest File

Whatever component you develop as a part of your application, you must declare all its components in a manifest.xml which resides at the root of the application project directory. This file works as an interface between Android OS and your application, so if you do not declare your component in this file, then it will not be considered by the OS. For example, a default manifest file will look like as following file −

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.example.tutorialspoint7.myapplication">

   <application
      android:allowBackup="true"
      android:icon="@mipmap/ic_launcher"
      android:label="@string/app_name"
      android:supportsRtl="true"
      android:theme="@style/AppTheme">
      
      <activity android:name=".MainActivity">
         <intent-filter>
            <action android:name="android.intent.action.MAIN" />
            <category android:name="android.intent.category.LAUNCHER" />
         </intent-filter>
      </activity>
   </application>
</manifest>

Here <application>...</application> tags enclosed the components related to the application. Attribute android:icon will point to the application icon available under res/drawable-hdpi. The application uses the image named ic_launcher.png located in the drawable folders

The <activity> tag is used to specify an activity and android:name attribute specifies the fully qualified class name of the Activity subclass and the android:label attributes specifies a string to use as the label for the activity. You can specify multiple activities using <activity> tags.

The action for the intent filter is named android.intent.action.MAIN to indicate that this activity serves as the entry point for the application. The categoryfor the intent-filter is named android.intent.category.LAUNCHER to indicate that the application can be launched from the device's launcher icon.

The @string refers to the strings.xml file explained below. Hence, @string/app_name refers to the app_name string defined in the strings.xml file, which is "HelloWorld". Similar way, other strings get populated in the application.

Following is the list of tags which you will use in your manifest file to specify different Android application components −

• <activity>elements for activities
• <service> elements for services
• <receiver> elements for broadcast receivers
• <provider> elements for content providers
• The Strings File

The strings.xml file is located in the res/values folder and it contains all the text that your application uses. For example, the names of buttons, labels, default text, and similar types of strings go into this file. This file is responsible for their textual content. For example, a default strings file will look like as following file −

<resources>
   <string name="app_name">HelloWorld</string>
   <string name="hello_world">Hello world!</string>
   <string name="menu_settings">Settings</string>
   <string name="title_activity_main">MainActivity</string>
</resources>

The Strings File

The activity_main.xml is a layout file available in res/layout directory, that is referenced by your application when building its interface. You will modify this file very frequently to change the layout of your application. For your "Hello World!" application, this file will have following content related to default layout −

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
   xmlns:tools="http://schemas.android.com/tools"
   android:layout_width="match_parent"
   android:layout_height="match_parent" >
   
   <TextView
      android:layout_width="wrap_content"
      android:layout_height="wrap_content"
      android:layout_centerHorizontal="true"
      android:layout_centerVertical="true"
      android:padding="@dimen/padding_medium"
      android:text="@string/hello_world"
      tools:context=".MainActivity" />
      
</RelativeLayout>

This is an example of simple RelativeLayout which we will study in a separate chapter. The TextView is an Android control used to build the GUI and it have various attributes like android:layout_width, android:layout_height etc which are being used to set its width and height etc.. The @string refers to the strings.xml file located in the res/values folder. Hence, @string/hello_world refers to the hello string defined in the strings.xml file, which is "Hello World!".

Running the Application

Let's try to run our Hello World! application we just created. I assume you had created your AVD while doing environment set-up. To run the app from Android studio, open one of your project's activity files and click Run  icon from the tool bar. Android studio installs the app on your AVD and starts it and if everything is fine with your set-up and application, it will display following Emulator window −

Congratulations!!! you have developed your first Android Application and now just keep following rest of the tutorial step by step to become a great Android Developer. All the very best.

If you liked the tutorial then don’t forget to comment and share!

Read More

How to Make a Music Player App for Android

Hello everyone, in this tutorial we are going to learn how to make a Music Player App for android (using Android studio). Step by step process is given in this article that will help you to make a simple Music Player App in very easy way.

Steps to Make a Music Player App for Android

1. First of all open android studio

2. Create a new project > Start a new Android Studio Project > Now name your project “Music Player App”.

3. Choose a Package Name. A Package Name is a unique URL of your Application. In most cases it is the inverse of your website. For example: mohit.bhailogprogrammer.com

4. If you want you can leave it to the default package name which is “mohit.musicplayer.com”. Now hit next two times.

5. If you have made an Icon then add it otherwise go with the default one. Select Empty Activity > Now name your activity

6. Select the from factors and minimum SDK - API15:Android 4.0.3

7. After completing this go to Package Explorer & under your Package Explorer Select src > Your package Name > activity_main.xml

8. Open the activity_main.xml file and paste the given code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

<?xml version="1.0" encoding="utf-8"?> <RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:background="@drawable/background" tools:context=".MainActivity"> <com.mikhaellopez.circularimageview.CircularImageView android:layout_width="230dp" android:layout_height="230dp" android:layout_alignParentStart="true" android:layout_alignParentTop="true" android:layout_marginStart="73dp" android:layout_marginTop="53dp" android:src="@drawable/album_art" app:civ_border_color="#000000" /> <Button android:id="@+id/btn_play" android:layout_width="90dp" android:layout_height="90dp" android:layout_alignParentBottom="true" android:layout_centerHorizontal="true" android:layout_marginBottom="88dp" android:background="@drawable/play" /> <Button android:id="@+id/btn_pause" android:layout_width="80dp" android:layout_height="80dp" android:layout_alignBaseline="@+id/btn_play" android:layout_alignParentStart="true" android:layout_marginStart="36dp" android:background="@drawable/pause" /> <Button android:id="@+id/btn_stop" android:layout_width="80dp" android:layout_height="80dp" android:layout_alignBaseline="@+id/btn_play" android:layout_alignParentEnd="true" android:layout_marginEnd="36dp" android:background="@drawable/stop" /> </RelativeLayout>

9. After completing this go to Package Explorer & under your Package Explorer Select src > Your package Name > MainActivity.java

10. Open the MainActivity.java file and paste the given code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68

package com.example.mohit.musicplayer; import android.media.MediaPlayer; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.widget.Button; public class MainActivity extends AppCompatActivity implements View.OnClickListener { Button play,pause,stop; MediaPlayer mediaPlayer; int pausecurrentposition; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); play=(Button) findViewById(R.id.btn_play); pause=(Button) findViewById(R.id.btn_pause); stop=(Button) findViewById(R.id.btn_stop); play.setOnClickListener(this); pause.setOnClickListener(this); stop.setOnClickListener(this); } @Override public void onClick(View v) { switch (View.getId()){ case R.id.btn_play if(mediaPlayer==null){ mediaPlayer=MediaPlayer.create(getApplicationContext(),R.raw.music); mediaPlayer.start();} else if(!mediaPlayer.isPlaying()){ mediaPlayer.seekTo(pausecurrentposition); mediaPlayer.start(); } break; case R.id.btn_pause if(mediaPlayer!=null){ mediaPlayer.pause(); pausecurrentposition=mediaPlayer.getCurrentPosition() } break; case R.id.btn_stop if(mediaPlayer!=null) { mediaPlayer.stop(); mediaPlayer = null; } break; } } }

11.Select build Android Application and build apk

Show your apk

If you liked the tutorial then don’t forget to comment and share!

Read More