一道逻辑题

chenchaoyi

实在是看不懂题目， 看起来好像是一道数据库的题目。 请懂得同志帮忙解决一下。并给个简单的解释


A payroll report is produced for each pay period that shows:
•        The amount paid by each department for each of three classes of employees
•        The amount paid by each division for each of its departments
•        The total payroll for each division of the company

Which of the following alphabetical input sequences will minimise the data stored by the program?
1)        Class within Department within Division
2)        Division within Department within Class
3)        Employee within Department within Division
4)        Employee within Class within Division

chenchaoyi

Can someone please help?

goldenapple

I choose 3, just my feeling...

jungle

按这道题本身来讲，是很明显的5个层次的对象：

Company -> Division -> Department -> Class -> Employee

报表只需要做到Class层，所以不需要Employee级别的输入。不过，我是不懂“alphabetical input sequences” 究竟是什么意思。要我看，答案应该很明显是 1 。

不过我从来没有做过类似的题目，不敢说有什么把握。仅供楼主参考。

chenchaoyi

谢谢你们的回答，jungle 你的分析很有道理。alphabetical input sequences 意思是（我认为）这四个答案是按照字母顺序排列的（以第一个字母）

C-->D-->E-->E

我开始选的是4。错了。 我后来仔细看了看，觉得选一。 因为其他几道题很简单。所以我觉得这道题应该不会很复杂，主要是理解问题

还有就是，中介要我去雇主那里再做一个30-45分钟的逻辑和问题解决测试。说什么通过了才会有面试。

我申请的工作是一个Junior developer. 我不知道这样的测试会有多难。 还有有没有同志知道那已有这样类似的测试我可以先练习以下

谢谢

kawara

我选1。

2看起来不对，department 是within division的。

3，4 不需要这样的数据粒度。

月亮

原帖由 chenchaoyi 于 2007-3-9 10:32 发表
谢谢你们的回答，jungle 你的分析很有道理。alphabetical input sequences 意思是（我认为）这四个答案是按照字母顺序排列的（以第一个字母）

C-->D-->E-->E

如果按字母顺序，3和4应该换一下。

月亮

对题目要求不太理解，我选4

[ 本帖最后由 月亮 于 2007-3-9 11:17 编辑 ]

jl162401

是说如何输入数据存储最小，可以得到上述报表结果吗？

那么就是three classes detail data with department and devision,我选一

chenchaoyi

原帖由 月亮 于 2007-3-9 11:15 发表
对题目要求不太理解，我选4

我开始选的是4。中介告诉我错了

jenny1999

原帖由 jungle 于 2007-3-9 07:22 发表
按这道题本身来讲，是很明显的5个层次的对象：

Company -> Division -> Department -> Class -> Employee

报表只需要做到Class层，所以不需要Employee级别的输入。不过，我是不懂“alphabetica ...

赞成！！！

jl162401

个人觉得这么考别人有点过分，其实就是看你的英语好不好

chenchaoyi

有没有人知道 哪里有这样类型的测试，根据中介给我的下面的Tips，我想应该都是多选题

The best way to attack this test is to cover up the multiple choice answers that they provide.....then do the question, get your own answer and then compare it to the answers on offer.....if you get bogged down on one question, just move on to the next. Divide the time you have by the amount of questions you have to ensure that you know how much time you should spend on each question....time yourself on this .

4ever

原帖由 chenchaoyi 于 2007-3-8 23:45 发表
实在是看不懂题目， 看起来好像是一道数据库的题目。 请懂得同志帮忙解决一下。并给个简单的解释


A payroll report is produced for each pay period that shows:
•        The amount paid by each departm ...

同意 jungle 的观点，应该是1
•        The amount paid by each department for each of three classes of employees
•        The amount paid by each division for each of its departments
•        The total payroll for each division of the company

报表的条件里面
... by each dept for each of three classes
... by each division for each of its dept
... for each division

所以有 class, dept, division 的数据就够了。至于alphabetical input sequences是值数据的存储顺序，不会影响到data size，只会和查询的效率相关，应该和本题无关的

jingsun

looks like 1