Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Step 1: Develop the following database in your MySQL. The name of database is std_reg_ter_fa20. Your focus during implementation should be three dotted red circles.

image text in transcribedimage text in transcribed

Step 1: Develop the following database in your MySQL. The name of database is std_reg_ter_fa20. Your focus during implementation should be three dotted red circles. (40 mins) Student Registration Terminal FA 20 course_registration PK students teachers PK ld 1 PK id FK1 student_id FK2 course_id FK3 semester_id FK4 teacher_id Is Studying? name registration_no phone_no address name emplyee_no phone_no address email courses semesters PK id PK id name name credit_hours 1 Step 2: Develop complete CRUD operation for Students'. Data of 'Students should be added, updated, deleted and shown through forms developed using W3.CSS Framework. (60 mins) Step 3: Use W3.CSS Framework to develop data entry pages of Teachers' and 'Course Registration'. You MUST NOT forget that a course registration involves Students, Teachers, Courses and the Semester. Add data in the Courses and Semester table directly in the MySQL database. (60 mins) Step 4: When user presses the 'Submit button on the Course Registration form, data should be stored in the database. A new page should open showing data of Course Registration and Teachers in two different tables placed side-by-side. This page should also have a Delete button and a text box at the end. (60 mins) Step 5: When user enters ID of teacher in the text box and presses the Delete button, the record of Teacher should be deleted from the database. This page should refresh so that latest data of Course Registration and Teachers should be shown in the respective tables. (60 mins)

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

Step: 3

blur-text-image

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

Microsoft Visual Basic 2008 Comprehensive Concepts And Techniques

Authors: Gary B. Shelly, Corinne Hoisington

1st Edition

1423927168, 978-1423927167

More Books

Students also viewed these Databases questions

Question

Advance warning and an explanation for the layoff.

Answered: 1 week ago