Instructions:
Answer all questions. Note that some questions
consist of multiple parts. Read the questions carefully.
1.Your state government has hired you to design a database that will track its researchers. Information of interest includes researchers name, title, position as well as university name, location, enrollment, and research interests. Each researcher is associated with only one institution, and each researcher has several research interests. Draw an entity relationship diagram (ERD) for this situation
(12points).
2.
Consider a Web form that a student would use to input student information and resume information into a career services application at your university. Sketch out how this form would look and identify the fields that the form would include. What types of validity checks would you use to make sure that the correct information is entered into the system?
(12 points)
3.Suppose you have been hired by a tools and parts retailer to lead the conversion from one Word processor to another in the organization. Develop a conversion strategy for this scenario. You have also been asked to develop a conversion strategy for the retailers new online ordering system. How would the second conversion strategy be similar to or different from the one you developed for the word processor?
(12 points)
4.
Supposing you handle administrative support for a small chain that sells computer hardware and software and specializes in personal service. The company has four stores located at malls and is planning more. Each store has a manager, a technician, and between one and four sales reps. The owners want to create a personnel records database and asked you to review a table that one of the co-owners designed. The co-owner had suggested fields for store number, location, store telephone, manager name, and manager home telephone. She also wants fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones.
Based on this case, indicate what you think the co-owners suggested design
might have looked like? Analyze it using the normalization concepts you learned in this course.What do you think of the design and why? What would you propose?Explain clearly (12points)
5.(a) Visit your universitys Web home page and navigate through several of its Web pages. Evaluate the extent to which they meet the principles of user interface design you studied in this course.
(b)Compare and contrast batch processing and online processing. Describe one application that would use batch processing and one that would use online processing (12 points) For this Question go to your search engine and put UMUC login my user is Awebb39 password BOtt7085
6. As a systems analyst at a company reputable for manufacturing air conditioning units, you have been selected to lead a team that is developing a new production scheduling system. The project is now in the application development stage. Unit testing has been completed, and you are in the final stages of integration testing. Your manager is eager to implement the new
application ahead of schedule and asked if you could trim system testing from two weeks to three days; and use a direct cutover method instead of the parallel changeover method that originally was planned. Provide a detailed explanation of your view(12points).
7.Briefly answer the following:(28points)
a. If, as a project manager, you feel that programming is falling behind schedule, should more programmers be assigned to the project? Why or why not?
b. Explain three basic steps involved in managing organizational change?
c. What is denormalization? Briefly describe a situation in which denormalization would be valuable.
d. During what step in the SDLC would you recommend interface evaluation to be performed and why?
e. What is the difference between alpha testing and beta testing?
f. How would you explain the difference between the
cardinality and the modality of a relationship between two entities to your friend who is a nontechnical person?
g. Explain what is meant by an attribute in a data model. How should an attribute be name
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]