Saturday, 20 December 2008

3. C.R.U.D

Analyzing the system using C.R.U.D technique

Course:
Create: Assuming this is created by using courses record system
Read: Courses will be read by student and staff 
     Student: 
             Using div tag; 
             Script: unit_student.php 
    Staff: 
             Using div tag; 
              Script: unit_staff.php 
Using AJAX to make syncrounouse call to the server and get courses for particular student or staff. The script will listed all courses which registered to particular student or staff 
Update: Assuming this is created by using courses record system
Delete: Assuming this is created by using courses record system


Student:
Create: Creating student by using table tag and php script to record student detail in database. script: registerStudentvalidation.php
Read: Read student detail by using table and php script to get data form database. script: adminPage_studentList.php
Update: update student by using table and using php script to get data from database and update data back to database. script: studentList.php
Delete: delete student by using table and php script to delete particular student. Script: deleteStaffOrStudent.php


Unit:
Create: Assuming this has been created from Unit record system
Read: Read unit by using div tag. student will be able to get all units which they have registered as well as staff. php script will be use to perform this functionality
Update: Assuming this has been created from Unit record system
Delete: Assuming this has been created from Unit record system


Materials:
Create: Create using table and script will create material for particular unit. the restriction apply only particular staff which has been register could create or upload material.
Read: Read material using "div" tag which will print all material specify to particular unit. read material using php script which enable reading data from database and shows in html file. more than one script will be created which student view and staff view
Update: Update material using table and php script which enable the update function to be functional. Script: editContentValid.php
Delete: delete material using table to show all the list of material and delete button will be avalible next to the material. the script will detele particular material according to user input.


Staff:
Create: Creating staff by using table and php script to record staff detail in database as well as asign staff to units. script: registerStaffvalidation.php
Read: Read staff detail by using table and php script to get data form database. script: adminPage_stafftList.php
Update: update staff by using table and using php script to get data from database and update data back to database. script: stafftList.php
Delete: delete staff by using table and php script to delete particular staff. Script: deleteStaffOrStudent.php


Admin:
Create: Assuming this has been created from university record system
Read: Assuming this has been created from university record system
Update: Assuming this has been created from university record system
Delete: Assuming this has been created from university record system




No comments: