SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 university database
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

breds
Starting Member

13 Posts

Posted - 01/21/2009 :  11:27:25  Show Profile  Send breds a Yahoo! Message  Reply with Quote
am new to sql and i wanted to make a database,with querries for analysis of student trends,faculties ,schools, googling specific data

primary key common in all tables is student ID

tables :bio data e.g DOB,Home,
:facullties[schools]e.g. school of medicine, lecturer reports,grades
:accounting e.g. fees amount,refunds,schorlarships
:extracurricular activities e.g sports,clubs
:health e.g.insuarance type,

any help would be appreciated, THANKS
















visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 01/21/2009 :  11:29:35  Show Profile  Reply with Quote
this seems like a homework question
can you show what you tried till now?
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  02:33:01  Show Profile  Send breds a Yahoo! Message  Reply with Quote
thanks for the fast reply,
its no class project, i got a job for a friend who works at the university. All their records are on hard copy, i told him i would get back to him, and i quoted a price of 125$ for the whole project, is that okay?

I just did the tables in access, the code am blank on how much it will involve.
I got a bunch of books...let me list them for you to tell me which is going to help me fastest
1. Balling - High Performance MySQL (O'Reilly, 2004)
2. Beaulieu - Learning SQL (O'Reilly, 2005)
3. Beaulieu - Mastering Oracle SQL 2e (O'Reilly, 2004)
4. Ben-Gan - Inside Microsoft SQL Server 2005 - T-SQL Programming (Microsoft, 2006)
5. Celko - Data and Databases - Concepts in Practice (Morgan, 1999)
6. Celko - Thinking in Sets - Auxiliary, Temporal and Virtual Tables in SQL (Elsevier, 2008)
7. Celko - Trees and Hierarchies in SQL for Smarties (Elsevier, 2004)
8. Date - An Introduction to Database Systems 8e - INSTRUCTOR
9. Date - An Introduction to Database Systems 8e.djvu
10. Donahoo - SQL - Practical Guide for Developers (Elsevier, 2005)
11. Douglas - PostgreSQL - The Comprehensive Guide 2e (Sams, 2005)
12. DuBois - MySQL Cookbook 2e (O'Reilly, 2006)
13. Feuerstein - MySQL Stored Procedure Programming (O'Reilly, 2006)
14. Feuerstein - Oracle PL-SQL Language Pocket Reference 4e (O'Reilly, 2008)
15. Greenwald - Professional Oracle Programming (Wiley, 2005)
16. Hamilton - Programming SQL Server 2005 (O'Reilly, 2006)
17. Hernandez - Database Design for Mere Mortals 2e (AW, 2003)
18. Kofler - The Definitive Guide to MySQL 5 3e (Apress, 2005)
19. Kruckenberg - Pro MySQL (Apress, 2005)
20. Lans - Introduction to SQL - Mastering The Relational Database Language 4e (AW, 2006)
21. Loney - Oracle Database 10g - The Complete Reference (McGraw, 2004)
22. Matthew - Beginning Databases with PostgreSQL - From Novice to Pro 2e (Apress, 2005)
23. Molina,Ullman - Database Systems - The Complete Book (Prentice, 2002)
24. Molinaro - SQL Cookbook (O'Reilly, 2005)
25. Nielsen - SQL Server 2005 Bible (Wiley, 2007)
26. Oppel - Databases Demystified (McGraw, 2004)
27. Owens - The Definitive Guide to SQLite (Apress, 2006)
28. Pachev - Understanding MySQL Internals (O'Reilly, 2007)
29. Plew - Teach Yourself SQL in 24 Hours 3e (Sams, 2002)
30. Powell - Beginning Database Design (Wrox, 2006)
31. Rizzo - Pro SQL Server 2005 (Apress, 2006)
32. Silberschatz - Database System Concepts 4e (McGraw, 2001)
33. Wilton,Colby - Beginning SQL (Wrox, 2005)

Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/22/2009 :  04:37:05  Show Profile  Reply with Quote
Hehe are you serious...? This is just too far out to be taken seriously

- Lumbago
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  05:00:15  Show Profile  Send breds a Yahoo! Message  Reply with Quote
Why ?
Give me whatever you got...am desparate
Believe me i need this more than Obama needs to revive the bloody economy, for another term of course
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/22/2009 :  05:48:46  Show Profile  Reply with Quote
Ok, first of all: taking on a project and demanding to get paid for something that you don't have the first clue how to do is...well..."ambitious" to use a friendly term for it. If I was your client I'd be furious. But around here 125$ would pay for about 1 hours work so at least you're not overcharging...

Are you going to use Access or SQL Server? If you're using sql server then maybe you can start here: http://www.functionx.com/sqlserver/. I haven't read the entire tutorial but it seems to cover some of the basics.

- Lumbago
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  05:59:07  Show Profile  Send breds a Yahoo! Message  Reply with Quote
Thanks,let me try
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 01/22/2009 :  06:00:18  Show Profile  Visit spirit1's Homepage  Reply with Quote
ok... so first tell me how on earth can you quote a price when you have no clue about what you're doing? $125 is way too low.
this is a project that you'll spend some time on... trust me

although your description isn't very clear it seems that you need an sql server to store data, and a front end app to read that data.


___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  06:16:15  Show Profile  Send breds a Yahoo! Message  Reply with Quote
Thats exactly what i want(software-wise)
the softwares i've downloaded
1.mysql 5.0,5.1.28, 6.0,6.1
2.mysql-essentials-5.0,5.2
3.mysql-gui-toolswin
4.sqldev.exe
5.mysql-noinstall
6.sqlexpr32.exe
7.mysql-query-analyzer


and they think am a F***ing genious , just coz of a couple of things i've done for them ....dude am not gonna let this client go just coz of that
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30277 Posts

Posted - 01/22/2009 :  06:50:11  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Tried to be honest with them?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30277 Posts

Posted - 01/22/2009 :  06:51:00  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Originally posted by breds

Thats exactly what i want(software-wise)
the softwares i've downloaded
1.mysql 5.0,5.1.28, 6.0,6.1
2.mysql-essentials-5.0,5.2
3.mysql-gui-toolswin
4.sqldev.exe
5.mysql-noinstall
6.sqlexpr32.exe
7.mysql-query-analyzer

and they think am a F***ing genious , just coz of a couple of things i've done for them ....dude am not gonna let this client go just coz of that

Also, this is a MICROSOFT SQL Server forum, not SUN MySQL forum.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30277 Posts

Posted - 01/22/2009 :  06:51:44  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Originally posted by spirit1

$125 is way too low.
Maybe it's Zimbabwe dollars?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/22/2009 :  07:01:17  Show Profile  Reply with Quote
The stuff you downloaded is basically all MySQL which we don't really know anything about (at least not officially). If you want some decent help from us you'll need SQL Server Express which is also free:

http://www.microsoft.com/downloads/details.aspx?FamilyId=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

And I'm not trying to disrespect you here (seriously) but to accept a project like this for 125$ probably isn't the smartest thing you have done in your life.

- Lumbago
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  07:26:20  Show Profile  Send breds a Yahoo! Message  Reply with Quote
how much would you charge them?

And its American dollars

PS:Mugabe will outlive Obama just like Castro with the 7-8 American presidents, Bush is 0.1 of president=0 (these guys are like energizer bunnies...they keep on going and going and ...)
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  07:34:39  Show Profile  Send breds a Yahoo! Message  Reply with Quote
i also got apexSQL ,IF IT HELPS
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  07:44:19  Show Profile  Send breds a Yahoo! Message  Reply with Quote


http://www.functionx.com/sqlserver

THIS IS EXACTLY WHAT I WAS LOOKING FOR, THANKS Lumbago
Go to Top of Page

Zoma
Yak Posting Veteran

South Africa
76 Posts

Posted - 01/22/2009 :  07:46:03  Show Profile  Reply with Quote
Lol...This post is really funny :)
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/22/2009 :  07:49:16  Show Profile  Reply with Quote
If I were to do something like this I'd be multiplying by at least 20...but I've been in the business for almost 13 years now. But it's hard to tell when you don't have the full requirements.

- Lumbago
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/22/2009 :  07:55:21  Show Profile  Reply with Quote
Hey breds...just out of curiosity: how old are you?

- Lumbago
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  08:48:27  Show Profile  Send breds a Yahoo! Message  Reply with Quote
20
why?
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 01/22/2009 :  08:52:11  Show Profile  Send breds a Yahoo! Message  Reply with Quote
thats alot of money Lumbago
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000