I need the two .php files 1- DisplayStudentGrades.php2- addnewStudentwithgrades.phpUrgent please ITCS333 Lab 8: PHP MySQL/Prepared Statements/TransactionsCreate StudentsDB database in MYSQL server that with the following 2 tables as follows:Table 1: StudentsTable 2: GradesSidUniversityIDNameMajorint, Primary Key, AutoIncrementvarchar(8), Uniquevarchar(50)varchar(50)GidSidCourseCodeCreditsint, Primary Key, AutoIncrementint, Foreign Keyvarchar(10)intCourseGrade varchar(4)Students table hold students info, while Grades table holds all the courses/grades taken by students. Add as many records in thetwo tables as sample.YOU MUST USE PREPARED STATEMENTS TO SOLVE THE FOLLOWING EXERCISESImplement the following PHP scripts as required below:1. displayStudentGrades.php: Design HTML form with method GET that asks the user to input a studentID No Input Validation isrequired). The script should display student's name and major. In addition, all courses codes with their grades should be displayedin HTML table followed by its Cumulative GPA, Credits Passed and Credits Registered at the bottom of the TABLE. Highlight thecourse row by red if it's F grade. Appropriate error message if the student's id doesn't exists.2. addnewStudentwithgrades.php: the script should obtain all the required student details using HTML form including courses codes,credits and grades (Tip: ask the user how many courses he want to enter first and then design a dynamic form asking for user andcourse details). YOU MUST USE TRANSACTION AND PREPARED STATEMENT for inserting using records (No Input Validation isrequired).

The task involves creating a MySQL database named StudentsDB with two tables: Students and Grades.…

Answered: two .php files 1-…

Engineering

Computer Science

two .php files 1- DisplayStudentGrades.php 2- addnewStudentwithgrades.php

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

