Create a website registration form to obtain a user’s first name, last name and e-mail address. In addition, include an optional survey ques- tion that asks the user’s year in college (e.g., Freshman). Place the optional survey question in a details element that the user can expand to see the question.

use the code below to create tabels. include screenshots CREATE TABLE PRICE ( PRICE_CODE                NUMBER(2,0)  PRIMARY KEY, PRICE_DESCRIPTION   VARCHAR2(20)  NOT NULL  , PRICE_RENTFEE                      NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) );   CREATE TABLE MOVIE ( MOVIE_NUM    NUMBER(8,0)  PRIMARY KEY, MOVIE_TITLE  VARCHAR2(75) NOT NULL, MOVIE_YEAR  NUMBER(4,0)  CHECK (MOVIE_YEAR > 1900), MOVIE_COST   NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE    NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE MEMBERSHIP ( MEM_NUM                   NUMBER(8,0) PRIMARY KEY, MEM_FNAME   VARCHAR2(30) NOT NULL, MEM_LNAME   VARCHAR2(30) NOT NULL, MEM_STREET  VARCHAR2(120), MEM_CITY                   VARCHAR2(50), MEM_STATE    CHAR(2), MEM_ZIP                     CHAR(5), MEM_BALANCE           NUMBER(10,2) ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1); INSERT INTO PRICE VALUES (2,…

design a basic patient registrtion form. This form should utilize all of the major form elements we've covered including text boxes, check boxes, radio buttons, select lists, and text areas. At least one of each of these should be utilized on the form and feel free to use others. It also should include sections to input: Patient Information - Name, Address, Phone numbers, Alergies Family Histroy - Space for at least three relatives, how they are related, and at lease two medical conditions per person Prescription History - Name of medication, dosage, how frequently it is taken, etc. Medical History - Space to enter previous medical conditions including when the condition first appeared, and whether it is an ongoing problem This form should then submit to a php page that will process the information and display it formatted as a 'medical chart'. Information about the patient should be placed at the top with some sort of separator to segment it from the rest of the information. Note: You…

Excel date fields have the date to the right of the decimal point, and time to the left of the decimal point. True False

Create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, state, and zip code for each customer. Each customer’s name should be listed in order of last name followed by first name, separated with a comma, and have the column header “Name.” The city and state should be listed as one column of output, with the values separated by a comma and the column header “Location.”

Create a College Admission Letter follow the format below Name of Student Address of Student City,State and Zip Code Date Name of Admission Head College Name College Address City,State and Zip Code Body Sincerely, Signature of the Student Printed Name Don't worry about the info ill edit it just put something

Create a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text “NOT REFERRED” if the customer wasn’t referred to JustLee Books by another customer or “REFERRED” if the customer was referred.