Answered step by step
Verified Expert Solution
Link Copied!

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)

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems For Advanced Applications 15th International Conference Dasfaa 2010 International Workshops Gdm Benchmarx Mcis Snsmw Diew Udm Tsukuba Japan April 2010 Revised Selected Papers Lncs 6193

Authors: Masatoshi Yoshikawa ,Xiaofeng Meng ,Takayuki Yumoto ,Qiang Ma ,Lifeng Sun ,Chiemi Watanabe

2010th Edition

3642145884, 978-3642145889

More Books

Students also viewed these Databases questions