Retrieve Update Delete Student Advisor Application Budget Carnegie Grant CRUD Create Retrieve Update Delete Student When student submits application StudentPID SName StEmail ID: 196425
Download Presentation The PPT/PDF document "Create" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
CreateRetrieveUpdateDeleteStudentAdvisorApplicationBudget
Carnegie Grant CRUDSlide2
CreateRetrieveUpdateDeleteStudentWhen student submits applicationStudentPID, SNameStEmail, StAddress, if changeArchive after student leaves SILSAdvisorWhen advisor’s name appears on an applicationAdvNameAdvEmail, if changeneverApplicationWhen student submits applicationStudent PID, AdvPID, AppDateDate fields, as approvals are gainedArchive after student leaves SILSBudgetWhen student submits applicationAppIDTravelReq, SuppSurvReq, PostageReq, SubjCompReq, if change
Archive
after student leaves SILS
Carnegie Grant CRUDSlide3
Carnegie Grant ER Exercise SolutionSlide4
Carnegie Grant SchemaStudent (StudentPID, StName, StEmail, St Address, StDegree)Advisor (AdvPID, AdvName, AdvOfficePhone, AdvEmail)Application (AppID, StudentPID, AdvPID, AppDate, AdvApproveDate, AdvRating, ResDescr, DeanApproveDate)Budget (BudgetID, AppID, TravelReq, SuppSurvReq, PostageReq, SubjCompReq)