Online Alumni Portal Test Phase Fall 2017 

Dear Students,

 

You are required to develop an application in PHP and MySQL.

 

It should have following functionalities:

  1. Manage ‘Offered Courses’, ‘Faculty Members’ and ‘Classrooms’
  2. Calculate ‘Preference List’ for each offered course

 

The details of each functionality is as follows:

 

  1. Manage ‘Offered Courses’, ‘Faculty Members’ and ‘Classrooms’

Create a form, each, to manage (i.e. add, update, delete, search) ‘Faculty Members’, ‘Offered Courses’ and ‘Classrooms’. The attributes for each table should be like as follows:

 

Offered Course

Course Code

Course Title

Enrollment

CS201

Introduction to Programming

85

CS301

Data Structures

65

CS302

Digital Logic Design

48

CS304

Object Oriented Programming

90

CS401

Computer Architecture and Assembly Language Programming

70

CS601

Data Communication

58

CS604

Operating Systems

75

……

……

……

 

Faculty Member

Faculty ID

Name

Designation

Course Preferences

Date and Time of Preference Submission

DCS23

Prof. Dr. Nadeem Sharjeel

Professor

CS401, CS701, CS704

January 08, 2018, 04:13 PM

DCS24

Dr. Shamim Islam

Associate Professor

CS601, CS610

January 08, 2018, 03:21 PM

DCS41

Dr. Qasim Rafiq

Assistant Professor

CS301, CS304, CS604

January 09, 2018, 09:11 AM

DCS42

Ms. Afsana  Maqbool

Assistant Professor

CS201, CS301, CS606, CS701

January 09, 2018, 02:51 PM

DCS51

Mr. Shakeel Ahmad

Lecturer

CS201, CS401, CS604, CS703, CS704

January 08, 2018, 02:27 PM

DCS52

Mr. Irfan Mehmood

Lecturer

CS201, CS301, CS304

January 08, 2018, 08:44 AM

……

……

……

……

 

 

Classroom

Classroom ID

Building

Capacity

Calculate Schedule

B1-F0-01

Block 1

70

B1-F0-02

Block 1

85

B1-F1-01

Block 1

50

B1-F1-02

Block 1

60

B2-F0-01

Block 2

68

B2-F0-05

Block 2

100

……

……

……

 

 

  1. Calculate ‘Preference List’ for each offered course

‘Preference List’ should look like as follows:

 

Course Code

Faculty Members Willing to Take the Course

Preferred Faculty Member

Possible Classrooms for the Course

Preferred Classroom

CS201

1.       Mr. Shakeel Ahmad

2.       Mr. Irfan Mehmood

3.       Ms. Afsana  Maqbool

Ms. Afsana  Maqbool

B1-F0-02

B2-F0-05

B1-F0-02

CS301

1.       Dr. Qasim Rafiq

2.       Ms. Afsana  Maqbool

3.       Mr. Irfan Mehmood

Dr. Qasim Rafiq

B1-F0-01

B1-F0-02

B2-F0-01

B2-F0-05

B2-F0-01

CS302

 

 

B1-F0-01

B1-F0-02

B1-F1-01

B1-F1-02

B2-F0-01

B2-F0-05

B1-F1-01

CS304

1.       Dr. Qasim Rafiq

2.       Mr. Irfan Mehmood

Dr. Qasim Rafiq

B2-F0-05

B2-F0-05

……

……

……

……

……

 

Rules to Calculate ‘Preference List’

  1. If there are more than one faculty member willing to take a course then preferred faculty member for that courses will be the one with higher designation (e.g. CS201 and CS304 in the above ‘Preference List’ table). If two or more faculty members have same level of designation then the faculty member who submitted the preferences first will be the preferred faculty member for the course (e.g. CS301 in the above table).
  2. Only those classrooms will be included in the possible list for a course whose seating capacity is greater than or equal to the enrollment in that course. Preferred classroom will be the one having smallest capacity ≥ enrollment in the course.

Tags: 2017, Alumni, Fall, Online, Phase, Portal, Test

Views: 25

Attachments:

SPONSORED LINKS

SPONSORED LINKS

© 2018   Created by Irfan Khan MSCS.   Powered by

Badges  |  Report an Issue  |  Terms of Service