University:
Massachusetts Institute of Technology
Course:
15.501/516 | Accounting
Academic year:

2023
Views:

244

Pages:

3
Author:

martinpouliotin8

INTEGRATING INFORMATION SYSTEMS: TECHNOLOGY, STRATEGY, AND ORGANIZATIONAL FACTORS GLOBAL INFORMATION SYSTEMS: COMMUNICATIONS & CONNECTIVITY AMONG INFORMATION SYSTEMS Homework Assignment 4 Question 1. The excerpt below represents data obtained from when ticker symbol INTC is entered (output is slightly reformated). INTEL CORPORATION Symbol Last trade Change Volume INTC 30.06 -0.04 34,154,200 4:00 PM -0.13% a) In class we have referred to such web sites as “semi-structured”. Explain what that means. b) In considering this web site as a database returning database records, what are the 7 field values that are returned by that web page? Give names to each of the fields and briefly (informally) explain the meaning of each (as best you understand them). c) For each of the 7 fields, explain, in your own terms, what context knowledge is needed and indicate what you believe to be the context definitions for each of the 7 fields in this particular example. Clearly state any assumptions that you feel are appropriate. -1- Question 2. This question addresses the issue of schema integration. Assume that the schema below are used by the Sloan Student database, the Sloan Alumni database, and the Career Development Office (CDO) Recruit database. We want to produce an integrated schema. Perform a step-by-step process, similar to Lecture 16. Show the results of each step: (1) identify equivalent entities and attributes, (2) convert attributes to entities, and (3) integrate the two schema. Briefly explain the reasons, justifications, and assumptions behind each step. Sloan Students Database name year (1,2) Address Student Subject # Term Subject Type (home, school, summer) Stree t Previous Degrees City CDO Recruit Database Company Name Addresssds Interview Date Position Student Name Degree (BS, MS, PhD) Year (e.g., 19XX) College Sloan Alumni Database Corporation Alumni Degree -2- Name Name Title Address street Address city Type (BS, MS, PhD) Graduated (e.g., 19XX) Question 3. For this question, let us consider the distributed homogenous SQL database depicted below. HP UNIX SQL POS Code Positio n POSITIONTB IBM 390 Sun Solaris IBM NT SQL SQL SQL Nam e Company ALUMNIT B POS Cod e Company Dat e DATABASES COMPANYTB Let us consider the SQL query to print the names of all alumni that are “vice presidents” of companies that are interviewing on “December 14”. The query might be: select a.Name from alumnitb a, positiontb p, companytb c where p.Position = “vice president” and p.Poscode = a.Poscode and c.Date = “December 14” and c.Company = a.Company a) Explain what “retrieval transparency” means in the context of the above situation. b) Explain what “performance transparency” means in the context of the above situation. c) Describe at least two different ways to accomplish “performance transparency” for the above situation (i.e., two different sequences for processing the query.) Make maximum use of concurrency and explain which steps can be performed concurrently. d) Of the two approaches described above, which one is better? Explain your reasoning and any assumptions made (or information that you would need.) If helpful, make hypothetical assumptions about table sizes, etc. -3-