relationship

[lenni]

A corporate database has a one-to-many relationship between its branch
offices and its employees. The Atlanta branch, which currently has 50
employees, is relocating. Where do you enter the new branch address and phone
number?

In the employee record of the Atlanta branch manager
In the employee record of every Atlanta branch employee
In the Atlanta record in the Branch Office table
All of the above

My answer is "In the Atlanta record in the Branch Office table"
Not sure if im right tho, what are your thoughts?

 

[John Spencer]

If the branch that everyone is relocating to is a new office then you need
to create a new branch office in the Branch office table and then update
each employee record to point to the new office.
If the office that everyone is relocating to already exists then you need to
update each employee record to point to the "new" branch location.

The employee record should contain one field - WorkLocation (or something
like that) that stores a copy of the primary key value in the Branch office
table.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Keith Wilby]

My answer is "In the Atlanta record in the Branch Office table"
Not sure if im right tho, what are your thoughts?

My immediate thought is "why does this guy exepct everyone else to do his
homework?"

 

[IndianSummer]

My immediate thought on reading your message Keith, is how offended I am by
it, on behalf of everyone in this community who has worked to create a
*supportive* environment, where people can come to get *help*.

 

[IndianSummer]

I agree with you and John.

If the Atlanta branch is still essentially the "Atlanta branch", just with a
new address, then yes, you just need to change the address of that branch in
your branch table.

I also agree with John's statement that the employee table should contain
only one field relating to branch, ie. the BranchID, or whatever the primary
key field is called in the branch table.

That field would only need to be changed if the employee changes the branch
at which they are working, ie. from Atlanta to LA or whatever.

Hope we have helped with your "homework" ;-)

 

[lenni]

Thank you John and IndianSUmmer for your help, I really appreicated, I only
start learning access a week ago and the lecture gave me questions that I
have never dealt with before.

To Keith, Im not trying to get people to answer my question. I have stated
what my answer is, and I wanted to know if I was on the right track.

 

[Keith Wilby]

My immediate thought on reading your message Keith, is how offended I am
by
it, on behalf of everyone in this community who has worked to create a
*supportive* environment, where people can come to get *help*.

You're offended on behalf of everyone? How can you assume that everyone is
offended? There's a subtle difference between asking for help (of which I
provide plenty, which of course you'd know if you'd done *your* homework)
and asking for the answer to an exam question. How is anyone supposed to
learn anything if they're simply given the answer?

Hmmm ... only 4 posts by "IndianSummer" according to my search. QED.

 

[Keith Wilby]

To Keith, Im not trying to get people to answer my question. I have stated
what my answer is, and I wanted to know if I was on the right track.

But you didn't state *why* you thought it was correct, you could have chosen
one at random and probably did.

Q - What is the answer to Pi, 3.14159265, 1000 or 20. I think it's 1000,
what do you guys think?

You wanted the answer on a plate. You and anyone else can get as "offended"
as you like about it, I don't like cheats.

 

[IndianSummer]

You are welcome lenni. Good luck with learning Access