CSC584 Project Proposal PDF

Preview

Summary

SUBMISSION OFCSC584 ENTERPRISE PROGRAMMINGPROJECT PROPOSAL (10%)NAME : NOH AFIQ BIN MOHD HILMISTUDENT ID : 2020985243PROJECT TITLE : EasyBoxDATE OF SUBMISSION :SIGNATURE :I CERTIFY THAT THIS ASSIGNMENT IS MY OWN ORIGINAL WORK AND MATERIALSHAVE NOT BEEN COPIED FROM ANY OTHER WORK (PUBLISHED OR OTHERW...

Description

SUBMISSION OF CSC584 ENTERPRISE PROGRAMMING PROJECT PROPOSAL (10%)

NAME

: NOH AFIQ BIN MOHD HILMI

STUDENT ID

: 2020985243

PROJECT TITLE

: EasyBox

DATE OF SUBMISSION

:

SIGNATURE

:

I CERTIFY THAT THIS ASSIGNMENT IS MY OWN ORIGINAL WORK AND MATERIALS HAVE NOT BEEN COPIED FROM ANY OTHER WORK (PUBLISHED OR OTHERWISE) WITHOUT ACKNOWLEDGEMENT IN THE TEXT. I AM FULLY AWARE OF THE PENALTY OF PLAGIARISM.

Note: Submit soft copy of proposal in PDF and source code in ZIP file via Google Classroom.

CSC584 Enterprise Programming

1.1

Database Schema

2

CSC584 Enterprise Programming

The following will describe the tables. 1.2

STAFF Attribute

Description

Type

Staff ID

VARCHAR

staff_name

Staff Name

VARCHAR

staff_email

Staff Email

VARCHAR

staff_ic

Staff IC Number

VARCHAR

staff_phoneNum

Staff Phone Number

VARCHAR

staff_pass

Staff Password

VARCHAR

Description

Type

Message ID

INT

Message

VARCHAR

staff_id

1.3

PK

MESSAGE Attribute message_id

PK

message

1.4

staff_id

FK1

Staff ID

VARCHAR

customer_id

FK2

Customer ID

VARCHAR

Description

Type

Item ID

INT

item_tracking

Tracking Number

VARCHAR

item_courier

Courier Company

VARCHAR

item_da

Date Arrive

VARCHAR

item_dc

Date Collected

VARCHAR

item_type

Item Type (etc; package, mail)

VARCHAR

item_status

Status of item (Taken or Not)

VARCHAR

ITEM Attribute item_id

PK

3

CSC584 Enterprise Programming

1.5

staff_id

FK1

Staff ID

VARCHAR

cust_id

FK2

Customer ID

VARCHAR

Description

Type

Customer ID

VARCHAR

cust_name

Customer Name

VARCHAR

cust_email

Customer Email

VARCHAR

cust_ic

Customer IC Number

VARCHAR

cust_phoneNum

Customer Phone Number

VARCHAR

cust_pass

Customer Password

VARCHAR

Description

Type

CUSTOMER Attribute cust_id

1.6

STUDENT Attribute cust_id

1.7

PK

PK, FK Customer ID

VARCHAR

stud_status

Status of Item

VARCHAR

stud_program

Student Program

VARCHAR

Description

Type

LECTURER Attribute cust_id lect_faculty

PK, FK Customer ID Faculty of the Lecturer

4

VARCHAR VARCHAR

2.1

Storyboard

2.2

Login [Insert Screenshot here]

Field Name

Mandator

Input Type

Description

y

2.3

e.g. Student Id

Y

Text Box

Student Id

e.g. Name

Y

Text Box

Student Name

e.g. Address

Y

Text Area

Student Address

e.g. Email

Y

Text Box

Student Email

e.g. Phone No

N

Text Box

Student Phone No

E.g. Register [Insert Screenshot here]

Field Name

2.4

Mandatory Input Type

Description

e.g. Student Id

Y

Text Box

Student Id

e.g. Name

Y

Text Box

Student Name

e.g. Address

Y

Text Area

Student Address

e.g. Email

Y

Text Box

Student Email

e.g. Phone No

N

Text Box

Student Phone No

Input Type

Description

E.g. Add Order [Insert Screenshot here]

Field Name

Mandator y

e.g. Student Id

Y

Text Box

Student Id

e.g. Name

Y

Text Box

Student Name

e.g. Address

Y

Text Area

Student Address

e.g. Email

Y

Text Box

Student Email

e.g. Phone No

N

Text Box

Student Phone No...