Please write php and html code justThank you ? create a history pagebased on a history table in a database. To bespecific, you are asked to create a table calledHistory in any DB you want. The table will havethe following information: PatientID (int 10),PatentName (VarChar 150), DoctorID (int 10),DoctorName(VarChar 150), BackgroundCheck(varchar 1000), Diagnosis (varchar 1000),Treatment (varchar 1000).After Creating the DB and the Table describedabove, Fill the table with dummy data, thencreate a PHP that contains two things:1. A dropdown list with all doctor IDs from theDB2. A table listing all history contentsFunctionality:Basically, what you have to do is to make thetable dynamically changing with the change ofthe doctorID dropdown list. You may use AJAX ifyou want.

Given :- in the above question, a statement is mention in the above given question Need to write a…

Answered: write php and html code

Engineering

Computer Science

write php and html code

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....

See similar textbooks

Similar questions

Using the Crow’s Foot Diagrram technique, draw a database design for the attached database.
Write 10 SELECT statements for the database you have implemented.i. 3 of them should use minimum 2 tables.ii. 4 of them should use minimum 3 tables.iii. 3 of them should use minimum 4 tables.
An insurance company needs to store their salespeople’s information who are selling their insurance policies. They already have a database with multiple tables, one of the tables (Salesperson) stores information about each salesperson along with the bonus percent they receive, based on the city where the insurance is sold. The table has the following fields: Salesperson(spID, spName, spBirthDate,spCitySelling, bonusPercent) spID: Unique identification number of the salesperson. spName: Full name of the salesperson. spBirthDate: Birthdate of the salesperson. spCitySelling: The city in which the salesperson is selling the insurance. bonusPercent: The bonus percent received by the salesperson based on the city in which he/she sells the insurance. Each salesperson can sell the insurance in just one city. However, for a city, there can be more than one salesperson appointed. Also, the bonus percent is fixed for each city. For example, all of the salespeople who sells insurance in…
The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientNo, patName, patAddr, DOB)Ward (wardNo, wardName, wardType, noOfBeds)Contains (patientNo, wardNo, admissionDate)Drug (drugNo, drugName, costPerUnit)Prescribed (patientNo, drugNo, unitsPerDay, startDate, finishDate) for CONTAINS nad PRESCRIBED table , which one is primary key and how to create table ?
You are asked to design a database for an University. This particular university has multiple departments. Each department in that university offers one or more courses to the students. All the students are part of a certain department and they take courses in that department. A department has a name, unique number and chairman. The courses have a name, a course number such as ‘311’ , a credit point value, and the year it commenced. A course cannot be identified uniquely with the course number, but the course number is unique for each department. Students have given names, surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course the year and the semester he or she took that particular course is recorded. When he finishes the course , the grade and total marks are recorded. A student can take multiple courses but they are also allowed to drop a semester in that university by taking no courses. Construct an ER diagram using the requirements…
You are asked to design a database for an University. This particular university has multipledepartments. Each department in that university offers one or more courses to the students. All thestudents are part of a certain department and they take courses in that department. A department hasa name, unique number and chairman. The courses have a name, a course number such as ‘311’ , acredit point value, and the year it commenced. A course cannot be identified uniquely with thecourse number, but the course number is unique for each department. Students have given names,surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a coursethe year and the semester he or she took that particular course is recorded. When he finishes thecourse , the grade and total marks are recorded. A student can take multiple courses but they are alsoallowed to drop a semester in that university by taking no courses. Construct an ER diagram usingthe requirements given here.…
The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees SPOT_LENGTH 55 50 20 0 SPOT_PULLTHRU 1 0 0 0 SPOT_ELECTRIC_AMPS 50 50 20 0…
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
A hospital would like to set up a database recording which registered nurse looked after which patient etc. Each registered nurse has a unique nurse ID, and each patient has a unique patient ID, and the following attributes are found for nurses, and patients in the first round of design: NURSE: nurselD, suname, first name, birthdate, dept-code, sex, salary-level PATIENT: patientlD, surname, first name, birthdate, wardlD, sex, admission_date, discharge_date A recent duty list shows the patients that were cared by each nurse in past 2 months, see below for some samples:
Create a class diagram for the BITS Corporation database, as shown in Figure 1-5 in Chapter 1 (see attached image). If you need to make any assumptions when preparing the class diagram, document those assumptions.
Scenario: The owner of Al Musana Hotel would like to have a database tables that will help him manage the clients and rooms in his building. He wants to record the information about his clients and its occupancy. The hotel has three different room types which are available for daily rent only. As the Database Designer, perform the following tasks to help the owner of the hotel: Create the CLIENTS table using the specification below: Table Name: CLIENTS Field Name/ Data Type column name Size Constraints CID Number 8 PRIMARY KEY CName Varchar2 25 NOT NULL Validate to accept Male or Female only Gender Varchar2 10 Address Varchar2 25 Contact Number 15 Стуре Varchar2 15