|
There are several files that contains (in csv format) names given to babies, both male and female and their rankings of a particular country for every year from 1944 to 2013.Now we have have create a database so that we can search popular names by birth year.
|
|
|
|
|
First you'd have to decide which database-server; there are various ones out there, some paid, some free, some simple, some complex.
If the database supports SQL (most do), then you could issue a CREATE DATABASE command.
If it will be a local application, using it only for lookups or leaning much on reporting, then you may want to look into MS Access. If there's going to be updates and reporting is not an issue, I'd recommend SQLite. If it is not a local application, I'd recommend Sql Server Express.
Those can all be used for free; interacting is done as documented.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
This Zip file contains (in csv format) (Link1 or Link2 or Link3) names given to babies, both male and female and their rankings of a particular country for every year from 1944 to 2013. Create an interface which can display the following queries:
Popular Names by Birth Year: User can enter a year and choice like Top 10, Top 20..Top 1000 etc and the relevant names will be displayed. Choices should be there for only males, only females and both. Name rankings should also include Number of Births
Popularity of a name that has changed over the years: Given a name and a year it should show (preferably in a graphical format) how popularity has changed starting from that particular year till 2013. For example if a user inputs: Brendon and a year 2000 it should show the popularity of the name starting from 2000 to 2013. Again choice of Male and Female should be there because some names can be both male and female.(actually this is the project that i have been given and i am using oracle 11g i guess if that's fine for this project)
|
|
|
|
|
Oracle is a good choice; now you'd first need a way to get that data in Oracle. You could type in a lot of insert-statements, but there's probably a tool out there that can upload the CSV to an existing database.
Next, someone will have to create a UI (I'd recommend .NET) and create a way for the user to set named options. They can all be translated to a change in the <a href="https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_10002.htm">SELECT</a>[<a href="https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_10002.htm" target="_blank" title="New Window">^</a>] statement that has to be generated.
The select-query is a nice piece of homework; the example actually looks as if each option is there to introduce another part of the select-command. I'd recommend focussing on that before you try to 'add' the popularity-indication.
You'd need to filter on both gender and year in the WHERE statement, limit your results, and dynamically build a query from code.
When is the deadline?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
deadline is 1st november,and everything you said after 2nd paragraph was over my head.ps-I am new to database.
|
|
|
|
|
|
i am going to use php for the database connectivity.
|
|
|
|
|
Good, that makes the UI nice and simple, and not much mucking around with forms. Just a few input-fields, a submit button, and a result. Another benefit is that one could demo it on a smartphone.
..but working on that makes more sense once you have the data in the database. Did you create a database on your database-server yet?
If yes, then you'd need to create the table to hold the data. If you post the top two lines from your example CSV, someone might help with the create table or the select-command 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
will i have to load all the files in a single table or mutiple table?i haven't created a database yet.
|
|
|
|
|
That will depend on the layout of your CSV files. If there's no difference in layout, then it might be done using a single table. I can imagine calculating the popularity as an occurence of the name between a set of dates, compared to 'any' other name on the same set of dates.
..that is, of the same gender, of course. A female-baby name does not compete with any of the male-baby names.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
|
I cannot download the zip, just list its contents. Means I also cannot view the content of these files. Still, by the naming-pattern of the file, I'd guess that all files have the same layout and that a single table would do.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
yeah the layout is same,but i will have to add two columns gender and year to specify the gender and year right?
|
|
|
|
|
If they are not in the original data as columns, then yes, please do; it will make creating a selection-query a lot easier - you'll need them for calculating popularity 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Thanks for your help.I will try and implement it and if i have any doubts i'l get back to you.
|
|
|
|
|
You're welcome
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
i have problem with this code can you plzz check for errors.I was working on live search.
<html>
<head>
<title>Ajax Search Box using PHP and MySQL</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="typeahead.min.js"></script>
<script >
$(document).ready(function(){
$('input.typeahead').typeahead({
name: 'typeahead',
remote: 'search.php?key=%QUERY',
limit : 10
});
});
</script>
.bs-example{
font-family: sans-serif;
position: relative;
margin: 50px;
}
.typeahead, .tt-query, .tt-hint {
border: 2px solid #CCCCCC;
border-radius: 8px;
font-size: 24px;
height: 30px;
line-height: 30px;
outline: medium none;
padding: 8px 12px;
width: 396px;
}
.typeahead {
background-color: #FFFFFF;
}
.typeahead:focus {
border: 2px solid #0097CF;
}
.tt-query {
box-shadow: 0 1px 1px rgba(0, 0, 0, 0.075) inset;
}
.tt-hint {
color: #999999;
}
.tt-dropdown-menu {
background-color: #FFFFFF;
border: 1px solid rgba(0, 0, 0, 0.2);
border-radius: 8px;
box-shadow: 0 5px 10px rgba(0, 0, 0, 0.2);
margin-top: 12px;
padding: 8px 0;
width: 422px;
}
.tt-suggestion {
font-size: 24px;
line-height: 24px;
padding: 3px 20px;
}
.tt-suggestion.tt-is-under-cursor {
background-color: #0097CF;
color: #FFFFFF;
}
.tt-suggestion p {
margin: 0;
}
</head>
<body>
Ajax Search Box using Node and MySQL Codeforgeek Tutorial
<button type="button" class="btn btn-primary btn-lg">Visit Tutorial</button>
<input type="text" name="typeahead" class="typeahead tt-query" autocomplete="off" spellcheck="false" placeholder="Type your Query">
</body>
</html>
|
|
|
|
|
I'm not that home in ASP, not a language I work with very often; you might have more success in the ASP.NET forum.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I have a database set up in Amazon RDS and I can reach that from my web application using the endpoint address without a problem. However, I have just had to switch web host and the new one only allows outbound requests through a static IP address.
I have, temporarily, inferred the IP address by pinging the endpoint address and that works. However, the IP address can change without warning which is why Amazon uses an endpoint address.
The new web host has told me that Amazon RDS have a range of IP addresses and if I can get them, they will set that up for me. However, from what I've read, that does not appear to be the case.
So, am I incorrect and, if so, how do I get the range of addresses or a single, static IP address?
Or is there another way of overcoming this?
I would ask Amazon but at the account level I am at, do not have access to technical support.
Thank you.
|
|
|
|
|
1. Maybe you are on a different VPC?
2. When created the DB you had to provide a security group. If you followed the basic Amazon instruction, you linked it to the VM you had...You may have to extend/change that group...
3. Subnet of the new VM?
4. The availability zone of the DB and the VM may be different...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Thanks - I'll check that out.
|
|
|
|
|
I have got this assignment question on database. Not getting any idea of how to solve this. Can anyone please help me ?
========================================================
“Mr. A” and “Mr. B” data warehousing experts working for “XYZ” company, currently they are developing ETL-Validator framework for big-data technology i.e. Validating data between RDBMS (Mysql/ Oracle / DB2) and Hadoop ( HDFS/ Hive).
Source database (RDBMS) constains millions of records and all the records from source are already migrated to target database (Hadoop - Hive).
They need your help in implementing following scenario's
A. Column Level comparision between source and Target Database (i.e. Comparing each column of source Database with each column of Target Database ) .
Now your task is to :
1. Assume suitable database on source side and design table structure(student / retail banking /telecommunication / insurance , any other) for the same having atleast ten columns.
2. Assuming that buffer size = 500, propose efficient strategy to reduce the number of comparision between source and target columns records.
3. Write SQL query for the solution proposed in step#2.
4. Draw query tree for the query of step#3.
5. Write psudo code or program ( Java / C# ) for proposed solution in step#2 and step #3.
B. As foreign key constraint in not implemented in Target Database (Hadoop – Hive ) , implement foreign key validator for target database.
1. Assuming that table used in #A.1 is already present in target DB, now construct one more table on target side which references to primary key of table used in #A.1
2. Assuming that buffer size=500, propose efficient strategy with min. Comparision to validate foreign key constraint.
==============================================================
|
|
|
|
|
Nobody here is going to do your homework for you. It is set to test what you know, not what a bunch of random strangers on the Internet know.
If you genuinely don't know where to start, then talk to your teacher.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi All,
I have two different databases on two different servers I compared the source database with destination database, there are few things like a Foreign key doesn't exist in the target database, a couple of columns are missing. Now after finding it, I want to update the schema from Source database to Destination database without losing the data on the target database.
When I ran it, it is giving me error and saying Target database may loose data, can anybody please help me or point me, how can I achieve this?
Any suggestion, link or code snippet can be very helpful. Thanks in advance.
Thanks,
Abdul Aleem
"There is already enough hatred in the world lets spread love, compassion and affection."
|
|
|
|
|
If you are changing column formats or shortening the length of a field you will often get this message. You need to asses whether the changes are actually going to impact your database eg shortening a varchar from 1000 to 500 is not relevant if the longest string is only 100 in length.
Whereas changing a data format from decimal to int may make a critical difference!
Never underestimate the power of human stupidity
RAH
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
