Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A school director hires you as a programmer and asks you to code for a self-calling php page. Aim of this page is to ask
A school director hires you as a programmer and asks you to code for a self-calling php page. Aim of this page is to ask for the student number and to present the academic record sheet for that student. But note that while presenting the academic record sheet, different HTML tables should be used per year and per semester. Note that appropriate messages should be displayed in the case where student number not found. (10 Points) Sample output: 1 RDBMS information: RDBMS address: localhost Db UserName: school Db Password: spass Table Name: coursestaken Structure of the Table: Field name Type(size) Null Additional Properties studentNo varchar(8) No Primary key academic Year varchar(4) No Primary key semester varchar(6) No Primary key courseCode varchar(7) No Primary key Student No: 930298 Academic Year 2019 Semester Spring Course Code Grade CMPE212 CMPE224 B CMPE232 A CMPE242 A EE240 C+ Comments May be 6 or 8 digits just 4-digit year sample: 2020 List of all possible values: FALL, SPRING, SUMMER Seven characters Sample: IEC327 List of all possible values: A, A-, B+, B, B-, C+, CC, D, D, D,E, NG grade varchar(2) Yes Academic Year 2020 Semester Fall Course Code Grade CMPE325 A- CMPE333 B+ CMPE 341 B+ MATH373 ECON101 A Within this database table we have a composite key formed from four fields "studentNo", "academic Year","semester" and "courseCode". A school director hires you as a programmer and asks you to code for a self-calling php page. Aim of this page is to ask for the student number and to present the academic record sheet for that student. But note that while presenting the academic record sheet, different HTML tables should be used per year and per semester. Note that appropriate messages should be displayed in the case where student number not found. (10 Points) Sample output: 1 RDBMS information: RDBMS address: localhost Db UserName: school Db Password: spass Table Name: coursestaken Structure of the Table: Field name Type(size) Null Additional Properties studentNo varchar(8) No Primary key academic Year varchar(4) No Primary key semester varchar(6) No Primary key courseCode varchar(7) No Primary key Student No: 930298 Academic Year 2019 Semester Spring Course Code Grade CMPE212 CMPE224 B CMPE232 A CMPE242 A EE240 C+ Comments May be 6 or 8 digits just 4-digit year sample: 2020 List of all possible values: FALL, SPRING, SUMMER Seven characters Sample: IEC327 List of all possible values: A, A-, B+, B, B-, C+, CC, D, D, D,E, NG grade varchar(2) Yes Academic Year 2020 Semester Fall Course Code Grade CMPE325 A- CMPE333 B+ CMPE 341 B+ MATH373 ECON101 A Within this database table we have a composite key formed from four fields "studentNo", "academic Year","semester" and "courseCode
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