[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 488: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4762: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4764: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4765: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4766: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3897)
Ubuntu-cy - Ubuntu Linux - Cyprus Local Community Team • View topic - Databases

Databases

Re: Databases

Postby christodoulos » Fri Nov 28, 2008 1:52 pm

User avatar
christodoulos
Advanced Member
 
Posts: 205
Joined: Mon May 05, 2008 7:52 am
Location: Paphos

Re: Databases

Postby marinos » Fri Nov 28, 2008 1:58 pm

So you have 5 Tables

Departments Related with students and Lecturers
Assignments Related with Students
Courses related with students and Leturers

In each table you can put Details that you need.
Everything should be made as simple as possible, but not simpler.
--Albert Einstein--
User avatar
marinos
How much time you spend in here?
 
Posts: 834
Joined: Tue May 20, 2008 2:37 pm
Location: Limassol

Re: Databases

Postby marinos » Fri Nov 28, 2008 2:02 pm

My mistake...
you also have many to many relation ships between:
Courses and lecturer "If Each lecturer Teaches more than one course and each course teached by more than one lecturer "
the same might appear between courses and students.

Let us know
Everything should be made as simple as possible, but not simpler.
--Albert Einstein--
User avatar
marinos
How much time you spend in here?
 
Posts: 834
Joined: Tue May 20, 2008 2:37 pm
Location: Limassol

Re: Databases

Postby christodoulos » Fri Nov 28, 2008 5:11 pm

Yes,

Departments, Courses = a new table --> Courses_Offered
Student table will take the Department key so we know the student department

a new table --> Student_Courses will take the key from Students and Courses_Offered

Assignments, Lecturers, Students, Courses_Offered --> Student_Assignment take the primary keys of the 4 tables
So we have an assignment that was given to a student be a lecturer for a specific course

Is this right? If yes, how can I have group assignments ?


Is that clear ?
User avatar
christodoulos
Advanced Member
 
Posts: 205
Joined: Mon May 05, 2008 7:52 am
Location: Paphos

Re: Databases

Postby marinos » Fri Nov 28, 2008 6:28 pm

Let me tell you what I understand up to now and give you relation ships.

Departments 1-->m Student
This is Clear
One student can take many courses and one course can be taken by many Students so we brake the relationship as follows

Student 1-->m coursesoffered m<--1 Courses
Then one department has many courses but at the same time each course might appear in more than one department so the relationship is the follows:

Departments 1-->m coursesperdepart m<--1 courses

The difficult part is the relations between Students, Lecturers and Assignments here we must create new table "lets call it assignment_offered " and broke the relationship as follows:
Student 1-->m assignment_offered
Lecturer 1-->m assignment_offered
Assignment 1-->m assignment_offered
were in assignment_offered table you must have StudentID, LecturerID, AssignmentID, assignment_offeredID and another one useful field.

My question now is:
Don't you need to know the responsible lecturer for each course? or the courses which each lecturer teaches?
Everything should be made as simple as possible, but not simpler.
--Albert Einstein--
User avatar
marinos
How much time you spend in here?
 
Posts: 834
Joined: Tue May 20, 2008 2:37 pm
Location: Limassol

Re: Databases

Postby christodoulos » Sat Nov 29, 2008 8:11 am

User avatar
christodoulos
Advanced Member
 
Posts: 205
Joined: Mon May 05, 2008 7:52 am
Location: Paphos

Re: Databases

Postby christodoulos » Sat Nov 29, 2008 1:02 pm

This is the ERD


As I said my confusion is the Assignments. Any feedback would be helpful! :D
I also attach the database if want to see it
Attachments
New Database.zip
OpenOffice Bace (.odb)
(3.27 KiB) Downloaded 200 times
User avatar
christodoulos
Advanced Member
 
Posts: 205
Joined: Mon May 05, 2008 7:52 am
Location: Paphos

Re: Databases

Postby marinos » Sat Nov 29, 2008 5:09 pm

The database is correct but am not sure about the Idea. Can please post the Idea behind each table so I'll be able to help you a bit more?
Everything should be made as simple as possible, but not simpler.
--Albert Einstein--
User avatar
marinos
How much time you spend in here?
 
Posts: 834
Joined: Tue May 20, 2008 2:37 pm
Location: Limassol

Re: Databases

Postby charizan » Sat Nov 29, 2008 7:31 pm

looks ok, i'll check it more and be back with feedback
It's only funny until someone gets hurt, then it's hilarious!
User avatar
charizan
Guru
 
Posts: 1340
Joined: Wed Apr 23, 2008 8:17 pm
Location: Limassol

Re: Databases

Postby christodoulos » Sun Nov 30, 2008 2:52 pm

The idea is that a student register in under a department and takes the courses offered for the current semester.
The lecturer that teach the course assign one or more assignments to the students, but the assignments may be individual or in group
User avatar
christodoulos
Advanced Member
 
Posts: 205
Joined: Mon May 05, 2008 7:52 am
Location: Paphos

PreviousNext

Return to Scripting and Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron