how to create a database if data is given in different files(in csv format) and we have to search data from it?

Question

1.00/5 (1 vote)

See more:

There are different 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.
the data is in different files for males and females.then we we have to search the popularity of a name by year.

Posted 23-Oct-15 6:28am

Member 11270902

Add a Solution

Comments

CHill60 23-Oct-15 12:29pm

What have you tried? Where are you stuck?

Member 11270902 23-Oct-15 12:39pm

not even tried,i am new to it so don't even have a idea.actually i have got a mini project.

CHill60 23-Oct-15 12:43pm

Well this is the Quick Answers forum - we usually help people who are stuck with some code.
Do you know how to create a database at all?
Do you know how to load the CSV files into a table?

Member 11270902 23-Oct-15 12:45pm

yeah i know how to load csv files into table.

CHill60 23-Oct-15 12:48pm

Then just load them into a table and write the queries and stored procedures. I would suggest you are going to need a column on the table for each column in the CSV and either another column that indicates which gender(s) can apply or 3 columns for Male/Female/Both - you'll need to set that when (or after) you load each CSV file into the table.

Member 11270902 23-Oct-15 12:50pm

will i have to load all the files into a single table?

ZurdoDev 23-Oct-15 13:56pm

That's your choice. Database design is what you choose, what makes most sense to you.

Member 11270902 23-Oct-15 14:01pm

i have posted the project details below in the comment.what do you think woulb be best in that case?

ZurdoDev 23-Oct-15 14:02pm

Are you planning on a single table or multiple tables? If multiple tables, what would they be?

Member 11270902 23-Oct-15 14:03pm

i need a suggestion on that.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.(this is the full project).i think single table will be helpful while searching?

ZurdoDev 23-Oct-15 14:14pm

Yes, I already read that. We are trying to help you think it through since this is your homework you'll learn a lot more if you work through it with our help; rather than us just telling you how to do it.

Yes, I agree that a single table is easier. You can also ask yourself, if you were to use multiple tables, what would they look like?

Member 11270902 23-Oct-15 14:20pm

actually i don't have any idea about databases,all that i have learnt is from the internet.

Member 11270902 23-Oct-15 14:45pm

i will have to add two more columns for gender and the year right?

ZurdoDev 23-Oct-15 14:52pm

Correct. It will likely mimic your csv files. Store the name, year, and male/female.

Member 11270902 23-Oct-15 15:05pm

https://drive.google.com/file/d/0Bz4F2FWI2Rx9S0tWUlN6dy1pTUU/view

this is the link to the data provided to me to be entered into the database.please have a look at it and give me suggestions.

Member 11270902 23-Oct-15 12:43pm

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.(this is the full project)

CHill60 23-Oct-15 12:45pm

Looks like homework.
At least you've only asked about the database part.
You've tagged SQL - which version?

Member 11270902 23-Oct-15 12:52pm

i am using oracle 11g.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2015-10-23T08:35:00

Solution 1

As discussed in the comments, from your description, I think a single table to store the data is the best approach.

Posted 23-Oct-15 8:35am

ZurdoDev