Skip to main content

Posts

Geomapping States

Recent posts

Data visualization Session 4

<head> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", '1', {packages:['corechart']}); google.setOnLoadCallback(drawChart); function drawChart() { var query = new google.visualization.Query( 'https://docs.google.com/a/yantrajaal.com/spreadsheet/ccc?key=0AqawrNPy9RHodGJBQkRpX0Rrdjc2OXZMZmZmNzk3WGc&usp=drive_web#gid=0'); query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var data = response.getDataTable(); var options = {'title':'How Much PIZZA I Ate Last Night', 'width':400, 'height':600}; var chart = new google.visualization.PieChart(d...

Session 3 Data Visualization

l library(shiny) # Define UI for app that draws a histogram ---- ui runApp("app1")

NORMALIZATION IN RDBMS

WHAT IS NORMALIZATION?? Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables. Normalization is used for mainly two purpose, Eliminating redundant(useless) data. Ensuring data dependencies make sense i.e data is logically stored NORMALIZATION RULE Normalization rule are divided into following normal form. First Normal Form Second Normal Form Third Normal Form BCNF Below is a basic example of normalization upto third normal form which I did as part of my class assignment. Normalization Slides