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.
| Author |
Topic |
|
daipayan
Posting Yak Master
181 Posts |
 Posted - 2009-02-04 : 12:50:01
|
| Hi,Am new to this forum, am a student, in my college, I have to create an COLLEGE ADMINISTRATION PROJECT in MS SQL 2000 i.e. the story is the college is a residential campus, means they have their own mess facility, library, security, student in/out record book, then the student details, faculty details and also the marks of students. They keep each and every details in register, they want to transfer this data into MS SQL Database.Am confused, what can be the basic database layout?Can anyone help me, please?Daipayan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-04 : 13:01:38
|
| Seems like you need to start from basis of DBMS. Search in google on DBMS principles,data modelling,normalisation... |
 |
|
|
daipayan
Posting Yak Master
181 Posts |
Posted - 2009-02-04 : 17:02:25
|
quote:
Originally posted by visakh16
Seems like you need to start from basis of DBMS. Search in google on DBMS principles,data modelling,normalisation...
I know about this. All I want a dbms/ER diagram related to this project.Daipayan |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 17:26:35
|
quote:
Originally posted by daipayan
quote:
Originally posted by visakh16
Seems like you need to start from basis of DBMS. Search in google on DBMS principles,data modelling,normalisation...
I know about this. All I want a dbms/ER diagram related to this project.Daipayan
We can't design database for you.That is spoonfeeding. You need to try yourself and show us what you tried .Over here you will get help from experts. |
|
|
|
daipayan
Posting Yak Master
181 Posts |
Posted - 2009-02-16 : 06:33:15
|
Sir,As per your instruction, I had created a database layout. Just check once, is it ok or not?Here, just assigning marks to each student part is left, that I'll complete soon and show it to you. Image Link: [url]http://users2.titanichost.com/daipayan/Kbs.gif[/url]Daipayan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-16 : 09:20:17
|
| why does your city,destination etc dont have any id columns. i would have kept identity columns in them and made pk on them. i also use id values in other table as fk |
|
|
|
daipayan
Posting Yak Master
181 Posts |
Posted - 2009-02-16 : 13:34:32
|
quote:
Originally posted by visakh16
why does your city,destination etc dont have any id columns. i would have kept identity columns in them and made pk on them. i also use id values in other table as fk
OK, Sir, I'll alter the tables as per your instruction.Daipayan |
|
|
|
|
|
|
|
|
Need Basic Layout