7.1 Output Design Prototypes
7.1.1 Design and implement (with data that is important to the management) 3 reports for management, 1 detailed, 1 exception, and 1 summary (one by each student).
Each report design description & layout:
Title- (Pick a Pet)
Purpose What need does it fulfill
Data Fields list from the database
Calculated fields
Grouping/Sorted (for detailed report) or Exception subset (for Exception report)
Screen-Paper Layout design
Show the sql query that was needed to fetch the data for each report. (not needed for summary report)
Detailed Report
Be sure the detailed one has grouping, and subtotals per each group.
Exception Report
Be sure the exception is not just a smaller version of the detailed report, nor the same as your exception list query.
7.1.2 Design 2 queries for any employee, 1 single query and 1 exception list query
7.1.3 Design 1 output transaction document (e.g. receipt).
7.2 Input Design Prototypes
7.3 Producing User Interface Prototypes- How do the functions of the system fit together for the user
7.3.1  Design the menu function tree for the major different user/actor types:
Show all functions that each user type will be able to request. For each user interface, show the order in which the main window and the sub-windows appear in a typical interaction.
7.3.2  Design the search equipment criteria window (by EquipID, or type, or ??)
7.3.3  Design the main User menu interface screen as a sample for all non-search screens

That is the assignment , we are suppose to be using sql and php but I have no clue how to code in that language and this assignment is due at midnight.
The title of Our Project is Pick A Pet. I will attach files below of more info.