anyone please help! i have no idea on what PHP is moreover do the coding....
dreamhome.txt
--- PROMPT Creating Table 'BRANCH'
CREATE TABLE BRANCH (
BRANCHNO VARCHAR(5) PRIMARY KEY
,STREET VARCHAR(25) NOT NULL
,CITY VARCHAR(15) NOT NULL
,POSTCODE VARCHAR(25) NOT NULL );
--- PROMPT Creating Table 'STAFF'
CREATE TABLE STAFF (
STAFFNO VARCHAR(5) PRIMARY KEY
,FNAME VARCHAR(10) NOT NULL
,LNAME VARCHAR(10) NOT NULL
,POSITION VARCHAR(15) NOT NULL
,SEX VARCHAR(1) NOT NULL
,DOB DATE NOT NULL
,SALARY INT(6) NOT NULL
,BRANCHNO VARCHAR(5) NOT NULL );
--- PROMPT Creating Table 'CLIENT'
CREATE TABLE CLIENT (CLIENTNO VARCHAR(5) PRIMARY KEY
,FNAME VARCHAR(10) NOT NULL
,LNAME VARCHAR(10) NOT NULL
,TELNO VARCHAR(15) NOT NULL
,PREFTYPE VARCHAR(10) NOT NULL
,MAXRENT INT(10) NOT NULL );
--- PROMPT Creating Table 'PRIVATEOWNER'
CREATE TABLE PRIVATEOWNER (OWNERNO VARCHAR(5) PRIMARY KEY
,FNAME VARCHAR(10) NOT NULL
,LNAME VARCHAR(10) NOT NULL
,ADDRESS VARCHAR(35) NOT NULL
,TELNO VARCHAR(15) NOT NULL );
--- PROMPT Creating Table 'PROPERTYFORRENT'
CREATE TABLE PROPERTYFORRENT (PROPERTYNO VARCHAR(5) PRIMARY KEY
,STREET VARCHAR(15) NOT NULL
,CITY VARCHAR(15) NOT NULL
,POSTCODE VARCHAR(15) NOT NULL
,TYPE VARCHAR(15) NOT NULL
,ROOM INT(3) NOT NULL
,RENT INT(10) NOT NULL
,OWNERNO VARCHAR(5) NOT NULL
,STAFFNO VARCHAR(5)
,BRANCHNO VARCHAR(5) NOT NULL );
--- PROMPT Creating Table 'VIEWING'
CREATE TABLE VIEWING (CLIENTNO VARCHAR(5) NOT NULL
,PROPERTYNO VARCHAR(5) NOT NULL
,VIEWDATE DATE NOT NULL
,COMMENTS VARCHAR(25)
,PRIMARY KEY (CLIENTNO, PROPERTYNO) );
--- PROMPT Creating Table 'REGISTRATION'
CREATE TABLE REGISTRATION (CLIENTNO VARCHAR(5) NOT NULL
,BRANCHNO VARCHAR(5) NOT NULL
,STAFFNO VARCHAR(5) NOT NULL
,DATEJOINED DATE NOT NULL
,PRIMARY KEY (CLIENTNO, BRANCHNO, STAFFNO) );
The DreamHome application must consists of the following functions:
1.Login
The login function allows only the staff to enter the system. The username is the staff's first name, and the password is the staff number. If the user enters the right combination of username and password, the application redirects the user to the main menu. If the user provides the application with the wrong combination, the user will be prompted to enter his/her username and password again. An error message will also be displayed. The application allows the user to attempt login for a maximum number of three times. If the user fails to enter the right combination of username and password after three attempts, the application will stop prompting the user, and informs the user to quit the browser first before making another attempt.
Insert Staff
2.The insert staff function allows only staffs who are managers to insert a new staff member into the database. The manager will provide the application with the information on staff number, first name, last name, position, sex, date of birth, salary and branch number. The application will check for the validity of the information being given. This includes:
•Staff number must be unique;
•Sex must be either 'F' or 'M' only;
•Branch number must correspond with the data in the branch table.
If the information given satisfies the above requirements, the new staff will be inserted into the database. The application displays a success message.
If the information is invalid, then the user will receive a specific error message.
3.Display Viewing Information
The display viewing information function displays the client information along with his/her property viewing information. Each display page should be specific to only one client. The user should be able to scroll to the next client in the database by using the “Next Client” button.
4.Update Staff Information
The update staff information allows each staff to update his/her personal information. The information that can be updated includes position, date of birth, and salary information. For the date of birth, the application must make sure that the date entered is valid. Assume that DreamHome does not hire staff less than 18 years old.
5.Main Menu
Create the Main Menu page (HTML file) that will help the user to navigate between the insert staff, display viewing information, and update staff information functionalities.
