-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathER.txt
116 lines (62 loc) · 2.19 KB
/
ER.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
# ....... JOB VACANCY MANAGEMENT SYSTEM FOR GRADUATED STUDENTS ......
Graduated student - NAME,ID,ADDRESS,TALLENTS , PREFERENCES ON COMPANIES , SALARY EXPECTED
Company - NAME, REGISTEREDNO , ADDRESS.
VACANCY - TITLE,
REQUIREMENTS - 1,2,3
NO OF VACANCIES
SALARY
STUDENT RATES A COMPANY - RATING NUMBER,RATING DATE
COMPANY HAS VACANCY ON ......
============================================================================================
//TODO
NORMALIZATION
ID,Tallents,PreferedCompanies Name,Address,SalaryExpected
Name, FirstName,LastName
DegreeCode,StudentID Name,GPA,Class
VacancyID,Requirements,CompanyID,StudentID, JobTitle,NoOfVacancies,AllocatedSalary
=======================================================================================================
DATABASE
Tables
1. Student
primary key - ID
FirstName,LastName,Address,Tallents,PreferedCompanies,SalaryExpected
2. Company
primary key - RegisteredID
Name,Location, //PreferedStudentID //AvgRating
3. Rating
primary key - RatingID
foeignKey - StudentID
CompanyID,RatingNumber,RatingDate
4. Vacancy
primary key - VacancyID
Foreignkey - companyID
JobTitle,NoOfVacancies,Requirements,AllocatedSalary
5. Degree
primary key - Degreecode
Foreign key - student ID
Name,GPA,GraduatedYear,Class
6. SignUp details
username
password
=========================================================================================================
//TODO:
//QUARIES - ADD ENTRIES
- SELECT THE STUDENTS WHO CAN APPLY FOR VACANCY
- GET THE AVERAGE RATING
- UPDATE
- DELETE -
=============================================================================================================
//assumption -
1 according to the degreecode,class check the vacancy can give to the student- (selection box to select the degree,class)
2.student can select prefered companies in our database, give selection box
==========================================================================================================
//TODO:
1
//try to make selections
forms 2 - > write to database tables
2
login,signup
3
profile page -> get data from tables
update
delete