I need help about my Web Development 2 project CIST 2550 [closed]

Part 1 Each team is to create a database with tables of information stored. Table 1 - Class Standing (4 records) Columns for class are id, class, maximum credits, minimum credits Table 2 - Student (At least 10 records) Columns for student are student id, first name, last name, street, city, state, zip, class standing, major Hints - student id will be primary key, first and last name must have value, class standing is foreign key Table 3 - Instructor (at least 3 records) Columns for instructor are employee id, first name, last name, specialty Hints - instructor id will be primary key, first and last name must have value Table 4 - Classroom (at least 3 records) Columns for classroom are id, building, floor, room Hints - id will be primary key, building will be unique, floor has default value Table 5 - Course (at least 3 records) Columns for course are crn, instructor, classroom, day or days, time Hints - crn is primary key, instructor is foreign key, classroom is foreign key Table 6 - Enrolled (at least 6 records) Columns are student, course Hints - student & course together are a primary key, student is foreign key, course is foreign key

Part 2 Each table will have its own webpage to view all records from the database with a current timestamp (date & time) of when the page was viewed and records were retrieved at the very top of the list. Students table will have a page to create new rows from user input. Information will be added the list when all are displayed. Instructors table will have a page to create new rows from user input. Information will be added the list when all are displayed. Classroom table will have a page where you can edit or update the room number of a row from user input. Information will show on list when all are displayed. Course table will have a page where you can edit or update days and time with user input. Information will show on list when all are displayed.

Part 3 Among the pages of the site, the groups

• can make up information, you do not need to have real ids, name or addresses
• database tables and records must have constraints included in table design
• must incorporate html, css, javascript, php and mysql coding, all 5 do not have to be on each page but all 5 must be in the overall website.
• must use functions or procedures to handle some of the coding tasks
• must add some form of error handling, exception handling and debugging (at least one instance of each)

Part 4 Teams are to divide responsibilities among members. There is plenty of work to do including tables creation, row creations, web page creation, testing and review. Keep track of what you worked on and what your teammates worked on. This will be part of your presentation to explain who did what and why. However, if there are errors the entire team will have points deducted because of it, so please do your work correctly and make sure it is all working together as it should. Project submittal should contain the following: Domain Name or Web Page links where information can be found HTML files / PHP files to generate web pages MySQL Scripts for tables creation, table record creation and select statement to show entire contents All within an archive file

I did try to do it , im just stuck

-- Create Class Standing table CREATE TABLE class_standing ( id INT PRIMARY KEY, class VARCHAR(255), maximum_credits INT, minimum_credits INT );

-- Create Student table CREATE TABLE student ( student_id INT PRIMARY KEY, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, street VARCHAR(255), city VARCHAR(255), state VARCHAR(255), zip INT, class_standing INT, major VARCHAR(255), FOREIGN KEY (class_standing) REFERENCES class_standing(id) );

-- Create Instructor table Create Table instructor (

source https://stackoverflow.com/questions/76037720/i-need-help-about-my-web-development-2-project-cist-2550