您所在位置：主题：求助,面试的时候碰上两个难题,高人指点一下
nikkor1001
[专家分：0] 发布于 2007-05-25 02:03:00
自己本来没有啥数据库基础,结果碰到这么两道题,郁闷...
Question 3:
There is a new project to acquire a new data feed from a vendor and add it to a database to enhance coverage for a neglected market. The data feed consists of a daily set of 6 files, one primary file with one row per main object, 4other files which relate to the main file, and a secondary object file which is loosely related to the first. The data is in plain text.
What sort of information would you expect to see in the feed specification from the vendor? List at least eight. Give the reason why each piece of information is valuable to you in planning the implementation, and what the consequence of not having it is. What types of things would you do to protect yourself from errors in the vendor data? How would you verify the vendor feed specification once you started receiving data? What ramifications are there if the data vendor had an XML offering instead of the plain text file? In what conditions would you prefer XML delivery?
Question 4:
You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has a variable amount of columns and a variable amount of rows. The goal is to produce a display which is user friendly from a typical browser screen.
For example, consider a system for a gift wishlist. The main object is a person and different categories of items are stored in separate tables (movies, books, clothing, etc.) and has columns specific to that category of item. So the movies table might have columns like title, format, language, etc. But certainly the clothing table would have a different set of columns. A given person might have 0 or more items from any category on their wishlist. This report would show all the items on a given person's wishlist, and display all columns for each category.
Write the pseudocode to format the data for the report in the generic case (do not use the example above). What aspects of the implementation will make it most usable for the analysts who will need to reference this data every day to validate client inquiries?
Question 3:
There is a new project to acquire a new data feed from a vendor and add it to a database to enhance coverage for a neglected market. The data feed consists of a daily set of 6 files, one primary file with one row per main object, 4other files which relate to the main file, and a secondary object file which is loosely related to the first. The data is in plain text.
What sort of information would you expect to see in the feed specification from the vendor? List at least eight. Give the reason why each piece of information is valuable to you in planning the implementation, and what the consequence of not having it is. What types of things would you do to protect yourself from errors in the vendor data? How would you verify the vendor feed specification once you started receiving data? What ramifications are there if the data vendor had an XML offering instead of the plain text file? In what conditions would you prefer XML delivery?
Question 4:
You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has a variable amount of columns and a variable amount of rows. The goal is to produce a display which is user friendly from a typical browser screen.
For example, consider a system for a gift wishlist. The main object is a person and different categories of items are stored in separate tables (movies, books, clothing, etc.) and has columns specific to that category of item. So the movies table might have columns like title, format, language, etc. But certainly the clothing table would have a different set of columns. A given person might have 0 or more items from any category on their wishlist. This report would show all the items on a given person's wishlist, and display all columns for each category.
Write the pseudocode to format the data for the report in the generic case (do not use the example above). What aspects of the implementation will make it most usable for the analysts who will need to reference this data every day to validate client inquiries?