Microsoft Word - MIS602-Assign3-v.1.1.docx MIS602 Assign 3 Page 1 of 4 ASSESSMENT BRIEF Subject Code and Title MIS602 Data Modelling & Database Design Assessment Reflective Research Report...

1 answer below »
I attached the brief and also sending the sample assignment for your help.



Microsoft Word - MIS602-Assign3-v.1.1.docx MIS602 Assign 3 Page 1 of 4 ASSESSMENT BRIEF Subject Code and Title MIS602 Data Modelling & Database Design Assessment Reflective Research Report Individual/Group Individual Length Three Thousand Word Limit Learning Outcomes a, b, c, d Submission Friday 11:59 PM AEST/AEDT of Module 6.1 (week 11) Weighting 40% Total Marks 40 Marks Context: The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system and designing database systems that will feature in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the learning activities in the modules. The learning activities are presented as a way of scaffolding your learning so that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning facilitator is the single best way of preparing for doing well in this assessment. Scenario: The scenario for this assessment is a hypothetical future system that helps governments to manage traffic flow in municipal localities. You should imagine that the local Road Traffic Authority has put out a Request for Proposals (RFP) for appropriately qualified consultants to undertake a body of work that would help to scope the data requirements for such a system. With your success in your Torrens University Australia degree so far, and other similar projects that have garnered you some sustained success in the eyes of the profession and community, you have been shortlisted among no less than 10 other consultancies. There are expectations from them, then, as to the standard of report you will produce. While there has been a tremendous amount of attention given in the media and in scientific circles to the progression and uptake of autonomous vehicles, their widespread adoption has not yet proliferated: there are reasons for this that you will need to take into account in your deliverable. The local Road Traffic Authority is, with several other bodies, lobbying the government on what it can manage in the emergent world of technological change and the capability of artificial intelligence. An alternative model has been proposed that the Road Traffic Authority believes to be MIS602 Assign 3 Page 2 of 4 preferable to autonomous vehicles and it involves a system that would control all non-autonomous, driverless vehicles through a traffic management and routing system. For such a system to work, it is necessary that there be no autonomous vehicles on the road, and AI- enabled as well as human drivers would be included in such a ban. With the remaining non- autonomous, driverless vehicles the only ones left on the road, the system would then be allowed to control the flow and routing of each and every vehicle by manipulating its speed, direction and ultimate route to the passengers’ intended destination. The system would control all traffic lights, lane changing, slowing and acceleration of the vehicles. The benefits of such a traffic management system are thought to be enormous as the hope is that the most effective routes can be calculated and that the most efficient traffic flow between those destinations is streamlined, congestion minimised and safety on the roads improved. But the system is ambitious and requires a lot of forethought and design elements fed into it before it could be seriously considered by the government of the day. The Road Traffic Authority seeks consultation on what the data requirements of such a hypothetical system might be. Instructions: There are two objectives of this assessment: for the purposes of the client, the local Road Traffic Authority, you are to produce a design brief; and, for the purposes of the assessment you are to produce a reflection. So, this written submission should expertly mix a consultative style—that is, providing a solution to the problem as outlined by the client—with a deep reflection on what you have learned in the subject and the potential for such a futuristic system. You will need to use your judgement on this; it is likely to take several drafts to get right. The deliverable for this assessment is plainly: You are tasked to create a consultative report that addresses the data requirements of a Driverless, Non-autonomous Traffic Management System as well as commenting on the feasibility of such a solution, given what you learned in the subject. Following instructions will assist you in completion of the task. Some hints for you to heed while you develop and write your assessment: • Consider what is meant by ‘autonomous’ and then explore the benefits and challenges that autonomous vehicles may present in a future in which they are widely adopted • The Road Traffic Authority has not provided any assumptions and you should list these if your proposal and reflection are to be considered cogent • Consider that there are presently several roads in operation that contain more than one traffic lane and while generally there are rules for how they are to be used, not all human drivers adhere to them—what are the consequences? • Consider what would happen when a driverless (non-autonomous) vehicle needed refuelling • Consider the security requirements in the context of what could go wrong in operating such a system Based on your learning from the course modules and previous assignments, you are expected to come up with data requirements and a logical design of the system and a brief commentary on the design. MIS602 Assign 3 Page 3 of 4 Submission Instructions: This consultative research and reflective report will be in a format that you choose and there are no prescriptions for what to include or what not to include. You will need to research consultant-grade reports (look for consulting reports form the Big Four firms as a guide and use them as the basis for their content, articulation presentation standard). You should include logical data requirements in a design summary that includes appropriate entity- relationship diagrams replete with connectivity and cardinality considerations. You should list any and all assumptions used in your report as well as any limitations that the reader should consider as they read your report. You should treat the prescribed word limit as something you cannot breach as there is no plus-or- minus 10 per cent ascribed in this assessment. The reality of consultant-grade reports is that any that breach the requirements are rejected and no reasoning is provided to the consultant. As you are preparing for your professional life, treat this requirement as the same in this subject and that any report that breaches the word limit will not be marked. Requests for extensions must be compliant with the university policy and must be applied for before the due date. Include in your application a full draft of your assessment as this draft may be what is assessed if the extension request is denied. Submit your report to the submission point in Blackboard prior to the due date. In accordance with university policy, late assessments will attract a 10% of available grade penalty for every day late, up to a maximum of 5 days, after which the assessment will not be marked. Please note that requests for resubmissions of this assessment will not be considered. MIS602 Assign 3 Page 4 of 4 Learning Rubric: Assessment Three Assessment Attributes Fail (Unacceptable) 0-49% Pass (Functional) 50-64% Credit (Proficient) 65-74% Distinction (Advanced) 75 -84% High Distinction (Exceptional) 85-100% Understanding of the Data requirements 30% Demonstrates limited understanding of the data requirements Fair understanding of the data requirements. May neglect to provide resources or that these are cursorily provided without reference to specific areas in the source. Good understanding of the data requirements demonstrated. May provide a limited number of sources the peer can use to develop their technique from. Very good understanding of the data requirements demonstrated. Makes recommendations to other external sources the peer can access to develop their understanding. Outstanding understanding of the data requirements demonstrated through recommendation of other sources with specific references to components of it that the peer will benefit from. Capture of key entities and their relationships 40% Less than 50% entities and relationships are completed 50-64% entities and relationships completed 65-74% entities and relationships completed 75-84% entities and relationships completed 85-100% entities and relationships completed Effective communication 30% Difficult to understand for audience, no logical/clear structure, poor flow of ideas, argument lacks supporting evidence. Audience cannot follow the line of reasoning. Information, arguments and evidence are presented in a way that is not always clear and logical. Line of reasoning is often difficult to follow. Information, arguments and evidence are well presented, mostly clear flow of ideas and arguments. Line of reasoning is easy to follow. Information, arguments and evidence are very well presented; the presentation is logical, clear and well supported by evidence. Demonstrates cultural sensitivity. Expertly presented; the presentation is logical, persuasive, and well supported by evidence, demonstrating a clear flow of ideas and arguments. Engages and sustains audience’s interest in the topic, demonstrates high levels of cultural sensitivity. Data Modelling & Database Design Student id-00273684T 1 Assignment: 3 Subject code and Title: - MIS 602 & Data Modelling & Database Design Reflective Research Report Name: - Rajeshwariba Vaghela Student Id:- 00273684T Institution Affiliated: - Torrens University Australia. Data Modelling & Database Design
Answered Same DayApr 17, 2021MIS602

