Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 university database

Author  Topic 

breds
Starting Member

13 Posts

Posted - 2009-01-21 : 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

52326 Posts

Posted - 2009-01-21 : 11:29:35
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 - 2009-01-22 : 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)

Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-22 : 04:37:05
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 - 2009-01-22 : 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
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-22 : 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
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 2009-01-22 : 05:59:07
Thanks,let me try
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-01-22 : 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!
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 2009-01-22 : 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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-22 : 06:50:11
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

30421 Posts

Posted - 2009-01-22 : 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"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-22 : 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"
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-22 : 07:01:17
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 - 2009-01-22 : 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 ...)
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 2009-01-22 : 07:34:39
i also got apexSQL ,IF IT HELPS
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 2009-01-22 : 07:44:19


http://www.functionx.com/sqlserver

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

Zoma
Yak Posting Veteran

76 Posts

Posted - 2009-01-22 : 07:46:03
Lol...This post is really funny :)
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-22 : 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
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-22 : 07:55:21
Hey breds...just out of curiosity: how old are you?

- Lumbago
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 2009-01-22 : 08:48:27
20
why?
Go to Top of Page

breds
Starting Member

13 Posts

Posted - 2009-01-22 : 08:52:11
thats alot of money Lumbago
Go to Top of Page
  Previous Page&nsp;  Next Page

- Advertisement -