Assignment 2 – Database Design – Traffic Demerit System (TDS)

Enactment 2 – Postulatesbase Pur-pose – Traffic Imperfection System (TDS)

This lesson continues the production you feel established in enactment 1 by refining/extending the pattern you familiar and implementing it as a firm of considerations underneath your Monash Oracle postulatesbase statement. Past this is an ongoing fruit way based on your enactment 1 patience and marker feedback, you must secure that your patience and the marker feedend offscourings intimate and is merely seen by yourself and the FIT9132 instruction staff.

Enactment 2’s inconsideroperative must be decipher in restoration with the enactment 1 inconsideroperative – ie your developed pattern must environ twain firms of requirements.

You may variegate your enactment 1 conceptual pattern in any sort you appetition as you production through enactment 2, supposing your developed pattern meets twain firms of requirements.
Further discussions with the national empire instance feel revealed that some imperfections, chiefly respect alcohol reckoning (BAC), are regarded as solemn imperfections and control to an contiguous licence cancellation. As pursueeous as recording the imperfection details you feel depicted in enactment 1, the instance insufficiencys to feel recorded, ce each imperfection, if the imperfection controls to an effortless cancellation and ce those that do, the calculate of months ce which the licence achieve be cancelled. When a licence is cancelled, its expiry limit is firm to the limit of the indignity which triggered the cancellation. Cancelled drivers insufficiency to interpretation to a pursue to attain their licence end. If granted the driver achieve be reinstated underneath their aged licence calculate.

The national empire instance feel supposing three of the cems, depicted underneath, which they fashion interpretation of showing some of the postulates they appetition to record:

● a exemplification bearing communication,

● two exemplification driver communications, and

● a driver cancellation communication.

Page 1 of 10

Exemplification Bearing Communication

* Note that the national empire instance has implied that it insufficiencys flexibility in the pur-pose to be operative to subjoin upstartlightlight, and suppress popular, bearing marks as qualification shift.

Page 2 of 10

Exemplification Driver Communications – Communication A

* Note that the national empire instance has implied that it insufficiencys flexibility in the pur-pose to be operative to subjoin upstartlightlight, and suppress popular, licence marks as qualification shift. The licence marks pair the corresponding firm of pickedions as bearing marks, past drivers are licenced ce a bearing mark.

Page 3 of 10

Exemplification Driver Communications – Communication B

* Note that the national empire instance has implied that it insufficiencys flexibility in the pur-pose to be operative to subjoin upstartlightlight, and suppress popular, licence marks as qualification shift.The licence marks pair the corresponding firm of pickedions as bearing marks, past drivers are licenced ce a bearing mark.

Page 4 of 10

Exemplification Cancellation Communication

Lesson to total:

2. Based on your enactment 1 conceptual pattern, your markers feedback, your deciphering of this plight consider and the normalisations you carried extinguished in tramp 1 aloft, fit a close flatten pur-posece the Traffic Imperfections System postulatesbase.

○ The close pattern must be drawn using the Oracle Postulates Patterner. The instruction engineering or Crow’s bottom referableation must be interpretationd in drawing the pattern. Your close pattern must referableshow postulatestypes.

○ All kindred depicted must be in 3NF

○ You are required to subjoin at smallest individual surrogate solution to your pur-pose (you are gratuitous to picked the most expend association to fashion this shift in)
○ All attributes must be commented in the postulatesbase(ie. the comments must be portio of the toperative building, referefficacious merely comments in the schema rasp).

○ Bridle clauses/look up considerations must be applied to attributes where expend.

○ You MUSTembrace the marvellous-story as portio of your pattern.

○ Note that your GIT repository must perspicuously evince your fruit fact with multiple commits/pushes as you production on your pattern.

3. Breed the schema ce the postulatesbasein Oracle Postulates Patterner and interpretation the schema to make the postulatesbase in your Oracle statement. Theonlyedit you are frank to heave extinguished to the breedd schema rasp is to subjoin header comment/s comprehending your details (scholar designate/id) and the charges to spool/echo your proceed of the script.

○ Apprehend the extinguishedput of the schema statements using the spool charge.

○ Secure your script embraces ooze toperative statements at the set-on-foot of the script.

○ Designate the schema rasp as tds_schema.sql.

Page 6 of 10

Patience Requirements

Enactment 2:

The subjoined rasps are to be submitted and must existin your FITGitLab server repo, parallel with the fount muniments from which they were breedd:

● A solitary page pdf rasp comprehending the developed close Pattern you maked in Oracle Postulates Patternler. Designate the rasp tds_logical.pdf. This pdf must be maked via Rasp – Postulates Patterner – Print Diagram – To PDF Rasp from amid SQL Developer, do referefficacious interpretation harbor apprehend.

● A zip rasp comprehending your Oracle postulates patterner purpose (in zipping these rasps be confident you embrace the .dmd rasp and the folder of the corresponding designate). Designate the rasp tds_oraclemodel.zip.

○ Portio of the tribute of your patience achieve envelop your marker citeing your pattern from this zip, gap it in SQL Developer Postulates Patternler, engineering to a upstartlightlightlight Associational pattern and from this your marker achieve breed a schema which achieve then be compared with your submitted schema (they must be the corresponding ce your schema to be reliable). Ce this deduce your pattern must be operative to be opened by your marker and comprehend your bountiful patternotherwise your lesson 2 achieve referefficacious be operative to be notable. Ce this deduce, you MUSTcarefully bridle that your pattern is total – secure to use your patience archive, vision it to a upstartlightlightlight partial folder, cite your patience portios, cite your pattern and secure it opens correctlybeforesubmission.

● A schema rasp (CREATE TABLE statements) breedd by Oracle Postulates Patternler. Designate the rasp tds_schema.sql

● The extinguishedput from SQL Developer spool charge showing the considerations feel been maked. Designate the rasp tds_schema_output.txt

● A pdf muniment comprehending any assumptions you feel made in developing the pattern or comments your marker should be known of. Designate the rasp tds_assumptions.pdf

These rasps must be zipped into a solitary zip rasp designated a2-.zipe.g., a2-xyz123.zip precedently the enactment ascribable limit/time. Submit the a2-xyz123.zip to Moodle precedently the ascribable limit.

Page 7 of 10

Page 8 of 10