Microsoft Interview Question for Interns


Country: India




Comment hidden because of low score. Click to expand.
0
of 0 vote

Extract entities from both systems and determine database tables whose rows are to be merged. (Assume both have the same normal form 3NF for simplicity). Merge columns, and then data and so on. Ensure that the foreign keys etc. are mapped correctly.
Example, Table A (a1, a2) and B(b1,b2,b3) are to be merged and column mapping is a1->b1 and a2->b2. The merged table shoud have C(a1b1, a2b2, b3)

- Noobie July 29, 2013 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

To actually merge and hope for a correct understanding of the data. The solution would be to think of a Federated Databasesystem. The databases exists independently, but are aware of each other and can communicate with each other through an interface.

This will save both company money and time by merging alot of data into a databasesystem.

If we did merge, the problem would be how the datas understand each other at all? This is a typical heterogeneous problem that might occur.

- Khiem-Kim Ho Xuan March 04, 2014 | Flag Reply
Comment hidden because of low score. Click to expand.
0
of 0 vote

To actually merge and hope for a correct understanding of the data. The solution would be to think of a Federated Databasesystem. The databases exists independently, but are aware of each other and can communicate with each other through an interface.

This will save both company money and time by merging alot of data into a databasesystem.

If we did merge, the problem would be how the datas understand each other at all? This is a typical heterogeneous problem that might occur.

- Khiem-Kim Ho Xuan March 04, 2014 | Flag Reply
Comment hidden because of low score. Click to expand.
-2
of 2 vote

Huh?

- Anonymous August 01, 2013 | Flag Reply


Add a Comment
Name:

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.

Books

is a comprehensive book on getting a job at a top tech company, while focuses on dev interviews and does this for PMs.

Learn More

Videos

CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Learn More

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Learn More

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.

Learn More