0

hey everyone, i have a problem with normalising my set of data...i am sure it would be easy for alot of you, its jus right now i have a mental block

anyhow its for a yearbook publishing company. the data set is as follows:
schoolCode, schoolName, address, city, state, postalcode, country, telephoneNo, faxno, website, SRID, SRFName, SRLName, SRemail, SRMobile, orderNo, orderDate, deliveryDate, bookAmt, pageAmt, coverType, booktheme, picFormat, articleAmt, photoAmt, eventAmt, priority, orderstatus, taskid, taskname, startdate, duedate, taskstatus. %completed, empNo, empfName, emplname, jobtitle, empmobile, empemail

ok itslike this...
School has many school reps (SR)
School usually orders one yearbook but i cant have a one to one relationship..so school to order is one to many
An employee is assigned to more than one order
A order generates a schedule than has many tasks so order to task is one to many.
i think thats about it

any help???? pleassseee.....i cant seem to move from UNF to 1NF
this is what i had for 1NF
Order (orderno, schoolcode, address, city, state, postalcode, country, telephoneNo, faxno, website, empno, empname, orderdate, deliverydate, bookamt, pageamt, covertype, booktheme, picformat, articleamt, photoamt. eventamt)
Order Schedule (orderno, taskid, taskname, startdate, duedate, taskstatus, %completed)
School Reps (schoolcode, SRID, SRFname, SRLname, SRemail, SRMobile, SRemail)

2
Contributors
2
Replies
3
Views
10 Years
Discussion Span
Last Post by fatihpiristine
0

i guess everybody nobody seems to be clueless or jus dont wanna help..thanks anyway

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.