Instructions attached
We’re creating a seating chart application for our school. Basically it will let students choose Building Name, Room Number, Date, Time, Number of Columns, Number of Rows, and Seat Number. It will let them input their name and the last 4 digits of their student ID number. It will store that information in a database. Teachers can use that database information to take attendance of their classes, and know where students are sitting. Let Building Name, Room Number, Date , and Time be selected using drop boxes. The dropbox for Time can be one hour increments from 08:00am to 6:00pm. The dropbox for Building Name can consist of Science Building, Arts Building, Business Building, and Math Building. Room Number dropbox can go from 101-110. The teacher wants these to be tables in the database. Whatever software you use for the database, it must be something that will work on my computer. Everything needs to work on my computer. For the interface please try to use html and php, that’s what we’ve been doing in class. Building (buildingname, number of rooms (which will be 10)) Room (room number, buildingname, number of seats, number of seat columns, number of seat rows) Attendee(name, last four id number,) Event(date, time, building name, room number, last 4 digits of student ID , student name, seat number) So here’s an example of what the professor wants it to look like, but he put a note that says to add a way to select building, and add a way to select the number of rows and columns (since different rooms will have different setups). There should also be a button on the page called “Attendance” and when teachers click on it it gives them the option to select the date, building name, and room number and it should return a list of all the students that chose seats in that room. If a student selects a seat, please show that the seat is occupied so that another student in the class can’t choose that same seat. You don’t have to make it look fancy, it can be basic as long as it works. Please let me know if you need clarifications.