Any help please - database modeling
Posted: Tue Jan 19, 2010 11:03 am
I am a new web developing trainer
and I am doing something to learn from
I started building the tables and I need help to see if I did something wrong
I will explain the project, list the tables and wait for help please
Project Summary
"signin page"
- username & password, userID may be admin or a simple student ) (nothing else).
if username and password are valid, if user is admin redirect to admin page
if user is student redirect to student page
admin page Contains:
- Search about student (this will select everything about this student)
- See All information about students Including payments amount,
- ability to add/delete/modify new student
- ability to graduate the student, the student has finished studying
student page Contains:
- Main Information about him Including ( Student table attributes in addition to Degree [bachelor, Master, Doctor], and Major)
- Link for Fees ( Degree cost, payments)
- Link for E-books ( books related to this major under this degree)
Degrees' Costs are mainly constant, but they may differ the next year
I have built the tables, but I think I missed something , can we discuss them together?
thank You
Tables
----------------------------------
Student table
UserID primary
password
Name
date of birth
telephone number
Country
Email
UserLevel
----------------------------
Marjors Table
Major ID primary
Major Name unique
----------------------------
Major selected
Major ID primary
Degree ID primary
user ID primary
Registration Date [current Date]
----------------------------
Ebooks selected
Major ID
Book ID Primary
----------------------------
Ebooks Table
Ebook ID primary
Ebook Name
Ebook Description
Download counter
----------------------------
Degree Table
Degree cost
Degree Name
Degree ID Primary
----------------------------
Payments table
User ID
Degree ID
Payment ID
Payment amount
payment date
and I am doing something to learn from
I started building the tables and I need help to see if I did something wrong
I will explain the project, list the tables and wait for help please
Project Summary
"signin page"
- username & password, userID may be admin or a simple student ) (nothing else).
if username and password are valid, if user is admin redirect to admin page
if user is student redirect to student page
admin page Contains:
- Search about student (this will select everything about this student)
- See All information about students Including payments amount,
- ability to add/delete/modify new student
- ability to graduate the student, the student has finished studying
student page Contains:
- Main Information about him Including ( Student table attributes in addition to Degree [bachelor, Master, Doctor], and Major)
- Link for Fees ( Degree cost, payments)
- Link for E-books ( books related to this major under this degree)
Degrees' Costs are mainly constant, but they may differ the next year
I have built the tables, but I think I missed something , can we discuss them together?
thank You
Tables
----------------------------------
Student table
UserID primary
password
Name
date of birth
telephone number
Country
UserLevel
----------------------------
Marjors Table
Major ID primary
Major Name unique
----------------------------
Major selected
Major ID primary
Degree ID primary
user ID primary
Registration Date [current Date]
----------------------------
Ebooks selected
Major ID
Book ID Primary
----------------------------
Ebooks Table
Ebook ID primary
Ebook Name
Ebook Description
Download counter
----------------------------
Degree Table
Degree cost
Degree Name
Degree ID Primary
----------------------------
Payments table
User ID
Degree ID
Payment ID
Payment amount
payment date