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 |
|
charles1309
Starting Member
15 Posts |
 Posted - 2007-11-19 : 09:22:09
|
| Entity Relationship diagramcan anyone help me with my diagram pleasee..i have been banging my head on it for weeks.i have 6 entities Student, Course, Module, Attendance, and ResultPolato Student Record System"The Polato university administration has decided to computerise their student record system. The system must be able to automatically print a new ID card for students on their admission and after completion of each academic year. The card should have the student’s name, number of years and the message welcome to 1st, 2nd or final year. In a bid to curb the rate of incompletion, the system should also be able to record attendance of students to any class. The system should be able to automatically send out a warning to any student that misses any two lectures for the first time. (Of course the student should come up with a very good reason for missing the lectures or else he/she will be removed from the module). Missing three or more lectures leads to automatic withdrawal from the module involved. A student will receive notice from the system, right after missing the second lecture. The system also must be able to calculate each student’s results for that semester only showing details of all modules taken. You should use the simple formula; the total of all the modules taken, divided by the number of modules"charles |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2007-11-19 : 12:01:54
|
| Charles,Is this a project for school? Show us what you have so far, we can probably help you head in the right direction.Nathan Skerl |
 |
|
|
charles1309
Starting Member
15 Posts |
Posted - 2007-11-19 : 16:21:52
|
| am at workplacement at the moment for this agent, and we've been trained and its part of our training. so far ive got student, course, module, result, and register or attendance... its a diagram , can i post it here, is that possible?charles |
|
|
|
wjb55
Starting Member
3 Posts |
Posted - 2007-11-20 : 23:06:59
|
| See, if this helps you?http://en.wikipedia.org/wiki/Entity-relationship_diagram |
|
|
|
wjb55
Starting Member
3 Posts |
Posted - 2007-11-20 : 23:53:49
|
| alsohttp://www.conceptdraw.com/products/img/ScreenShots/cd5/software/Chen_ERD.gif |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2007-11-21 : 11:19:28
|
| also this one: [url]http://databaseanswers.org/data%5Fmodels/[/url]Nathan Skerl |
|
|
|
|
|
|
|
|
Entity Relationship diagram