Answer To: Microsoft Word - MIS602-Assign3-v.1.1.docx MIS602 Assign 3 Page 1 of 4 ASSESSMENT BRIEF Subject Code...

Neha answered on Apr 24 2021
131 Votes
Student Id:
Student Name:
Student Id:
Title:
Table of Contents
Introduction                                            03
Benefits of AV                                        03
Limitations of AV                                        04
Assumptions                                         04
Current System                                        04
Proposed System                                        05
Database                                             06
ER (Entity-Relationship) Diagram                            07
Data requirement                                        08
Benefits of the system                                    09
Refueling of AV                                        09
Future Scope                                        09
Security Challenges                                     10
Reflection                                            10
Conclusion                                            10
References                                            11
Appendix A: Code                                     12
Introduction:
The government is planning is t
o have a system which can help them in managing the traffic flow. The number of accidents on the road are increasing at a very high speed. This report includes the description for the traffic management of autonomous vehicles. The concept of autonomous vehicles is known to everyone. An autonomous vehicle can be defined as the vehicle which is self-operated and able to perform all the essential functions without any human body. They are designed in such a way that they can sense their environment. These vehicles are designed to reduce the crashes on the roads, lower the energy consumption, help in the accessibility of the transport and decrease blockage. The new system will be able to reduce the number of accidents on the roads. It will be easy for the vehicles to find the best route for the destination and minimize the congestion. The objective of presenting this report is to create a data design of the system which can manage the vehicles more efficiently and help the users. The motive of this report is to design a system which can find out the most effective routes and manage the traffic flow efficiently (Naumann, R., Rasche, R., & Tacken, J.). The proposed system has eliminated all the limitation. Normalization is used to complete the data requirement of the system.
Benefits of Autonomous Vehicles
· As per a report the self-driving car have the potential to decrease the deaths by 90% which means they can save 30,000 lives in a year. Here are few more benefits of the autonomous vehicles.
· Lower transportation cost and eliminates the portability issues for the customers.
· It is a more secure framework.
· Self-driving vehicles can help to reduce the number of accidents.
· They can reduce the emission of CO2 up to great extent.
· It increases the lane capacity and also consumes less fuel.
· They allow more efficient parking.
Limitation of autonomous vehicles
· The manufacturing and maintenance cost is high for self-driving vehicles.
· There are chances of unexceptional glitch.
· There is a problem of state and federal licensing infrastructure.
· Loss of privacy.
Assumptions
· The admin of the system has complete understanding of its workings and the related attributes.
· The roads, lanes, crossings and the traffic lights are in perfect condition. It would create problem if the traffic light is not working properly.
· There are only autonomous vehicles and no non- autonomous vehicles.
· The current system has file-based system which makes it difficult to store and access the data.
· Intelligent speed adaption service is implemented.
· The information is sent digitally to the autonomous vehicles.
· The system informs vehicle when there is shortage of fuel.
· Timeline and deployment of the system.
· The sensors and hardware are working properly.
· The system has best security policy which can’t be attacked by any hacker.
Current System
Issues in the current system:
· Does not have any feature to control the traffic lights.
· Does not have any control over the speed and direction of the vehicles.
· Does not know how to change the lane or manage the speed of the vehicle.
· Finds it difficult to check for the vehicles.
· Does not have any monitoring system.
· Cannot provide any data about the vehicle.
The current system uses file-based system to store the data which makes it inconsistent. The different data is placed in different files which belongs to same field makes it inconsistent.
Another major limitation is the redundancy of data. The file system stored the details about the vehicle and the users who uses it but at the time of updating, redundancy may occur.
When the data is repeated again and again it will surely make the database complex and lengthy. Due to the lack of validation, it allows storing data of same vehicle again and again. This result in duplication of data and wastage of space.
Data integrity is another limitation of the current system. The inaccurate and inconsistent data leads to this issue. It takes a lot of time in retrieving the data from the system. Security is the most crucial part of any system. The current system does not have security for the data. It uses password-protected technique which can be accessed by any user. Hacking a password is not a difficult task.
Proposed System
A new system is always designed to overcome the limitations and problems of the current system. The government wants a traffic management system which can help them to manage the traffic and reduce the number of accidents. They need a system which can keep a track of the vehicles, users, location, roads and other things. This new system has multiple advantages over the current one. It will provide apps to the users which can be used to call the vehicles (Salama, A. S., Saleh, B. K., & Eassa, M. M.). The system will involve a data connectivity of high level. For the new system MySQL can be used to store the data which uses tables to store the data. ER diagram can be used for the system design.
Before implementing any system, it is advisable to create a design for that system. The design helps to remove the errors and make system without any defect. Critical thinking is involved to get desired result. This system will involve high level for the data connectivity which will make it easier for the access of data. The vehicles generate data and it is saved in the data. This data can help to sense the driving task which can be to...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here