Java开发网 - 英国一公司招聘考题(1)

Topic: 英国一公司招聘考题(1)

1.英国一公司招聘考题(1)

Posted by: brolinuk
Posted on: 2006-02-03 13:15

Part One

Given the following 2 databases, on different servers:

The accounts database
account table
-----------------------------
id Number
customer_name Varchar2
revenue Number

The customer database
custermor table
-----------------------------
id Number
name Varchar2
address Varchar2
Country Varchar2

contact table
--------------------------------
id Number
sex Char
email Varchar2
customer_id (fk) varchar2
department varchar2

and knowing that the accounts database uses the name from the customer table as the identifier;

Create a data loading application that conforms to the following simple specification.

You are provided with a ‘connector’ object
Connector
----------------------
connect(): void
load(data: java.util.map):boolean

which handles connection and loading of the data – (connect has a tendency to throw Exceptions. Load will return true if it succeeds)

The user will want to specify the databases from which the data will come.
Take the data from these two databases, create a map where the key is “database.table.fieldname” and the value is the value of the column, one map for each row.

Also, the user wants to enable loading from a file for testing purposes.

The data needs to be validated – we don’t want to load anything with a zero revenue or an invalid email address, and we want to convert univ. to university in any of the customer names.

Make sure the application logs any invalid data in a way that a data admin will be able to locate and correct it.

2.Re:英国一公司招聘考题(1) [Re: brolinuk]

Copy to clipboard

Posted by: brolinuk
Posted on: 2006-02-03 13:22

我正在做.. 不过有点不明白The user will want to specify the databases from which the data will come. 这句是指用户在运行程序时可以选择所链接的数据库吗, 还是说两个数据库应当在编程过程中就链接好..

还有Also, the user wants to enable loading from a file for testing purposes.这句话指调用什么文件? 数据库文件? 不是本身已经提供两个数据库了吗..

总之大家有兴趣的话, 可以一起探讨一下, 我想每个人的答案都不会一样, 看看都有什么思路..

3.Re:英国一公司招聘考题(1) [Re: brolinuk]	Copy to clipboard
Posted by: ranchgirl Posted on: 2006-02-03 13:37 Obviously, this is impossible 英国一公司招聘考题, this is homeowrk!!!! There is a good place to discuss such problem: 海外电脑中国同学会

4.Re:英国一公司招聘考题(1) [Re: brolinuk]

Copy to clipboard

Posted by: brolinuk
Posted on: 2006-02-03 14:07

Part Two

The business users then decide that they want a Web front-end to the customer and account databases, covering simplified data entry.

You will need three data entry screens
1)  customer
2)  customer contact
3)  create account for customer

the page flow being: create or find a customer, add or update contact, add or update account.

The customer screen will show the contacts for that customer, and the accounts for that customer, with the tools to add or update the customer, contact or account.

On the addition or update of an account you will want to ‘fire’ the data loading application written previously, ensuring the integrity of the system.

The reporting screen will allow you to query by customer, contact or account. Searching will give you a list of customers; clicking on the name will take you through to the customer screen.

Other reports required are:
1)  a list of all customers and their contacts (regardless of whether they have contacts)
2)  a list of all customers without contacts
3)  a list of the customers with a count of contacts for that customer
4) a count of customers by country

This application will have to be password protected.

Outline your design for this application – illustrate this with snippets of java code as you think necessary. Point out any choices you make and why you made them.

Show the SQL you would use in each reporting screen.

Provide the DDL for the schema (in whichever dialect you use)

For the contact table, say whether or not each field is a candidate for a key and why.