Posts

SQL simple Queries to create Database & Tables and Insert Values

-
   SQL Queries to create Database & Tables # Creating ABC_College database and tables CREATE DATABASE ABC_College; USE ABC_College; # Creating course table CREATE TABLE COURSE(     coursecode varchar(5) NOT NULL PRIMARY KEY,     title varchar(20) NOT NULL,     school varchar(20) NOT NULL ); # Creating student table CREATE TABLE student (     regno varchar(6) NOT NULL PRIMARY KEY,     name varchar(20) NOT NULL,     DOB date NOT NULL,     telno varchar(20) NOT NULL,     Coursecode varchar(10) NOT NULL,     FOREIGN KEY(Coursecode) REFERENCES COURSE(Coursecode) ); # Creating unit table CREATE TABLE UNIT(     unitcode varchar(5) NOT NULL PRIMARY KEY,     title varchar (20) NOT NULL,     year int NOT NULL ); # Creating results table CREATE TABLE RESULTS(     regno varchar(6) NOT NULL,     unitcode varchar(5) NOT NULL,     exammark ...
Post a Comment
Read more

OOP Concepts Practice Project in Java

-
 A simple Game using Java OOP Concepts 1. "Tools" Abstract class and Parent class to class Player abstract class Tools {     abstract void punch ( int point );     abstract void kick ( int point );     abstract void shoot ( int point );     abstract void getPunch ( int healths );     abstract void getKick ( int healths );     abstract void getShoot ( int healths ); } 2. "Player" Parent class to classes American, African, Asian & child class to class Tools public class Player extends Tools {     private String name ;     private int points ;     private int health ;     public Player ( String name , int points , int health ){         this . name = name ;         this . points = points ;         this . health = health ;     }     int getPoints (){     ...
Post a Comment
Read more

How to Handle JSON file in Python

-
Image
Normally in Python, We use several data types to store data such as Lists, Tuples, Sets, and Dictionaries. But If we want to add something to the data through user input, We can add and view only while running the program. If we stop the program and run again we loose what we add earlier. To give a solution to manage the data permanently, there are various ways. Today we are going to see how to handle(store, add, remove, read) a JSON file in Python 1. Read a JSON File Let's create a file called data.json as follows, data.json JSON is an object which includes key-value pairs. In my example, biodata  is a key where a list is a value for that key. The list contains two dictionaries(Objects). Let's create a file called  data.py  as follows, data.py I have imported json first. Then only I can use json object I have open my json file(data.json) with "r"(read) mode and assigned to a variable called f If I open on read mode I can only read the file, can not edit the file Loa...
Post a Comment
Read more

Introduction to React Native Navigation

-
Image
 Create a project "exop init ProjectName" Install the following dependencies in order to use Stack, Tab, Drawer Navigations and Icons npm install @react-navigation/native npm install @react-navigation/stack expo install react-native-gesture-handler npm install @react-navigation/bottom-tabs npm install @react-navigation/drawer expo install react-native-gesture-handler react-native-reanimated expo install react-native-reanimated npm install react-native-elements --save --force npm install react-native-vector-icons --save Open Babel.config.js and change as follows module . exports = function ( api ) {   api . cache ( true );   return {     presets : [ 'babel-preset-expo' ],     plugins : [ 'react-native-reanimated/plugin' ],   }; }; Now run  expo start --clear Now create JS Files as follows Header.js import { StatusBar } from 'expo-status-bar' ; import { StyleSheet , Text , View } from 'react-native' ; import Photo from './Photo...
1 comment
Read more

Mobile Application Unit 1 Short Notes

-
Image
 Introduction Mobile devices are major gateways to the internet as compared to desktop browsers. Mobile device is replacing all traditional channels to access the information. Most of the enterprises are now adopting to "Mobile-First" strategy to various reasons.   Key Drivers for Mobile Applications Innovation Proliferation in Smart Phones Higher 3G and 4G Bandwidths Higher Capacity Storage Higher Speed Chips Consumer Behavior More Usability Access Information easily on the move Personalized Content Delivery Contextualized, Relevant, and Personalized Contents Offers and Advertisements Mobile Ecosystem Explosive Growth in Mobile Application Stores Social Network Popularity of Web 2.0 Social Media Technologies Attributes of Mobile Application Ubiquity Always Available and Connected Access information Anytime Anywhere User Friendliness Responsive and interactive User Interface Location Awareness Location Sensitive Information Using GPS Minimalistic Minimal Contents and...
Post a Comment
Read more

Simple Calculator Using Vue JS

-
Image
Simple Calculator Using Vue JS HTML Codes < h1 > Simple Calculator Using Vue </ h1 >     < div id = "app" >         < form action = "" >             < table >                 < tr >                     < td > Enter Number 1: </ td >                     < td >< input type = "text" v-model.number = "num1" ></ td >                 </ tr >                 < tr >                     < td > Enter Number 2: </ td >                     < td >< input type = "text" v-model.number = "num2" ></ td >     ...
Post a Comment
Read more