CSE370: Database Systems (group project)
HTML, CSS, JS, SCSS, Python, SQL
Django, Bootstrap
MYSQL
- Django Model
- Django admin
- Django Static files
A simple website where students will have access to Course Material, where they will be able to post materials and playlists that have helped them with their studies. Staff members will have the ability to post important announcements on the site. Students can also post complaints or make remarks about any problems or concerns they are having and staff will view them and either "resolve" or "reject" them.
- Download the entire file, then put it in the
htdocsfolder (localhost folder). - Start
ApacheandMySQlin XAMPP. - Go to phpmyadmin, by clicking on the
Adminbutton next to theMySQlstart button, create a database nameduniinfodeskand import the SQL file (uniinfodesk.sql) into that database. - In vscode, open the folder
UniHelpDesk(there are two folders with the same name; select the one that appeared initially), and then typepython manage.py runserverin a new terminal. Run this command from project directory.
(Might need to modify the database information for that; go to UniHelpDesk/UniHelpDesk/settings look for a part that looks like this:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'uniinfodesk',
'USER': 'root',
'PASSWORD': '',
'HOST': 'localhost',
'PORT': '3306',
}
}
If the username and password are different, enter them properly; otherwise, skip this step.
Commands that may be needed pip install mysql , pip install django-jazzmin , pip install Pillow )
Students' usernames/IDs are:
1001, 1002, 1003, 1004, 1005,1006
password: userstudent
Staff usernames are:
sta1, sta2
password: userstaff
Faculty usernames are:
fac1, fac2
password: userfaculty
- Student, Staff, faculty has their separate login page to login.
- Student needs to register before login if logging in for the first time.
- Staff and faculty don’t have to register.
- Every user has their profile with their information.
- Student can update their profile
- Allows student users to express university-related problems or concerns, as well as view the complaints of others.
- Staff users can see student complaints and will either resolve or reject them.
- Students can view resolved or rejected status of their complaints. If the issues are pending students can view that too.
- Students can view which of the staff members resolved their complaints.
- Staff users have the option to post and remove announcements.
- Student and faculty users can view the announcements, as well as which staff members posted them and who announced them.
- Staff users will have their own payment section where they can view their payment status.
- Faculties can add or remove courses
- Student can view Courses
- Any Student can upload course content.
- Any student can view course content.
https://github.com/shihabshahrier | https://github.com/jerinsync