•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 456,526 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,807 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 908 | Replies: 2
 |
•
•
Join Date: Sep 2007
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Help in normalising please!!! 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)
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)
Last edited by nattya : Sep 29th, 2007 at 5:07 pm.
•
•
Join Date: Sep 2007
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
i guess everybody nobody seems to be clueless or jus dont wanna help..thanks anyway
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Help on General Best Practices for Table/Database Design (Database Design)
Other Threads in the Database Design Forum
- Previous Thread: Database Security question
- Next Thread: Web based database login page question
