normalize this data  (st_Id, St_Name, St_Major,St_Dept, Int_date,
Int_Time, Interviewer_No, Interviewer_Name,
Employer_Name, Room_No, Bldg_Name)

---

Request for Question Clarification by mathtalk-ga on 29 Jul 2003 21:26 PDT

Hi, zam1-ga:

In order to "normalize" a collection of data elements, one must
possess an understanding of the functional dependencies among the
items.  If you could explain the context in which these data elements
are assigned values, it might help get the analysis started.

regards, mathtalk-ga

---

Clarification of Question by zam1-ga on 30 Jul 2003 15:25 PDT

Data in the table i posted first is from this paragraph.

The career center of a university keeps information about students’
interviews with prospective employers in the following table. For each
interviewer the canter is keeping the following information:
interviewer number (assigned by the center), name, and the name of the
employer
he/she represents. The same interviewer number is used every time the
person visits campus to interview students. To prevent scheduling
problems each Interviewer is assigned specific room for the whole day
of his or her interviews with students. Each student can have more
that
one interview in a day. 

Then the question is

Given the sample of data, select the PK and draw the dependency
diagram of the 1NF. Label the dependencies.
Starting with the dependency diagram drawn for problem 1, create a set
of dependency diagrams that meet 2NF, 3NF, and BCNF
requirements. Label each table resulting from the transformation from
one set of NFs into the next set of the NFs.

If its not clear pls inform me.

Regards

---

Clarification of Question by zam1-ga on 30 Jul 2003 15:56 PDT

I have included the table with data


St_No   St_Name       St_Major      St_Dept              Int_Date   Int_Time 
300245  Sam Kim     Data Mining   ComputerInfo. Systems  10/14/02    9:00AM
                                                         10/15/02    10:00 AM
                                                         10/16/02    10:00 AM 
                                                         10/16/02    11:00 AM
Interviewer_No     Interviewer_Name  Employer_Name      Room_No   Bldg_Name
1001              Alice B. Vandrof     Accenture        HbH3007   Hamburg Hall
1002              Andrew Jones         Intel            WH15      Warner Hall
1010              Gregory Simon        Siebel           WH17      Warner Hall
1005              John Conelly         McKinsey         WH15      Warner Hall


311357      Jim Smith       Marketing Marketing/Management  10/14/02 11:00 AM 
                                                            10/14/02 1:00 PM 
                                                            10/15/02 9:00 AM 
                                                            10/16/02 11:00 AM

1005  John Conelly      McKinsey                WH15    Warner Hall            
1001    Alice B.          Vandrof Accenture    HbH3007      Hamburg Hall
1002    Andrew Jones      Intel                WH15         Warner Hall
1010    Gregory Simon     Siebel               WH17         Warner Hall


319989   John Lee      Marketing Marketing/Management       10/14/02 10:00 AM 
                                                            10/15/02 9:00 AM 

1001   Alice B.         Vandrof Accenture       HbH3007           Hamburg Hall
1005   John Conelly      McKinsey               WH17              Warner Hall


324258  Joe Madera       AI Computer Info. Systems           10/14/02 11:00 AM
                                                             10/14/02 10:00 AM
                                                             10/ 15/02 10:00AM 

1001      Alice B.        Vandrof Accenture      HbH3007     Hamburg Hall
1005     John Conelly        McKinsey            WH15        Warner Hall
1005      John Conelly       McKinsey            WH17        Warner Hall