Systems Analysis and Design. Opening slide. Harry J. Rosenblatt College of the Albemarle. Welcome. Introductions About me About you About the course Nine instructional units – four today and five tomorrow
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
In the strategic planning process, a company’s
purpose, vision, and values shape its mission statement, which
in turn leads to goals, objectives, business operations, and
business results that affect company stakeholders.
Sample Answer to Project 3 on page 631
Sample Answer to the Ethical Question example in Unit 3
Prescription Drug Label
Read Case in Point 3.3 on page 103 and answer the questions in the final paragraph. Explain your reasons.
Study the Lightfoot Industries case on page 129. Then prepare a task list similar to Figure 3-17 on page 110. Using the task list, create a PERT chart. Use sticky notes to show task durations and the critical path. Sample answer (handout).
1. Prepare a list showing all tasks and their durations.
Contact participants 1 day
Obtain approval 5 days
Arrange meeting room 4 days
Prepare agenda 11 days
Prepare information packets 4 days
Create visual aids 8 days
E-mail participants 1 day
Conduct JAD sessions 5 days
2. Analyze the fact situation carefully to determine which tasks are concurrent, and which ones are dependent on other tasks.
Place the name of the process in a heading at the top left.
Enter the conditions under the heading, with one condition per line, to represent the customer status and availability of products.
Enter all potential combinations of Y/N (for yes and no) for the conditions.
Place an X in the action entries area for each rule to indicate whether to accept or reject the order.
Data and Process Modeling tasks
Study Figure 5-22 on page 215. List all the things wrong in this diagram.
Study the Claremont School case on page 235. Perform Tasks 1, 2, and 3. Sample answer (handout).
Object Modeling Tasks
Study the Pleasant Creek Bookstore case at the bottom of page 272. List all objects, attributes, and methods. Sample answer.
Identify possible use cases & actors.Sample answer.
Agile Modeling Task
Study Figure 1-29 on page 23. You also can do research on the Web. Is the Agile approach really meaningful, or is it just a fad?
Read Discussion Topic 3 on page 672. Explain your answer, and provide an example of a real-life situation.
Read Project 2 on page 672. You will do a net present value analysis of two lease proposals to see which one would be less expensive. To get you started, you will use an Excel spreadsheet template, so all you have to do is add the formulas and values. The adjustment factors you will need are in the table on page 667. Sample Answer (handout).
Read Discussion Topic 4 on page 672. What does your team think, and why?
ORDER (ORDER-NUM, ORDER-DATE, (PRODUCT-NUM, PRODUCT-DESC, NUM-ORDERED))
STUDENT (STUDENT-NUMBER , NAME, CREDITS, GPA, ADVISOR (COURSE-NUM, DESC, CREDITS, GRADE))
STUDENT (STUDENT-NUMBER, NAME, CREDITS, GPA, ADVISOR, COURSE-NUM, CREDITS, GRADE)
The repeating group has been removed by creating a separate record for each instance of a certain student taking a certain course. Now, all fields do depend on the primary key. But there is a problem: The primary key is NOTUNIQUE, and a properly designed table MUST have a unique primary key!
SOLUTION: Break the table into three separate tables, one for STUDENT, one for COURSE,
and one for GRADE.
SOLUTION: Break the table into three separate tables, one for STUDENT, one for COURSES, and one for GRADE. Then ALL fields will be dependent on the primary key – the WHOLE key.
STUDENT(STUDENT-NUMBER, NAME, CREDITS, GPA, ADVISOR-NUMBER, ADVISOR-NAME)
COURSE(COURSE-NUMBER, COURSE-DESC, NUM-CREDITS)
Notice that in each table, all fields are functionally dependent on the primary key.
But there is still a problem:
At least one field is also dependent on another non-key field.
SOLUTION: Create a separate table for that field, with its own primary key.
Notice that ADVISOR-NUMBER and ADVISOR-NAME have been moved to a separate table, and linked with a common field – ADVISOR-NUM.
Now, all fields are functionally dependent on the primary key, the whole key, and nothing but the key!
ADVISOR (ADVISOR-NUMBER, ADVISOR-NAME,ETC.)
Read SWL Team Task 1 on page 444. Can your team summarize the idea of normalization in three or four minutes, using plain English and simple examples?
Read Case in Point 9.1 on page 406. Draw an ERD for TopText Publishing. Sample answers for Tasks B and C (handout).
Read Project 3 on page 437. Using the sample ERD, design a table for each TopText Publishing entity, and add three sample records to each table.