Need help with an PHP assignment in a course that accounts for 30% of the final mark?

T

Tramaine

New member
I'm a university student that needs help. Have a no good lecturer. I need to get a good grade in the course to graduate. Anyone who can help please...it would be GREATLY appreciated. Here's the questions:

==============
Suppose you have a database with the following ER-model:

Owners table:
PKOwnerNo
FirstName
LastName
MiddleName
NationalID
Address1
Address2
Address3
FK1townCode
TelephoneNo
CellNumber
FaxNumber
EmailAddress

Property Table:
PKGlobalPropertyID
Address1
Address2
Address3
OwnershipType
FK2 townCode
PK GlobalPropertyID

1. Write a database called PM with these tables. [10]
2. Write a PHP/HTML script that presents a user with an interface to populate the above database tables. [15]
3. Write a PHP script that reads the database and produces an object of a class called Properties based on the diagram below. Note that the class Properties is composed of another class called Property. The loadFromDB() methods reads the database tables and creates Property objects and which are stored in an array. [45]
4. Write a PHP/HTML script that uses an object of Properties to extract Property data and display the following in a table: Propert ID, Owner Name, location, owner address and home number phone no.
[35]


(class)Properties:
-PropArray[]:Property
-size:Integer
-capacity()
------------------------
+loadfromDB()
+getID(pos)
+getOwner(pos)
+location(pos)
+ownerAddress()
+getPhoneNo()

(class)Property:
-ID
-Location
-OwnerName
-OwnerAddress
-PhoneContact
-------------------------
+ setID()
+setLocation()
+setOwnerName()
+setOwnerAddress()
+setPhoneNo()
+ getID()
+getLocation()
+getOwnerName()
+getOwnerAddress()
+getPhoneNo()

We use the XAMPP web server with Apache and MySQL.....again please any assistance would be great. Willing to email the assignment if its tables are unclear...Thank You
 
Back
Top