• Category:
  • Document type:
  • Level:
  • Page:
  • Words:

Management of Information Systems

Response to Question 1-

Using Module 4 Lab for guidance, create an Entity Relationship Diagram (ERD).

Management of Information SystemsManagement of Information Systems 1

Management of Information Systems 2Management of Information Systems 3

Management of Information Systems 4Management of Information Systems 5Management of Information Systems 6Management of Information Systems 7Management of Information Systems 8Management of Information Systems 9Management of Information Systems 10Management of Information Systems 11Management of Information Systems 12

Student Address


Management of Information Systems 13Management of Information Systems 14Management of Information Systems 15Management of Information Systems 16Management of Information Systems 17Management of Information Systems 18Management of Information Systems 19Management of Information Systems 20Management of Information Systems 21Management of Information Systems 22Management of Information Systems 23Management of Information Systems 24Management of Information Systems 25Management of Information Systems 26Management of Information Systems 27

Mobile Number

Email Address

Management of Information Systems 28Management of Information Systems 29Management of Information Systems 30Management of Information Systems 31Management of Information Systems 32

Unit Result

Unit Number

Components of Units

Management of Information Systems 33Management of Information Systems 34Management of Information Systems 35Management of Information Systems 36Management of Information Systems 37Management of Information Systems 38

Semester Details

Date Enrolled

Response to Question 2

Email Address



[email protected]




[email protected]




[email protected]




[email protected]


Unit Components

Date Enrolled

Unit Results

Semester Details





To design a query, start by creating all the necessary data bases. In this case, go to your start menu, click on all programs option, select Microsoft office, then open MS-Access 2010. Once it is open, click on new database, then save it with the first name. “Unit Components” and “Student” databases will be created. In this case, name the first database “Students.” Fill in all the required details, then create the second one and name it, “Unit Components.” Fill it with the required fields too. After that, click on relationships, then select both “Students” and “Unit Components.” Link all fields that relate to each other. After this, save and click on create query. You can then chose the fields that will be used to create queries, and save. To make a query, simply click “run,” type in whatever details you want to use and press the “ok” button.

Task 4- Module 6

Response to Question 1

Personal Scope

Student’s emails are a good example for this scope. Each student has access to their emails. They can change the password at any time, and can access them without restrictions. They have their personal information, and no one else has access to their emails, without their permission.

Workgroup Scope

The university accounting system, student’s health records and student record data base are examples of work group scenarios. All of them have student’s name, their admission numbers, address and contacts. They duplicate data. Accountants work together in the accounting department, and all of them are able to access student’s accounting information. Teachers also work together, and they can be able to access, and even modify student’s information. Information, in this case is quite complex, and can only be understood by members of the relevant department.

Enterprise Scope

A good example that falls under this category is student’s online portal. Student’s can be able to access various online services through the portal. However, they cannot be able to change anything. It is not easy to manipulate data in this case.

Inter-Enterprise Scope

Faculty information systems can be described as inter-enterprise. Assuming that each faculty is an independent entity, then it is right to say that they are interlinked through an inter-enterprise system. It is not easy to change information in this case. There are also many users, and formalised procedures are used.

The characteristics of the examples in Fig. 7.1 relate to the above examples in various ways. Just like a drug person will have his own system to store data about drugs, students also have their personal emails. These emails have a lot of personal information about them. The university’s accounting system, medical record system, and student’s information systems must be related. They hence duplicate data to enhance an easy relationship, just like in the case of Physician partnerships.

A hospital serves many patients. An enterprise information system has been developed to help serve patients more efficiently. In the same manner, through the student’s online portal, they are able to receive services conveniently. They can access the library and borrow books, without necessarily having to physically walk into the library building.

Response to Question 2

Management of Information Systems 39

Sent back to the lecturer with comments. Process continues until there are no mistakes, and a confirmation is sent to lecturer to forward to printing

Management of Information Systems 40Management of Information Systems 41

Management of Information Systems 42Management of Information Systems 43

Received back with comments, corrections made and sent back to tutors until there are no mistakes, then brought back to lecturer. Lecturer send for printing.

Assignment created by Lecturer.

Goes through assignment and send back to the lecturer. Lecturer returns after corrections. Process continues until there are no mistakes, and paper is sent back to lecturer to forward for printing

Management of Information Systems 44

Management of Information Systems 45

Management of Information Systems 46

Document is printed

Management of Information Systems 47

Black board

Management of Information Systems 48

This is a good method of ensuring that error free documents are produced. By ensuring that the each document is proofread by five people, chances of mistakes are reduced. However, this process takes too much time, and is not suitable for documents that have a short deadline. If it is used for such documents, then there is a high possibility that several errors will be made. The process can be improved by involving at least three different people in creating the initial document. This way, it will be easy to identify mistakes, since the people proofreading will have a concrete idea of what is desired. However, if they are just given the documents to proofread, they may not identify most errors because they do not have full understanding of what the lecturer intended to deliver.