Assignment 2 - Databse Design

Announcements	Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Kris

Re: Assignment 2 - Databse Design
May 08, 2011 06:16PM

Registered: 13 years ago
Posts: 29
Rating: 0

I'm not sure Divana, have you checked chapter 11 in the textbook? I know there is a part that explains changes you need to make in your php.ini file.

Reply Quote

Absolom72945079

Re: Assignment 2 - Databse Design
May 08, 2011 10:50PM

Registered: 13 years ago
Posts: 51
Rating: 0

Dr Mac I have a few questions which are really hindering my progress to complete the project as follows:

1.The Manage students page must it only display the student name and surname then a delete and edit buttons plus a link to add a new user which redirects to the registration page?

2.The veiw registrations page is it a page that shows the table course_students and this table is it a table that is generated from fields in the two tables course and student, I'm really confused on this one? So what I should do is join some of the fields into the course_students then show them onto the course_students page?

3.Lastly I am really confused about the e-mail option on the registration page and making it send to other students in the same course is there anyone who can assist me with this?Please help me so I can finish my project.

Reply Quote

Mac

Re: Assignment 2 - Databse Design
May 09, 2011 08:03AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

1. Yes
2. Shows all the students that have registered for a particular course. So you can present a drop down of all courses, and when it is selected then it shows the students for that course

Reply Quote

Mac

Re: Assignment 2 - Databse Design
May 09, 2011 08:05AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

divava Wrote:
-------------------------------------------------------
> hi guys last minutes touch ups...
>
> please help emailing back to student, i think its
> the mailing config hav to make sure though
> look at the simple code below

This has been discussed in detail elsewhere.

Reply Quote

Absolom72945079

Re: Assignment 2 - Databse Design
May 09, 2011 09:40PM

Registered: 13 years ago
Posts: 51
Rating: 0

Thanks for all the information really helping Dr Mac, Another questions, so what do we use the course_student table?

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 10, 2011 08:55AM

Registered: 13 years ago
Posts: 93
Rating: 0

OK I think I am finished with the project! grinning smiley

However I still have a couple of questions

1. How many (how will they be weighed) extra features gain me the full 30%?
2. I have not decorated my project, however information is clearly visible, will this count against me?
3. Should the program delete all students registered for a particular course(this was an example on the tut letter)?
4. What features will likely gain me higher marks?
5. AND LASTLY Dr. Mac this has been a challenging exercise. Roughly how much would a client be charged for a project like this? I am guessing at least smoking smiley

R10 000.00!!!

Reply Quote

Mac

Re: Assignment 2 - Databse Design
May 10, 2011 09:04AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

1. It depends on the quality and usefulness and logic, so it depends smiling smiley

2. Decorations not important - usability yes.
3. Your code!
4. R2000.

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 10, 2011 09:08AM

Registered: 13 years ago
Posts: 93
Rating: 0

Thanks Dr. Mac.

Reply Quote

Shaun2010

Re: Assignment 2 - Databse Design
May 10, 2011 09:31AM

Registered: 13 years ago
Posts: 263
Rating: 0

Hi Mac

I don't suppose you would be able to give a little bit of feedback on our projects and like break our marks down, say like you got 4/5 for your app, 2/3 for the added functionality and 1/2 for your theory?

Or am I grasping at straws here smiling smiley

A word to the wise ain't necessary - it's the stupid ones that need the advice.
Student Number:72793775

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 10, 2011 09:33AM

Registered: 13 years ago
Posts: 93
Rating: 0

Sorry Dr Mac but you have not answered

3. Should the program delete all students registered for a particular course(this was an example on the tut letter)?

Reply Quote

Shaun2010

Re: Assignment 2 - Databse Design
May 10, 2011 09:39AM

Registered: 13 years ago
Posts: 263
Rating: 0

xmgcoyi Wrote:
-------------------------------------------------------
> Sorry Dr Mac but you have not answered
>
> 3. Should the program delete all students
> registered for a particular course(this was an
> example on the tut letter)?

Yes, when you delete a course, the students for that course should be deleted to

