PHP database assignment

PROJECT ASSIGNMENT 3

INSTRUCTIONS

1. Create database tables that can store the following information:

Profile Information:

• First Name

• Last Name

• Phone Number

• Email

• Address

Order header:

• Order Number

• Submitted Date

• Delivered Date

• Ship to Name

• Ship to Address

• Total Price

Order Detail:

• Item ID

• Item Short Description

• Item Long Description

• Quantity

• Price

2. Populate the DB tables with test data as follows:

a. Two users who have same first name but different last name (for example Joe Smith and Joe Doe). Each one has two submitted orders with two or three items in each order (this will support deliverable B.1)

b. One user who has a profile without submitted orders (this will support deliverable B.5)

c. Two users who have profiles with multiple orders (2-3) and multiple items (2-3) in each order (this will support deliverable B.2)

3- Create a web page (Order Lookup Page) that enables the end-users to lookup orders by entering either the user’s name or order number. The page shall return results as follows:

a) Searching by name:

• A list of matching names (first_name last_name) will be displayed.

• If the user clicks on the name, profile information and a list of his/her order numbers are displayed.

• If the user clicks on the order number, order header and details are displayed.

b) Search by order number: the page shall return the following:

• profile information

• Order header information

• Order details

DELIVERABLES:

A. A database model (Microsoft Visio, Erwin, etc.) that depicts the relationships between your tables, save as a picture or pdf.

B. A screen recording of the following test cases:

1. Searching by Name: use only a first name that will return two matching names (for example search for Joe and return Joe Smith and Joe Doe). Click on Joe Smith and have two orders with two/three items in each order displayed when clicking on the order number.

2. Searching by Order Number: Order header information is displayed and a list of the items in the order. When the order item is clicked, display the item details.

3. Searching by a name that has no results

4. Searching by order ID that has no results

5. Searching by name that returns one name match. When clicking on the name, Profile is displayed but the user does not have any orders submitted.

C. Export your DB tables into a file (PDF). Make sure the tables’ contents are included.

D. Zip your code/solution into a file

E. Submit one zip file named (First Name Last Name_Project Assignment 3.zip) that contains A,B, C and D.