mysql> CREATE TABLE School ( -> SchoolNumber INT PRIMARY KEY, -> Name VARCHAR(50), -> Address VARCHAR(100), -> PhoneNumber BIGINT, -> Built DATE, -> Size INT -> );ERROR 1046 (3D000): No database selectedmysql> SELECT * FROM School;ERROR 1046 (3D000): No database selected
ITCS333 Lab 8: PHP MySQL/Prepared Statements/Transactions Create StudentsDB database in MySQL server that with the following 2 tables as follows: Table 1: Students Table 2: Grades Sid UniversityID Name Major int, Primary Key, Auto Increment varchar(8), Unique varchar(50) varchar(50) Gid Sid CourseCode Credits int, Primary Key, Auto Increment int, Foreign Key varchar(10) int CourseGrade varchar(4) Students table hold students info, while Grades table holds all the courses/grades taken by students. Add as many records in the two tables as sample. YOU MUST USE PREPARED STATEMENTS TO SOLVE THE FOLLOWING EXERCISES Implement the following PHP scripts as required below: 1. displayStudentGrades.php: Design HTML form with method GET that asks the user to input a studentID No Input Validation is required). The script should display student's name and major. In addition, all courses codes with their grades should be displayed in HTML table followed by its Cumulative GPA, Credits Passed and…
Assume you have StudentsDB database stored in MYSQL server that contains the following 2 tables as follows: Table 1: Students Table 2: Grades int, Primary Key, Auto Increment Sid Gid int, Primary Key, Auto Increment UniversityID varchar(8), Unique Sid int, Foreign Key Name varchar(50) CourseCode varchar(10) Мajor varchar(50) Credits int CourseGrade varchar(4) *** Note: Students must use PDO to access MYSQL DB, MYSQLI isn't allowed *** Implement the following PHP scripts as required below: 1. displayStudentGrades.php: the script should display student's name and major. In addition, all courses codes with their grades should be displayed in HTML table followed by its Cumulative GPA, Total Credits Passed and Total Credits Registered at the bottom of the TABLE. Highlight the course row by red if it's F grade. The studentlD is received using HTTP GET method from an HTML form. 2. addnewStudentwithgrades.php: the script should obtain all the required student details using HTML form including…
name PERSON address salary fee EMPLOYEE STUDENT thesis RESEARCH TEACHING POST GRAD UNDER GRAD Year = 4 FINAL YEAR LECTURER TUTOR SUPERVISOR project courseno PART II: University Database in MYSQL • Create a database and its tables and constraints based on the relational model of PART I. • You can use my slides and any other resources to complete this exercise. • Submit the SQL statements you used to create the database and its tables (you can copy/paste directly from the mysql console).
Write Mysql code for: The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.
ormulate the following queries in Structured Query Language SQL The following tables form part of a database held in an RDBMS: Employee (empNo, fName, lName, address, DOB, sex, position, salary, deptNo) Department (deptNo, deptName, mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) where Employee contains employee details and empNo is the key. Department contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager foreach department. Project contains details of the projects in each department and the key is projNo (notwo departments can run the same project). WorksOn contains details of the hours worked by employees on each project, and empNo/ projNo/dateWorked form the key. Formulate the following queries in Structured Query Language SQL List all the details of employees who are female and born after 1990. List employee numbers and names of all…
Using MySQL Workbench, Create a database named “bank” with the following tables: Customer with filds: customer_id (integer) name (string) Account with fields: account_id (integer) balance (float) type (one of ‘savings’, ‘checking’, ‘cd’) Customer_Account id (integer) cust_id (integer) acc_id (integer) Populate the database with data of your choice. Note 1: Export the database into a self-contained file named bank1.sql before you continue. Note 2: Using Apache NetBeans, create a Java project that connects to the bank database.
Answer the following prompts 1The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. 2The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID…
branch(branchhame, branch+citysassets} customer (HD, Customer name, customer street, customer city) loan loan number branch_name, amounty borrower(ID; loan_number account (account_number, branch name, balance)e depositor (HDs account number)- Figure le Consider the bank database in Figure 1, where the primary keys are underlined. Each branch might have many loans or accounts, associated with borrowers or depositors, respectively. Construct the following SQL queries for this relational database. 1. Find the name of each branch that has at least one customer who has an account in the bank and who lives in the "Harrison" city. Make sure each branch name only appears once. 2. Find the ID of each customer who lives on the same street and in the same city as customer "12345". (1) Please use "tuple variables". e (2) Please use "derived relations" or “with". 3. Find the ID of each customer of the bank who has an account but not a loan. 4. Find the total sum of all loan amounts for each branch…
Indexing Consider a relational database that consists of the relational tables created by the following CREATE TABLE statements: CREATE TABLE PART( P_PARTKEY NUMBER(12) NOT NULL, P_NAME VARCHAR(55) NOT NULL, P_RETAILPRICE NUMBER(12,2) NOT NULL, CONSTRAINT PART_PEKEY PRIMARY KEY (P_PARTKEY) ); CREATE TABLE SUPPLIER( S_SUPPKEY NUMBER(12) NOT NULL, S_NAME CHAR(25) NOT NULL S_NATIONKEY NUMBER(12) NOT NULL, S_PHONE CHAR(15) NOT NULL, CONSTRAINT SUPPLIER_PKEY PRIMARY KEY (S_SUPPKEY) ); CREATE TABLE PARTSUPP( PS_PARTKEY NUMBER(12) NOT NULL, PS_SUPPKEY NUMBER(12) NOT NULL, PS_SUPPLYCOST NUMBER(12,2) NOT NULL, CONSTRAINT PARTSUPP_PKEY PRIMARY KEY (PS_PARTKEY, PS_SUPPKEY), CONSTRAINT PARTSUPP_FKEY1 FOREIGN KEY (PS_PARTKEY) REFERENCES PART(P_PARTKEY), CONSTRAINT PARTSUPP_FKEY2 FOREIGN KEY (PS_SUPPKEY) REFERENCES SUPPLIER(S_SUPPKEY) ); Determine what index should be created to improve the performance of the queries listed below in the best possible way. Consider each one of the…
Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date M EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Dno WORKS ON Essn Pno Hours M PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints Q2// Write SQL statements that carry out the following tasks: 1-alter the employee table to add column city of 20 characters. 2- alter the employee table to apply the following business rule The minimum salary is 3000 and maximum salary is 10000 3- insert sample data in each table . 4- display a list of each employee SSN, Name and Salary. 5- display a list of each employee SSN , Name and Salary for employees working in department no 2.
Write Mysql code The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science