A word to the wise ain't necessary - it's the stupid ones that need the advice.
Student Number:72793775

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 10, 2011 09:47AM

Registered: 13 years ago
Posts: 93
Rating: 0

lets say a student is registered for course A, B and C,

when i register the student their sno is stored on the course_student table together with the cid

if i delete course B the student will remain registered for course A and C.

so do you mean that i should delete the student details from course_student and then if i remove course A and C I should should delete the student information all together????????

Reply Quote

wsbraun

Re: Assignment 2 - Databse Design
May 10, 2011 10:13AM

Registered: 13 years ago
Posts: 60
Rating: 0

You only need to remove the course from the tables that reference it. In this case the course table and the course_student table

As easy as

Language: SQL
DELETE FROM course_student WHERE cid=$cid;
DELETE FROM course WHERE cid=$cid;

This will maintain referential integrity such that you don't have a student registered for a non existent course.

You do a similar thing when deleting students.

--

Student Number: 7298-786-3

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 10, 2011 10:31AM

Registered: 13 years ago
Posts: 93
Rating: 0

thanks wsbraun I now fully understand

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 10, 2011 02:54PM

Registered: 13 years ago
Posts: 93
Rating: 0

session_id() is giving me a warning! shoulf i rather not use it?

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 10, 2011 05:03PM

Registered: 13 years ago
Posts: 93
Rating: 0

i have uploaded my project on to my domain name smile

it still has a lot of bugs but it should be fully working by tonight. Please visit My Site to evaluate. please dont be shy to comment it will be appreciated. If you have any suggestions please do comment!

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 10, 2011 05:06PM

Registered: 13 years ago
Posts: 93
Rating: 0

You may login on My site by using username "admin" and password "admin"

Reply Quote

Belanda

Re: Assignment 2 - Databse Design
May 10, 2011 08:51PM

Registered: 13 years ago
Posts: 67
Rating: 0

Hey Everyone

A quick question,
The functions page...must it contain the add edit and delete php codes for both course and student.?

OR must we do it all under one page..eg: manage course have all the codes on the same page (add ,edit , delete courses)?
manage student have all the codes on the same page(add,edit,delete students)?

please advise...
thanks

Reply Quote

Belanda

Re: Assignment 2 - Databse Design
May 10, 2011 11:08PM

Registered: 13 years ago
Posts: 67
Rating: 0

Hey everyone

do we have to have a login page (password)for admin to add edit and delete,,,
or can we just have it all available on index .php.

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 11, 2011 02:25AM

Registered: 13 years ago
Posts: 93
Rating: 0

Hey Belanda,

OK let me try to answer you..

you are NOT bound to code only on 1 page! you can put your code where ever you want, as long as it makes sense. However it would be very neat and a good coding practice to have code that you will most like ly re use on the functions page.

You do not really HAVE to have a login page BUT if you want higher marks it is a good idea to have it as 1 of the extra features meantioned in the tut letter. if you have plenty of other features don't bother.

Please confirm with Mac.

Reply Quote

xmgcoyi

Re: Assignment 2 - Databse Design
May 11, 2011 02:28AM

Registered: 13 years ago
Posts: 93
Rating: 0

Guys please visit My Site and use what you see and please feed back! Thanks http://www.xolanimgcoyi.co.za

Reply Quote

Absolom72945079

Re: Assignment 2 - Databse Design
May 13, 2011 02:18AM

Registered: 13 years ago
Posts: 51
Rating: 0

Can I submit my project friday after 19:00, please give us the due time ?Which e-mail address are we sending the project to?

Reply Quote

Mac

Re: Assignment 2 - Databse Design
May 13, 2011 08:31AM

Admin
Registered: 18 years ago
Posts: 10,001
Rating: 353

That information is in the tut letter. You can send it my 23h59:59 if you really want to!

Reply Quote

Absolom72945079

Re: Assignment 2 - Databse Design
May 13, 2011 07:09PM

Registered: 13 years ago
Posts: 51
Rating: 0

Thanks Dr Mac I guess I'm panicking , you are far too kind, will send it before 23h59:59, have a great weekend!

Reply Quote