University : Others UniLearnO is not sponsored or endorsed by this college or university.
Subject Code : ITDB201
Assignment Task:

GENERAL COLLEGE GUIDELINES 
1) All students are given 48 hours to complete and submit their assignment from the day, date and time the assignment is uploaded.  

2) Only one assignment is given to the students within the 48-hour period given. The student should contact their respective department if more than one assignment is given within the same period (As indicated in point 7).

3) Assignment answer scripts will be uploaded through any of the following platforms or combinations of the following: e-learning and or any course-specific platform identify by the course tutor. However, students may submit their assignments through HCT emails in case if they have encountered any technical issues with the platform stated above.

4) Student’s submissions will be checked through Turnitin software to ensure academic integrity, if applicable. "According to Turnitin's article on interpreting Turnitin originality report, "a high percentage of plagiarism would probably be anything over 25%".

5) Students who fail to submit their assignment as per the deadline given; will be granted “Zero” unless otherwise justified.

6) If students encounter any problem in submitting their course assignments, they should communicate immediately via email to their course lecturer. The student must attach proof of their inability to submit their course assignment.

7) Students will be allowed to submit an online appeal regarding the failure of the assignment submission issue within three days from the date of the submission deadline. The appeals will only be accepted if the student provides a genuine excuse for the submission failure with the attached evidence.

8) Student may need to ask for support assistant with two related matters as follows:

a) Technical issues; will be tackled by the specialized technicians from the Educational Technology Center (ETC).

b) Course-specific inquiries/support issues; students who require any clarifications on the assignments can immediately contact their respective course tutors /lecturers through emails (within the 48-hour period given). Course tutors/ lecturers should respond promptly to the student’s doubts and queries

Instructions 
1. Create a folder in your Wamp Server root directory and name it as “SETA-YourFirstName” (Eg: SETA-Ahmed).  

2. Create a dbscript-YourID.sql file (ex: dbscript-16J123.sql) to write the script for the database and its associated tables.

3. Import the dbscript-YourID.sql in the MySQL database server for creating the database and its tables.

4. Create PHP Forms and other supporting resources as stated below.

  • PHP Forms (Login Form, Logout Form, Faculty Form, Main Form, Course Form, DB connection Form)
  • Image folder named ‘pics’. Keep any JPEG image inside this folder for the purpose of testing.

5. You must write the codes to access the database using PDO methods only.  

6. Test the completed PHP forms via ‘localhost’.  

7. Paste the screenshot of the table structure and the screenshot of the PHP Forms (webpages) in a word document file (Ex:16J123.doc)

8. Upload your compressed folder through the link provided on the e-Learning portal. 
 

Scenario: 
 
Assume that you are the PHP Web Developer in Bhawan Cybertek Training Institute in the Sultanate of Oman. The Training Institute assigned you the task to develop a database-driven PHP Application/ System. Your responsibility is to develop a system for the Faculty Course Page. The system should store the details of the faculty and the courses. New faculty should register first to use the system. And the existing faculty can login with the registered user name and password. After the successful login, the faculty will be able to register or add new courses. The added course details will be listed in the web page. The proposed system should have the capability to store and manipulate the data related to the faculty and courses.  
 
 As the first step, you can work in the back end. Follow the instructions given below. 
 
1.  Create an SQL file and write appropriate SQL scripts to create the database, user and its associated database tables as given in Table 1 and Table 2.  
 
1.1 Create a Database: faculty database 
 
1.2 Create user and grant privilege to the created user in the database server for the created database. You have to give your own name for the user and your college id as the password. 
 
1.3 Faculty Table 
 

TABLE1

1.4 Course Table 

Course table

1.5 Import the script file in the database server so that the database will be physically created at the back end. This will help you to store the faculty and course details with its attributes.  
 
2. Once the backend database development is over, you can create and design the client-side interfaces (PHP Web Pages) to do the tasks as stated in the scenario. Here, you can use your creative ideas to design the interface (as you wish) with any appropriate controls for the user input. You can use text boxes, radio buttons, checkboxes, drop-down box, or anything else as you wish to accept the user input values.  
 
2.2 New Faculty Registration                                        
 
2.2.1 Create a Faculty Registration form named ‘facultyYourID.php’ to allow a new user to register into the application. Use appropriate controls to enable the user to input and save the faculty details in the appropriate database table. The form must also enable the user to upload a picture which must be saved in the pics folder. 

 2.2.2 The Email ID must be in the proper format. Otherwise, show any appropriate message.  After successful registration of new user, move to login page. 
 
2.3 Login / Logout                                                                        
 
2.3.1  Create a PHP Login Form named ‘loginYourID.php’ to allow the registered user to login to the application. Use appropriate controls to enable the user to login and the login details must be validated from the appropriate database table.  

2.3.2 Redirect the user to main.php after successful login. Otherwise, show appropriate login error message. 
 
2.3.3 The new users must register first to succeed the login. Therefore, new users should use any appropriate button to go to the registration page. 
 
2.3.4 Create a form ‘logout.php’ and write the appropriate script to redirect the user to login page. While you design the Main.php, you should give a logout link anywhere in the main.php for the user convenience. The user must perform the logout from the Main.php only.  
 
2.4 Add Courses                                                             
 
2.4.1 Create a Course Registration form named ‘courseYourID.php’ to allow a new course to be registered into the application. Use appropriate controls to enable the user to input and save the course details in the appropriate database table. Allow a user to select a Course Name from the list (Graphic Design, Fundamentals of IT, Information Systems). 
 
2.4.2 The Course Code must be in the given format (A-123), as per the following conditions. ? The course code must start with an alphabet, capital letters between A to Z and only 1 letter is allowed. 
 

  • The numbers must be in the range between 1 and 5, and must have 3 digits. 

 
Otherwise, show any appropriate message. 
 
 2.4.3 All fields are mandatory in the course form. Otherwise, show an appropriate  message to enter all the fields. 
 
2.4.4 Redirect the current webpage to main.php when a new course is successfully added into the database. 
 
2.5 Main Page                                                      
 
2.5.1 Create a PHP form ‘main.php’ and write the appropriate PHP script to view al the added course details.  
 
 Note: Main form will be empty without any records for the first time before adding items into it. 
 
2.5.2 Design a button or hyperlinked text for the Delete. Delete the record when you click on the hyperlink or button named ‘Delete’.  
 
2.5.3 Insert a button in the main page to open the course.php form. 

This ITDB201: IT Assignment has been solved by our IT Experts at UniLearnO. 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.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Mia
  • Posted on : May 30th, 2019

Whatsapp Tap to ChatGet instant assistance