Answered step by step
Verified Expert Solution
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.
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
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