| Author |
 Topic  |
|
breds
Starting Member
13 Posts |
 Posted - 01/21/2009 : 11:27:25
|
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
47023 Posts |
Posted - 01/21/2009 : 11:29:35
|
this seems like a homework question
can you show what you tried till now? |
 |
|
|
breds
Starting Member
13 Posts |
Posted - 01/22/2009 : 02:33:01
|
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)
|
|
|
|
Lumbago
Norsk Yak Master
Norway
3241 Posts |
Posted - 01/22/2009 : 04:37:05
|
Hehe are you serious...? This is just too far out to be taken seriously 
- Lumbago |
|
|
|
breds
Starting Member
13 Posts |
Posted - 01/22/2009 : 05:00:15
|
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 |
|
|
|
Lumbago
Norsk Yak Master
Norway
3241 Posts |
Posted - 01/22/2009 : 05:48:46
|
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 |
|
|
|
breds
Starting Member
13 Posts |
Posted - 01/22/2009 : 05:59:07
|
| Thanks,let me try |
|
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 01/22/2009 : 06:00:18
|
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! |
|
|
|
breds
Starting Member
13 Posts |
Posted - 01/22/2009 : 06:16:15
|
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 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 01/22/2009 : 06:50:11
|
Tried to be honest with them?
E 12°55'05.63"
N 56°04'39.26" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 01/22/2009 : 06:51:00
|
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" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 01/22/2009 : 06:51:44
|
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" |
|
|
|
Lumbago
Norsk Yak Master
Norway
3241 Posts |
|
|
breds
Starting Member
13 Posts |
Posted - 01/22/2009 : 07:26:20
|
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 ...) |
|
|
|
breds
Starting Member
13 Posts |
Posted - 01/22/2009 : 07:34:39
|
i also got apexSQL ,IF IT HELPS
|
|
|
|
breds
Starting Member
13 Posts |
|
|
Zoma
Yak Posting Veteran
South Africa
76 Posts |
Posted - 01/22/2009 : 07:46:03
|
| Lol...This post is really funny :) |
|
|
|
Lumbago
Norsk Yak Master
Norway
3241 Posts |
Posted - 01/22/2009 : 07:49:16
|
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 |
|
|
|
Lumbago
Norsk Yak Master
Norway
3241 Posts |
Posted - 01/22/2009 : 07:55:21
|
Hey breds...just out of curiosity: how old are you?
- Lumbago |
|
|
|
breds
Starting Member
13 Posts |
Posted - 01/22/2009 : 08:48:27
|
20
why? |
|
|
|
breds
Starting Member
13 Posts |
Posted - 01/22/2009 : 08:52:11
|
| thats alot of money Lumbago |
|
|
|
Topic |
|
university database
