Question Details

[solution]: Page 1 of 2 Assignment - Faculty Portal Assignment - Faculty


Answer download
More Details:


Page 1 of 2

Assignment - Faculty Portal

Assignment ? Faculty Portal

You are assigned to help Professor XYZ to create a new Faculty Portal for him to enter Attendance information,

create a new assignment and handout. Professor XYZ has only one class. You will use the MVC pattern to

create this website based on the example BookAppMVC. Here are steps that you will follow to complete this

task:

I. Create a new PHP project named OSCSite.

II. Create folder structures based on the MVC desgin pattern that you learnt in the class

III. Create and code the appropriate files according the following requirements:

A. The data should be stored in MySql database. So you provide scripts for handling the database. Please

refer the Views section to design your database tables.

1. db_connect.php

2. osc_db.sql (that is a script for creating a database, tables, and inserting some data for testing).

B. Models - Please refer to your database design to create model and repository classes.

1. StudentRepository.php

2. Student.php

3. AttendanceRepository.php

4. Attendance.php

5. HandoutRepository.php

6. Handout.php

7. AssignmentRepository.php

8. Assignment.php

C. There is one controller named faculty, so you should create one folder named faculty under the

controllers folder. Then add the following actions:

1. show_faculty_home_page.php (default action)

2. show_attendance_page.php

3. save_attendance.php

4. show_handout_page.php

5. save_handout.php

6. show_assignment_page.php

7. save_assignment.php

D. Views

1. faculty_home_page.php that shows 3 links: Attendance Page, Handout Page and Assignment page.

In addition, you will add a drop-down list for a week no. (1 to 15) for Prof. XYZ to select a week no.

2. attendance_page.php that allows a professor to record students? attendances. The page should

contain:

a) A label - week no that has been selected by Prof. XYZ from the faculty home page. Notice that if

the attendance records of the selected week already exist in the database, then the page should

show the data from the database.

b) A table of students? attendances. Each row should have:

(1) Student ID

(2) Student?s Last Name.

(3) Student?s First Name.

(4) A dropdown list that contains the following values: (P) present, (A) absent, (E) leaving early,

and (L) come late.

c) A Submit button to save the changes.

3. handout_page.php that allows a professor to create a new handout page. The page should contain

the followings:

a) A label - week no that has been selected by Prof. XYZ from the faculty home page. Notice that if

the handout for the selected week already exist in the database, then the page should show the

data from the database.

b) A large TextArea for the handout content (needs data validation for checking empty input)

Page 1 of 2


Page 2 of 2

Assignment - Faculty Portal

c) A Submit button to save the changes.

4. assignment_page.php that allows a professor to create a new assignment. The page should contain

the followings:

a) A label - week no that has been selected by Prof. XYZ from the faculty home page. Notice that if

the assignment for the selected week already exist in the database, then the page should show

the data from the database.

b) A large TextArea for the assignment questions. (needs data validation for checking empty input)

c) A textbox for Total marks (needs data validation for a valid integer)

d) A textbox for Due date (needs data validation for a valid date)

e) A Submit button to save the changes.

E. Create a CSS file that styles your website.

Page 2 of 2

2 of 2 Assignment - Faulty Portal.pdf Open with

Displaying Assignment - Faulty Portal.pdf.


Assignment - Faculty Portal

 


 

Assignment ? Faculty Portal

 

You are assigned to help Professor XYZ to create a new Faculty Portal for him to enter Attendance information,

 

create a new assignment and handout. Professor XYZ has only one class. You will use the MVC pattern to

 

create this website based on the example BookAppMVC. Here are steps that you will follow to complete this

 

task:

 

I. Create a new PHP project named OSCSite.

 

II. Create folder structures based on the MVC desgin pattern that you learnt in the class

 

III. Create and code the appropriate files according the following requirements:

 

A. The data should be stored in MySql database. So you provide scripts for handling the database. Please

 

refer the Views section to design your database tables.

 

1. db_connect.php

 

2. osc_db.sql (that is a script for creating a database, tables, and inserting some data for testing).

 

B. Models - Please refer to your database design to create model and repository classes.

 

1. StudentRepository.php

 

2. Student.php

 

3. AttendanceRepository.php

 

4. Attendance.php

 

5. HandoutRepository.php

 

6. Handout.php

 

7. AssignmentRepository.php

 

8. Assignment.php

 

C. There is one controller named faculty, so you should create one folder named faculty under the

 

controllers folder. Then add the following actions:

 

1. show_faculty_home_page.php (default action)

 

2. show_attendance_page.php

 

3. save_attendance.php

 

4. show_handout_page.php

 

5. save_handout.php

 

6. show_assignment_page.php

 

7. save_assignment.php

 

D. Views

 

1. faculty_home_page.php that shows 3 links: Attendance Page, Handout Page and Assignment page.

 

In addition, you will add a drop-down list for a week no. (1 to 15) for Prof. XYZ to select a week no.

 

2. attendance_page.php that allows a professor to record students? attendances. The page should

 

contain:

 

a) A label - week no that has been selected by Prof. XYZ from the faculty home page. Notice that if

 

the attendance records of the selected week already exist in the database, then the page should

 

show the data from the database.

 

b) A table of students? attendances. Each row should have:

 

(1) Student ID

 

(2) Student?s Last Name.

 

(3) Student?s First Name.

 

(4) A dropdown list that contains the following values: (P) present, (A) absent, (E) leaving early,

 

and (L) come late.

 

c) A Submit button to save the changes.

 

3. handout_page.php that allows a professor to create a new handout page. The page should contain

 

the followings:

 

a) A label - week no that has been selected by Prof. XYZ from the faculty home page. Notice that if

 

the handout for the selected week already exist in the database, then the page should show the

 

data from the database.

 

b) A large TextArea for the handout content (needs data validation for checking empty input)

 


 

Page 1 of 2

 


 

Assignment - Faculty Portal

 

c) A Submit button to save the changes.

 

4. assignment_page.php that allows a professor to create a new assignment. The page should contain

 

the followings:

 

a) A label - week no that has been selected by Prof. XYZ from the faculty home page. Notice that if

 

the assignment for the selected week already exist in the database, then the page should show

 

the data from the database.

 

b) A large TextArea for the assignment questions. (needs data validation for checking empty input)

 

c) A textbox for Total marks (needs data validation for a valid integer)

 

d) A textbox for Due date (needs data validation for a valid date)

 

e) A Submit button to save the changes.

 

E. Create a CSS file that styles your website.

 


 

Page 2 of 2

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Dec 18, 2020

PRICE: $18.50

Solution~00031148083729.zip (25.37 KB)

Buy this answer for only: $18.50

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Dec 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now