Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i want help for these new requirements (first and second photo) and i put my master page and site map from my pervious sheet (sheet
i want help for these new requirements (first and second photo) and i put my master page and site map from my pervious sheet (sheet 6)
Open the previous website (SHEET6) and do the following: - Create KSU Database which contains Three tables: - The first table represents a list of colleges in KSU. The table is entitled College and has two attributes: college code and college name. For example, one record might be CBA for the college code and College of Business Administration for the college name. The college code is the primary key. - The second table is entitled Department and contains a college's departments. The table has three attributes - the college code, department code and department name. The department code attribute is the primary key. For example, one record might be CBA for the college code, MIS for the department code and Management Information System for the department name. - The third table is entitled Courses and contains a department's courses. The table has three attributes - the department code, course code and course name. For example, one record might be MIS for the department code, MIS 366 for the course code and Web-based application for the course name. - Make sure to add foreign key constraints whenever it is suitable. - Fill your three tables with at least 3 records, these records should be true and understandable values, not dummy values. - In HomePage.aspx, create form that allow user to insert college code and name in the table 'College'. - Add two dropdown lists and a Grid View to collegeDeptCourses.aspx. - The first dropdown list contains the college names. The college names have to be retrieved from the College table. - Based on the user's selection from the first drop-down list, the second drop down list contains the departments' name for the selected college. - Insert Grid View to display the courses for the selected department via retrieving data from the Courses table. Your output should be similar to this
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started