Need help with Database Design & Tables

Feel free to post about MYSQL, SQL, PGSQL, ACCESS or any other database type in here.

Need help with Database Design & Tables

Postby Tank21 on Thu Mar 20, 2008 11:02 am

I would be very grateful if someone could help me with the Database design and how many tables I require, if I would need a seperate one for login and the relationship between the tables, and the fields for each one!

SuperTrack - A Supervision Tracking System

Requirement Specification

The Faculty of Enigmatic Computing at the Forlorn University wants a Web‐based application to help project supervisors and their students to manage their projects.

There are about 50 members of academic staff who would like to be able to create an account on the system (using a username/password authentication mechanism). Each academic can then define and maintain a number of projects and can assign one or more students to each project, as project members.
For each project, the system stores the name of the project, the names of the assigned students, and a list of project activities, statuses and dates. The activity and status can be updated by the corresponding student. The supervisor can modify all information. The values of the status are "ongoing" for an ongoing activity, "done" if the activity has successfully finished, and "pending" if the student needs help from the supervisor.

Students can be given accounts on the system as well and will see the list of projects they are registered with upon logging in They can modify the current activities and their status.

Thanks :roll:
Tank21
 
Posts: 1
Joined: Thu Mar 20, 2008 10:59 am

Re: Need help with Database Design & Tables

Postby Voodoochilli on Wed Apr 02, 2008 11:41 am

Hi Tank21!

I would have the following:

USERS
*******
USER_ID (Auto incremental, primary key)
USER_NAME
USER_PASSWORD
plus any other user details like address privileges etc

PROJECTS
******
PROJECT_ID (Auto incremental, primary key)
PROJECT_TITLE
PROJECT_OWNER (This would be the USER_ID of the person it belongs to)
PROJECT_STATUS
PROJECT_PERMISSIONS (You could store an array or comma separated list of people allowed to be a member of this project, or you coudl store this in the USERS table)
User avatar
Voodoochilli
Site Admin
 
Posts: 77
Joined: Tue Nov 27, 2007 9:52 am
Location: Hereford, UK

Test, just a test

Postby XRumerTest on Sun Jan 31, 2010 11:35 am

Hello. And Bye.
XRumerTest
 
Posts: 9
Joined: Mon Mar 09, 2009 3:22 pm


Return to MYSQL/SQL and other databases Forum

Who is online

Users browsing this forum: No registered users and 0 guests

cron