Task 1: Management Information Systems
A Management Information System (MIS) summarises data and prepares reports for middle, tactical management. Its strength lies in dealing with, and supporting, routine structured decisions. Consider Marketing Management Information Systems (MMIS). Give a detailed description of the workings of a MMIS. In order to do this you must answer the following:
- What is the objective of a Marketing MIS?
- What type of management decisions will such an IS support?
- What type of data will be input to such a system?
- Outputs produced?
Your answer should be as full as possible and approximately between 1000-1500 words in length. Make use of diagrams to show the workings of the Marketing MIS and also how it relates to other types of information systems, e.g. a Transaction Processing System and Executive Information Systems. You must cite all sources for the information you use, i.e. list ALL references.
Task 2: Entity Relationship Diagram (ERD)
In data planning and database design, end users must identify key data elements that are needed in order to perform specific business activities. This frequently involves developing entity relationship diagrams (ERDs) that model the relationships among the many entities involved in business processes. Read the following case study:
A Bike Hire shop rents out a wide variety of bicycles, tandems, tricycles and trailers to people. Every Customer can make one or more Rental Agreements with the hire shop. Each Rental Agreement can only be raised by a specific Customer. The Rental
Agreement can be for up to four Bicycles and the Bicycle is on many Rental
Agreements. A Bicycle belongs to a Bike Class, which describes general types of Bicycles. Each Bike Class may own a number of Bicycles. Each Bike Class is charged at one or a number of Rental Rates. Each Rental Rate applies to a single Bike Class.
Using the ERD notation, as presented in the BIS1201 Lectures, produce an ERD model of the narrative described above.
Task 3: Security of Information Systems
Information Systems represent critical organisational assets. Hence, issues regarding information security are critical to all managers in modern organisations.
- a) Highlight four principal dangers that are deemed to be security threats to information systems. Your answer should include a detailed explanation as to how the threat is a danger to the security of an IS.
Complete research and identify 6 software controls that can be implemented so as to safeguard information systems and ensure that they perform according to management standards.
- b) For each software control describe how it safeguards an Information System. You should include a technical description of the workings of each respective control.
Your answer should be as full as possible, approximately between 1000-1500 words in length and should also refer to a wide selection of sources for gathering the information to be presented in your answer. You must cite all sources for the information you use, i.e. list ALL references.
Your submission should include the following:-
Ø A cover sheet with the title of the module, your name and student number
Ø Task 1: Management Information Systems
Ø Task 2: Entity Relationship Diagram (ERD)
Ø Task 3: Security of Information System
Ø References
NOTE: It is essential that you use a software package such as draw.io, MS Word, or similar to present your work, including the Entity Relationship Diagram (ERD) for Task 2.
Marking Criteria
Diagrams should be neat and clear. It is compulsory that you use the appropriate software to produce your ERD (e.g. draw.io, MS Word, etc.) and word processing software (e.g. Word, WordPerfect) to produce the remainder of the coursework submission.
| Marks will be awarded for: | (%) |
| Presentation
• Well-structured submission with appropriate sections • Spelling and grammar • Word processed work and diagram completed using appropriate software package |
10 |
| Task 1: Management Information Systems
State the principle objective of a Marketing MIS |
25 |
| • List at least six types of management decisions that a marketing IS supports
• Identify at least six types of data that will be inputted into a marketing MIS • Identify the major, at least six, outputs produced by such a MIS • Diagram(s) giving an overview of a Marketing MIS |
|
| Task 2: Entity Relationship Diagram (ERD)
• Identification of Entities, Relationships and Cardinality • Resolution of many : many relationships • Logical correctness • Completeness: all entities pertaining to the system described in the case study should be represented • Optional / Mandatory relationships stated |
25 |
| Task 3: Security of Information Systems
• Identify fours threats to an IS • Provide explanations as to how the threats are a danger to the security of an IS • List 6 software controls • Give a detailed description as to how each software control works |
25 |
| References
• Use of Harvard Referencing Scheme • Use of books, journals and web references |
15 |
| Total | 100 |
| NOTE:
All references, including on-line sources, must be clearly listed. |
