Consider the followingfew relations of Academic systems. 1. Semester( SemNo ,Sem
ID: 3612341 • Letter: C
Question
Consider the followingfew relations of Academic systems.
1. Semester(SemNo,Sem_Dur, Start_Date, End_Date)
2. Professor(VUPid, P_Name, Age, Deptid, CourseCode)
3.Prof_Exp(VUPid,Experience)
4. Department(Deptid, D_Name, Main_Office,HOD)
5. Project(Pid,Title, Start_Date, Due_Date, Prj_Instructor)
6.CoursePre-Req(CourseCode, Pre-requisite)
7. Course(CourseCode, C_Name, Prg_Code)
8. Student(VUSid, Std_Name, Std_Age, Prg_Code, )
9. Program(Prg_Code, Prg_Name, No_of_Sem, Min_CGPA)
10. ProgramDur (Prg_Code , Max_Dur)
A. Need to perform following operations in MS-AccessApplication project
(Go to Toolsmenu FileNewBlank database)
You are requiredto:
I. Createrelations/Tables and the relationships among them inMS Access
II. Create 3data/entry Forms (Student Details, Professor Details, andCourse
Details).
With command buttons:Save, Cancel, Navigation
III. Create aMaster/Detail Form for transactions using SUB forms.
IV. ApplicationMenu
Creating theMainSwitchboard isstraightforward. You go to the Tools
Explanation / Answer
Consider the followingfew relations of Academic systems. 1. Semester( SemNo ,Sem