Reference no: EM133424182
Visual Studios
b) a Windows application. Add a top level menu item called InitializeDB with ten menus underneath it for populating the tent tables. Each menu under InitializeDB reads data from a text file and inserts a record (or updates it) in the corresponding table. When you click on the menu, user is prompted to select the text file via an OpenFileDialog. The ten text files for each table are comma separated and appear as shown below:
Students.txt
123451,Bill,Baker,45 Main Street,Bridgeport,CT,203-555-1234 123452,Mark,Mathews,25 Pine Street,Bridgeport,CT,203-555-7765 123453,Sally,Simpson,45 Oak Street,Stratford,CT,203-555-1242 123454,Cindy,Wiiliams,55 Center Street,Milford,CT,203-555-7741 123455,John,Jacobs,22 Rose Street,Bridgeport,CT,203-555-4420
Departments.txt
1001,Computer Science 1002,Computer Engineering 1003,Electrical Engineering 1004,Math 1005,Technology Management Professors.txt 10001,John,Jacobs,20 University Avenue,Bridgeport,CT,203-555-1134 10002,Sara,Sorento,28 Hall Street,Bridgeport,CT,203-555-3362 10003,Hong,Wong,46 Main Street,Bridgeport,CT,203-555-1222 10004,David King,55 Meadow Street, Shelton, CT,203-777-8126
Courses.txt
CPSC 410,Java Programming,3,Intermediate level Java Programming,1001 CPSC 411,Advance Java,3,Advance level Java Programming,1001 CPSC 440,Windows Programming,3,Intermediate level C# Programming,1001 CPSC 555,Web Application Development,3,Web Development,1001 Math 301,Differential Equations,3,Solving Differential Equations,1004 ELEG 443,Digital Signal Processing,3,Digital Signal Processing and its Applications,1002
CoursePrerequisites.txt
CPSC 555,CPSC 410 CPSC 555,CPSC 440 ELEG 443,Math 301 CPSC 411,CPSC 410 CoursesOffered.txt CPSC 410,Fall 2016,35,28,Dana 123,10001 CPSC 411,Fall 2016,30,27,Tech 116,10001 CPSC 440,Fall 2016,45,44,Dana 123,10002 Math 301,Fall 2016,25,18,Carlson 152,1004 CPSC 555,Fall 2016,40,37,Tech 116,10002
CoursesTaken
123451,CPSC 440,Spring 2016,B123451,CPSC 410,Spring 2016,B+ 123452,CPSC 410,Spring 2016,C123453,Math 301,Summer 2016,A
StudentCourses
123451,ELEG 443,Fall 2016 123454,CPSC 410,Fall 2016 12345,CPSC 411,Fall 2016 123454,CPSC 440,Fall 2016
StudentMajors
123451, 1001 123452,1001 123453,1002 123454,1003 123455,1004
ProfessorDepartments
10001,1001 10002,1002 10003,1001 10004,1003
c) a top level menu item called "Student Management". It will have two submenus in it.
1. View Students Allows you to select a department, and view Students in the department via a DataGridView.
2. View Student Grades Allows you to search a student via a text box and then display the courses taken by the student and the grades obtained in a DataGridView.
d) Create a top level menu item called "Course Management". It will have two sub menus it it.
1. View Courses Offered A semester drop down will show semesters. Then depending upon the semester selected in the drop down, the courses being offered in that semester will be shown.
2. View Enrollments A course number drop down will show the courses being offered in the semester being selected in another drop down. Then based on the two drop downs, you will show the enrollment in the course selected. The course number drop down should dynamically change when the semester drop down changes the semester.