ITEC: Topic: Internet Shopping Sites (Clothing, Shoes, Books, Music, Or Others
Purpose
The purpose of the individual system analysis and design project is to demonstrate student’s ability to apply the knowledge learned in this course to a real-world project.
Topics Suggestions
1.The system analysis and design project must be realistic and it will be done using techniques covered in this course. The list of topics suggested for this project is as follows:
a) Ticket purchase system (airline, train, cruise, concert, or others)b) Internet shopping sites (clothing, shoes, books, music, or others)c) Local real estate agency systemd) Rental system (car, video, or others)e) Warehouse management systemf) Student record systemg) Banking systemh) Insurance purchase system (life, medical, homeowner, or others)i) Credit card management systemj) Library circulation system
2.The above list is meant to be suggestive and if you have an idea about a specific topic, please consult with me early to determine if it is suitable for the course.
3.You have to select and submit the project topic for instructor’s approval by the end of Week 2.
Project Deliverables
The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, students are required to use the MS Project software for their project schedule.
The deadline for the Individual Project can be found in the schedule section of the class syllabus.
The following layout format covering a title page and all three phases is recommended for the project.
Title page (project name, author, and date)
Phase 1: Requirement analysis
A. Problem definition
B. Issues
C. Objectives
D. Requirements
E. Constraints
F. Description of the proposed system
G. Logical model design
1. Data flow diagrams• Context diagram• Diagram 0o Diagram 1 (Diagram 1 is optional)• Descriptions of processes in each diagram2. Descriptions of outputs/inputs/performance/security or controls
H. Specific requirements, if any (interface, operational, resource, performance, etc.)
Phase 2: System and database design
A. User interface
Design an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.
1. How data will be input to the system?• The physical layout for each input• The input design and procedures2. How data will be output from the system?• The physical layout for each output• The output design and procedures
B. Data design
Develop a plan for data organization, storage, updating, and retrieval.
1. Database design • Database tables with their attributes should be presented• Primary key(s) should be identified in each table, if any• Three steps of normalization should be included.2. Entity-relationship diagrams3. Data file storage and access
C. System architecture
Determine the architecture of the system as Web-based interface, client/server architecture, Internet/Intranet interface, network configuration, etc.
Phase 3: Project plan
A list of tasks or activities needed for implementing the proposedsystem
Estimating completion time and costs
A project schedule for performing those activities (Gantt charts or PERT charts)
Note that there is no other required software package except the MS Project software in this ITEC-630 course. As a result, you are only required to use the MS Project software to handle the scheduling partof the project and for other parts, you can use any word editing software or any drawing tools software.
Individual Project Rubric
The individual project will account for 20% of your total points possible and students should use the APA format for the format of the individual project reports. The following rubric will be used when grading your individual project:
Qualities and Criteria
Poor [0-80)
Good [80-90)
Excellent [90-100]
Format/Layout
▪ Presentation of the text and structuring of text in an organized and thoughtful manner▪ Follows phases requirements
(Weight 20%)
Follows poorly the requirements related to format and layout.
Follows for the most part all the requirements related to format and layout. Some requirements are not followed.
Closely follows all the requirements related to format and layout.
Content/Information
▪ All phases of the project are addressed and contents in each phase are adequate▪ The project proposal is technically sound and realistic▪ The project is done using techniques covered in this course▪ MS Project software is used in the project plan▪ The project design can be implemented in reality▪ Activities and information are constructed in a logical pattern among phases to support the solution
(Weight 70%)
The project does not cover all phases and it is not done for the most part with techniques discussed in this course. The required software is used poorly in the project plan. The project proposal is hardly realistic and the tasks proposed can not be done easily in reality. Activities and information among phases are badly designed and do not support the solution.
The project covers all phases with adequate contents in each phase for the most part and it is done with some techniques discussed in this course. The required software is used in the project plan for the most part. The project proposal is relatively realistic and some proposed tasks can be done in reality. Activities and information among phases for the most part are designed to support the solution.
The project covers all phases with adequate contents and it is done with techniques discussed in this course. The required software is used in the project plan. The project proposal is realistic and the tasks proposed can be done in reality. Activities and information among phases are designed to support the solution.
Quality of Writing
▪ Clarity of sentences and paragraphs▪ No errors and spelling, grammar and use of English▪ Organization and coherence of ideas▪ APA style compliance
(Weight 10%)
The project is not well written, and contains many spelling errors, and/or grammar errors and/or use of English errors. The project is badly organized, lacks clarity and/or does not present ideas in a coherent way and it is somehow APA style compliance.
The project is well written for the most part, without spelling, grammar or use of English errors. The project is for the most part well organized, clear and presents ideas in a coherent way and it is somehow APA style compliance.
The project is well written from start to finish, without spelling, grammar or use of English errors. The project is well organized, clear and presents ideas in a coherent way and it is completely APA style compliance.
University of Maryland University College
ITEC 630
Final Exam
The Final is due by midnight (11:59 PM) Sunday (4-26-2020).
This is an open-book individual exam comprised of 5 questions.
Guidelines:
· Put your name in the exam.
· You should submit your exam to your assignment folder in WebTycho in a MS-Word, MS-RTF, PDF or ASCII file. Please scan your file against viruses before submitting.
· Please keep the full text of the question as part of your answering sheet.
· Be as clear and objective as you can in all questions and be sure you are answering what is asked.
· Justify all your numerical answers and answer all the questions using your own words. Show all your work, including how you found your answer (this is very important and essential to have your answer graded appropriately!).
Make sure that you read, acknowledge, and follow the following rules
Rules:
· The exam is to be taken in accordance with the UMUC Honor Code – e.g., do not collaborate or seek help from anyone else.
· This is an open-book exam but you are only allowed to use your textbook and information posted in our classroom. Please do not use any other sources that are not listed in our classroom. For example, you can refer to our class lecture notes and all links posted in the lecture notes but you should not search the Web for information to solve exam questions.
· You should not discuss exam questions with other students or anyone else. If you have any questions about the exam, you can send me e-mail to khargiss@faculty.umuc.edu
Acknowledge:
I, __ _____ acknowledge the above rules.
(Your name)
Problem I – (50 points)
Part A: Your systems analysis team is close to completing a system for Meecham Feeds. Roger is quite confident that the programs that he has written for Meecham’s inventory system will perform as necessary, because they are similar to programs he has done before. Your team has been very busy and would ideally like to begin full systems testing as soon as possible.
Two of your junior team members have proposed the following:
a) Skip desk checking of the programs (because similar programs were checked in other installations; Roger has agreed). (10 points)
b) Do link testing with large amounts of data to prove that the system will work. (10 points)
c) Do full systems testing with large amounts of live data to show that the system is working. (10 points)
Respond to each of the three steps in their proposed test schedule. Use a paragraph to explain your response.
Part B: Mr. Bruce Schnieder, the owner of A&A Office Supplies Company, had contacted you for your advices on a new information system installed recently at his company to help improving his company inventory tasks. He told you that the team that came to install the system does not have any evaluation mechanism and he also mentioned to you that some of his employees had complained about the new system’s inputs and outputs. Since he wants to obtain the inventory result of this quarter, he would like to delay or skip the new system evaluation and use the new system for inventory right away. Given the above conditions, he would like to have your advices on his decision and on the evaluation of his new system.
a) In a paragraph, explain to Mr. Schnieder about problems that can occur when a system is not evaluated systematically? (10 points)
b) Devise a checklist or form that helps Mr. Schnieder’s employees evaluate the utilities of the new information system. Suggest a second way to evaluate the information system, if any. Please be specific and explain your answers. (10 points)
Problem II – (50 points)
Cherry Jones owns a homeopathic medicine company called Faithhealers. She sells vitamins and other relatively nonperishable products for those who want choices regarding alternative medicine. Cherry is developing a new system that would require her staff to be retrained.
a) Construct a PERT diagram for her and identify the critical path. (20 points)
Description Task Must Follow Time
Interview Executives A None 6
Interview staff in orders fulfillment B None 3
Design input prototype C B 2
Design output pro-type D A,C 3
Write use cases E A,C 4
Record staff reactions to prototypes F D 2
Develop system G E,F 5
Write up training manual H B,G 3
Train staff working in order fulfillment I H 2
b) If Cherry could find away to save time on the “write use cases” phase, how would it help? (30 points)
Problem III- (50 points)
The problem is that the orders are not easily placed to the European plant, which is compounded whenever demand for the products increases dramatically. The company is looking for a systems solution that will address the problem and the solution should stress collaboration, flexibility, adaptability, and access.
One of your systems analyst team members proposed the following simple network solution that is to create an intranet that links the U.S. distributors with the European headquarters.
Distribution
Centers
European
Plant
Intranet
Order
Processing
Production
Control
As a systems analyst, would you approve this proposal? (The diagram is the proposal)
Please explain the reasons why you support or do not support this proposal. …need to offer some modifications to improve it.
Problem IV – (50 points)
All Pets Clinic Pharmacy has offered to give you a free lifetime supply of medicine if you design its database.
Given the rising cost of veterinarian care, you agree.
The following is the information you gathered:
· Pets are identified by a code #, and their names, addresses, and ages must be recorded
· Veterinarians are identified by an SSN. For each veterinarian, the name. specialty, and years of experience must be recorded.
· Each pharmaceutical company is identified by name and has a phone number
· For each medication, the trade name and formula must be recorded. Each medication is sold by a given pharmaceutical company, and the trade name identifies a medication uniquely from among the products of that company. Each pharmacy has a name, address, and phone number
· Pharmaceutical companies have long-term contracts with pharmacies. A pharmaceutical company can contract with several pharmacies, and a pharmacy can contract with several pharmaceutical companies. For each contract, you have to store a start date, an end date, and the text of the contract.
· Pharmacies appoint a supervisor for each contract. There must always be a supervisor for each contract, but the contract supervisor can change over the lifetime of the contract.
· Each pharmacy sells several medications and has a price for each. A medication could be sold at several pharmacies, and the price could vary from one pharmacy to another.
· Each medication has a date and a quantity associated with it. You can assume that, if a veterinarian prescribes the same medication for the same pet more than once, only the last such medication needs to be stored.
1. Draw an ER diagram that captures the preceding information. Identify any constraints not captured by the ER diagram (10pts.)
2. How would your design change if each medication must be sold at a fixed price by the pharmacies? (Requirement: Provide a written explanation) (20pts.)
3. How would your design change if the design requirements change as follows: If a veterinarian prescribes the same medication for the same pet more than once, several such prescriptions may have to be stored? (Requirement: Provide a written explanation) 20pts.
Problem V – (50 points)
Consider a school advising system in which a faculty advisor can advise many students, each of whom can register for one or many courses. The following is an example of an un-normalized STUDENT table for three students.
STUDENT
| Student Number | Student Name | Total Credits | GPA | Advisor Number | Advisor Name | Course Number | Course Description | Course Credits | Grade |
| 1034 | Linda | 47 | 3.60 | 59 | Smith | CSC101 | Computer Science I | 4 | B |
| MKT211 | Marketing Management | 3 | A | ||||||
| ENG101 | English Composition | 3 | B | ||||||
| CHM111 | General Chemistry I | 4 | A | ||||||
| BUS101 | Introduction to Business | 2 | A | ||||||
| 3397 | Sam | 29 | 3.00 | 59 | Smith | ENG101 | English Composition | 3 | A |
| MKT211 | Marketing Management | 3 | B | ||||||
| CSC101 | Computer Science I | 4 | B | ||||||
| 4070 | Kelly | 14 | 3.20 | 23 | Jones | CSC101 | Computer Science I | 4 | B |
| CHM111 | General Chemistry I | 4 | A | ||||||
| ENG101 | English Composition | 3 | B | ||||||
| BUS101 | Introduction to Business | 2 | B |
Perform the normalization process to convert the above un-normalized table to:
1. First normal form (1NF).
2. Second normal form (2NF).
3. Third normal form (3NF).
Please show all your work. Please show each step along the way and identify primary keys, if any, in each table in each step.
Note: Do not post multiple files. The exam should be posted and submitted in one file.
[Investigation manual]. Retrieved from https://ashford.instructure.com