Assignment

icanusesomehelp

assignment2_feedbackwk3.docx

Home >Information Systems homework help >Assignment

Business Rules

· STUDENT can be contacted via preferred CONTACTPREF

· CONTACTPREF can be Text Message, Phone Call, or Email

· STUDENT mobile number can be used when CONTACTPREF is Text Message

· STUDENT email address can be used when CONTACTPREF is Email

· STUDENT phone number can be used when CONTACTPREF is Phone Call

· STUDENT can be ONCAMP or OFCAMP

· STUDENT can have one STUDENT_MOB mobile number

· STUDENT can have one STUDENT_PHN land line number

· STUDENT can have one STUDENT_EML

ER Model

Sample Data

-STUDENT

· First Name

· Last Name

· Email Address

· Phone Number

· Mobile Number

-LOCATION

· On Campus

· Off Campus

-CONTACTPREF

· Text Message

· Phone Call

· Email

STUDENT_FN	STUDENT_LN	STUDENT_EML	STUDENT_PHN	STUDENT_MOB	LOCATION	CONTACTPREF
Vince	Gomez	[email protected]	3039645194	7196615175	OFF	Text Message
Amy	Gomez	[email protected]	3039645138		ON	Email
Derrick	Ashton	[email protected]		7196614444	ON	Text Message
Ben	Sabados	[email protected]	7206264573	6264567890	OFF	Phone Call
Laura	Davis	[email protected]	8189996453	4871112345	OFF	Email

Feedback 2

Business Rules

STUDENT can be contacted via preferred CONTACTPREF

CONTACTPREF can be Text Message, Phone Call, or Email

STUDENT mobile number can be used when CONTACTPREF is Text Message

STUDENT email address can be used when CONTACTPRE

F is Email

STUDENT phone number can be used when CONTACTPREF is Phone Call

STUDENT can be ONCAMP or OFCAMP

STUDENT can have one STUDENT_MOB mobile number

STUDENT can have one STUDENT_PHN land line number

STUDENT can have one STUDENT_EML

ER Model

Sample Data

STUDENT

First Name

Last Name

Email Address

Phone Number

Mobile

Number

LOCATION

Business Rules

 STUDENT can be contacted via preferred CONTACTPREF

 CONTACTPREF can be Text Message, Phone Call, or Email

 STUDENT mobile number can be used when CONTACTPREF is Text Message

 STUDENT email address can be used when CONTACTPREF is Email

 STUDENT phone number can be used when CONTACTPREF is Phone Call

 STUDENT can be ONCAMP or OFCAMP

 STUDENT can have one STUDENT_MOB mobile number

 STUDENT can have one STUDENT_PHN land line number

 STUDENT can have one STUDENT_EML

ER Model

Sample Data

-STUDENT

 First Name

 Last Name

 Email Address

 Phone Number

 Mobile Number

-LOCATION