MIS602 Data Modelling & Database Design

3000 words

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.


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

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 AIenabled

as well as human drivers would be included in such a ban. With the remaining nonautonomous,

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.


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


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


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 entityrelationship

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-orminus

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.