MGMT 38200 Management Information Systems Fall 2016 Sample Final Exam Question Points Available 1 8 2 10 3 10 4 6 5 10 6 6 Total 50 Points Received Name (please print): _________________________________ Signature: _________________________________ PUID: __________________________________ Instructions You have 90 minutes to finish this exam. There are 10 pages in total. Please check if you have all of them. Answer each question in the space provided after the question. Limit your answer to the provided space. This is a closed-book, closed note, closed computer exam. No electronics are to be used or held while taking the exam, including cell phones, pagers, pdas, or other similar devices. 1. IT Security and Privacy, Computer Forensics (8 points) (a) Describe the process of using symmetric cryptography. (4 points) (b) The main components of information security are Confidentiality, Integrity, and Availability. Choose two and describe what they are. (2 points) (c) In class we discussed the weakest link in any system, what is it?(2 points) 2 2. Competitive Advantage and Industry Analysis (10 points) (a) In class we discussed the two ways that the Internet has helped companies utilize the focus strategy. The first is that it allows them to reach a wider range of consumers. What is the second way that we discussed in class? (2 points). (b) What is \"stuck in the middle\"? (2points) (c) In terms of Porter's Five Laws, give 2 features that would make an industry attractive and describe each one. Be specific (3 points) 3 (d) What is the difference between the sell-source-ship model compare to the traditional buy-hold-sell model? (3 points) 4 3. E-Commerce and Long Tail case (10 points) (a) List TWO potential advantages and TWO potential disadvantages that Click & Order model has compare to Brick & Mortar model. (4 points) (b) In the case covered in class, how does the \"Long Tail\" phenomenon relate to Amazon? Does Amazon gain advantages or disadvantages from the \"Long Tail\" phenomenon? How? (4 points) 5 (c) What is the role of \"inventory\" in the long tail case? (2 points) 4. Lock-in and Network Externalities (6 points) (a) What is a technology lockin? Give an example of a technology lock in? (3 points) (b) Is Circuit City decision to let DIVX player compatible with DVD disc a good decision or a bad decision. Why? (3 points) 6 5. Internet Advertising and Auction (10 points) (a) Choose two of CPM (Cost per thousand), CPC(Cost per click), and CPA (Cost per action). Describe the two you have chosen in relation to Internet advertising. (3 points) (b) Describe the process of real time bidding. (3 points) 7 (c) What is the main difference between Dutch auction and English auction? (4 points) 6. Social Network and Web 2.0 (6 points) (a) What is the main difference between Web 2.0 and Web 1.0? (2 points) 8 (b) What is the theory of Six degrees of Separation? (4 points). 9 OTHER QUESTIONS: - In class we discussed the notion of \"Path to Profitability\" (P2P) and how e-commerce companies such as Pet.com and etoys.com failed because they failed to understand it. As discussed in class, what did pet.com and etoys.com fail to understand about online consumers? - Design an ERD for the following scenario. You DON'T need to include any other attributes which are not mentioned. We are in the phase of converting the ERD to a table. You NEED to show foreign keys in each entity. (14 points) ABC University wants to keep track of all the courses they offer. They want to keep track of the course ID (unique identifier), course name, and course credit hours. They also want to keep track of students. They want to keep student ID (unique identifier), Social Security Number (also a unique identifier), and student name (composed of first and last name), and student skills. Student skills is a multivalued attribute, (it could be Excel, Word, or Access or any combination of the three). A student can be registered for a minimum of zero courses, and can register for as many courses as they want. A course can have zero to many students registered. The University also wants to keep track of the grade that each student received in each specific course that they registered in (basically a grade attribute). 10