MIS Questions (5 questions)


MIS Management Information System

Final Examination

12-4-2019 (Wednesday)

Student Name: ___________________________

[Chapter 6. Databases and Information Management]

1. Figure 6.4 defines two tables: PART(Part_Number, Part_Name, Unit_Price, Supplier_Number) and SUPPLIER(Supplier_Number, Supplier_Name, Supplier_Street, Supplier_City, Supplier_State, Supplier_Zip), expressed with Primary Keys underlined and Foreign Key in italic. In this table set up, answer the following questions.

a. For a given Part_Name like Door Lock, we want to know in which State the supplier for the Door Latch would be located. Explain the procedure how the computer finds out the state for the supplier from the two tables.

b. Explain the differences in definitions or rules between Primary Keys and Foreign Keys.


Figure 6-4. Relational Database Tables.

[Chapter 7. Telecommunications]

2. From Figure 7.3, answer the following question.

a. What are the advantages to allow the packets to travel different network routes?

b. If a packet is lost on the way, what layer of communication protocol will be in action? What does it do to recover the lost packet? What impact is made in delivering the message?

Figure 7-3. Packet-Switched Networks and Packet Communications.

[Chapter 11. Managing Knowledge]

3. Open the following file by double clicking, read the case of Designing Drugs Virtually, and answer the following questions.

a. What intelligent technique is similar to the old-fashioned trials and errors method for finding a suitable drug to a disease? What is the similarity and what is the difference between two techniques?

b. Explain why the new method in finding the workable drug from the knowledge of the problematic protein structure is better than the previous trials and errors method?

[Chapter 13. Building Information System]

4. A utility company developed a new billing system that records consumer’s utility consumption and creates monthly bills to the consumers. The existing system is still working correctly but the new system has several enhancements from new technologies. In this situation, what will be the best conversion approach among Parallel strategy, Direct cutover, Pilot study, and Phased approach, to implement the new billing system into actual operation successfully? Provide the reason why you chose the strategy and why other method would not work.

[Chapter 14. Managing Projects]

5. The US Army has planned to develop an intelligent warfighting capability by providing continuous wireless communication capability to update the current battle situation, which opens the way for the warfighters to out-smart opponents. In consideration of its importance, the Army started as a huge sized program that contains numerous projects from small-sized tank development for fast deployment, wireless communications equipment development, software development based on the new concept, logistics system development, to training system development, all at once. The necessary technologies of the combined wireless communications are yet to be developed. Software development was not easy to convert the operational concept into software programming.

a. In this case, what kind of problems or risks would arise as the program proceeds?

b. What approach would you choose to avoid potential risk factors identified above?

Designing Drugs

Virtually 003.pdf