COSC2446 - Web Programming - IT/Computer Science Assignment Help

Assignment Task

Develop a website to provide information about courses ina College. (Check Library example)

• Write an SQL script to set up a table Course in a database College, with fields for a unique course_id (serial primary key), course_code (varchar), name (varchar), subject (varchar), instructor (varchar), weeks(integer)and description (text). Ensure you call your database Collegeand table Course, so that I can recreate your site on my computer. Make sure case matches. No need to add data to this table in the script.
o Code is a typical course code such a LIT101
o Name is the name of the course e.g.English Literature 
o Subject is the general subject area e.g.Literature
o Instructor is the name of the instructor
o Weeks is how long the course runs for e.g. 8 weeks.
o Description is a paragraph or so describing the course content
• Use the include() function to place a file header.inc, nav.inc and footer.inc into all your pages. The unique content on each page is inside a main element.
(check week 8 notes for include function)
o Header.inc contain the head element and top of the body with a header element for the site banner.
o Nav.inc includes a nav element with links to the required pages
o Footer.inc contains a footer element with your copyright notice, and the closing page tags
• Each page must be 1000px wide, centered in the browser window, using a wrapper div or other means to contain all content. Don’t use Bootstrap or other framework for this. It must have a banner across the top 100px high with some site title.Each page has a horizontal navigation below the top, 30px high, with links to Home, Courses, Subjects, Instructors and Add.
• Home is the home page (index.php). This page needs to have some content to fill up some space. 

• Add (add.php) is a form to add a new course. Include form elements for all fields except the id, which is generated by the database. Form should also include a file upload option to upload a word document (like detailed weekly schedule for that course) required for the course.  Write a processing script to add the data from the form to the database and to upload files into the directory Course_Guide on your server(check updated_library example with file upload on canvas).

• Subjects (subjects.php) lists allsubjects from the database and a hyperlink (under subject) to a page subject.php, which uses a query string to display only the courses that belong to that subject.
• Instructors (instructors.php) lists all the instructorsfrom the database and a hyperlink (under instructor name) to a page instructor.php, which uses a query string to display only the courses taught by that instructor.
• Use separate files for common content (the include files) and an external style sheet
• You need to create a folder with your name and submit the following files 
1. Course.sql
2. Header.inc,footer.inc, nav.inc
3. Course.css
4. Index.php
5. Courses.php(will display all the courses from the database with hyperlink under name)
6. Course.php(display details about single course selected in courses.php)
7. Subjects.php (will display all the subjects the database with hyperlink under subject)
8. Subject.php(display details about single subject selected in subjects.php)
9. Instructors.php(will display all the instructors from the database with hyperlink under instructor)
10. Instructor.php(display details about single instructor selected in instructors.php)
11. Add.php (including file upload) and processing script
12. Directory with name Course_Guide for uploading all the course information 
• Zip up your folder and upload on Canvas.
Marks: 20% of total score for the course.Teacher can ask to any Student to give demonstration for this assignment to validate the work.
 

This COSC2446 IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.