Management of Information Systems - Assignment Example

Management of Information Systems Your name, Tutor Course Institution Date of Submission Response to Question 1- Using Module 4 Lab for guidance, create an Entity Relationship Diagram (ERD). Response to Question 2 Student Student Name Student Number Address Email Address Phone No John 897/2012 673-0012 jh@gmail.com 44789267 Peter 899/2012 8772-0012 pty@yahoo.com 134089627 Claire 709/2011 7872-0010 claire@hotmail.com 138567092 Ann 972/2013 7627-0012 annki@gmail.com 44896102 Units Unit 1 Unit 2 Unit 3 Unit 4 Unit Components Unit No. Date Enrolled Unit Results Semester Details Unit 1 12/3/2014 B Pass Unit 2 09/11/2013 A Pass Unit 3 21/4/2014 C Pass Unit 4 07/01/2014 B Pass 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 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. Read More