UQ Students should read the Disclaimer & Warning
Note: This page dates from 2005, and is kept for historical purposes.
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>INFS1200 - Assignment One part two</title>
<style type="text/css">
<!--
body {
background: url(_img/DSC04989.jpg) fixed center center;
}
.underline {
text-decoration: underline;
}
th, td, textarea {
border: 1px solid #000000;
padding: 0 1ex;
background: transparent;
overflow: hidden;
}
table {
border: none;
}
.dashed {
border-top: none;
border-right: none;
border-bottom: 1px dashed;
border-left: none;
}
-->
</style>
</head>
<body>
<h1>INFS1200 – Assignment 1, part 2</h1>
<p><a href="#results">Results</a> | <a href="#peer">Peer Review</a> | <a href="#er"><acronym title="Entity Relationship">ER</acronym> Diagram</a> | <a href="#mapping">Mapping</a> </p>
<h2 id="results">Results</h2>
<p><img src="_img/INFS1200-ass1p2-marks-dist.png" alt="Marks distribution" width="517" height="286" /></p>
<p><img src="_img/INFS1200-ass1p2-marks-hist.png" alt="Marks histogram" width="436" height="320" /> </p>
<table border="1">
<tr>
<td>My Result</td>
<td>10.75 out of 12</td>
</tr>
<tr>
<td>Mean</td>
<td>9.217818182</td>
</tr>
<tr>
<td>Standard Error</td>
<td>0.160775233</td>
</tr>
<tr>
<td>Median</td>
<td>10.1</td>
</tr>
<tr>
<td>Mode</td>
<td>10.6</td>
</tr>
<tr>
<td>Standard Deviation</td>
<td>2.666155609</td>
</tr>
<tr>
<td>Sample Variance</td>
<td>7.108385733</td>
</tr>
<tr>
<td>Kurtosis</td>
<td>4.140072965</td>
</tr>
<tr>
<td>Skewness</td>
<td>-2.214141663</td>
</tr>
<tr>
<td>Range</td>
<td>11.6</td>
</tr>
<tr>
<td>Minimum</td>
<td>0</td>
</tr>
<tr>
<td>Maximum</td>
<td>11.6</td>
</tr>
<tr>
<td>Count</td>
<td>275</td>
</tr>
<tr>
<td>Confidence Level(95.0%)</td>
<td>0.316511833</td>
</tr>
</table>
<p>Note: Only the <acronym title="Entity Relationship">ER</acronym> Diagram and
Relationship Mapping are included below. The designed database and its forms
are not included. </p>
<h2 id="peer">Peer Review </h2>
<p>INFS1200/INFS7900 Semester 2, 2003 <br />
Assignment 1 Part 2 </p>
<p>Peer/Self Review Report</p>
<p>Group No. ___ 8 _______ </p>
<p>Student No. 40529927 ________ Student Name: _ Ned Martin _______________ </p>
<p>Peer Assessment for : _ SELF ___________ ___________________________ </p>
<p>(Give Student No & Name of the peer; Write SELF for self assessment report): </p>
<p><em>Note: You are to fill out 3 peer assessment reports, 1 for each of your
group members, and 1 self assessment report, for the design you submitted in
part 1 of this assignment </em></p>
<p>1. Does the ER diagram conform to the notation/grammar of the ER model (Y/N)
_ Y </p>
<p>If not, identify and explain the error </p>
<table cellspacing="0" cellpadding="0">
<tr>
<td width="568" valign="top"><p>Correct notation and grammar appears to have
been used throughout, however the diagram doesn't strictly read top down
and left to right, with some relations being named in such a way as to cause
right to left and bottom up reading. </p>
<p> </p>
<p> </p></td>
</tr>
<tr>
<td width="568" valign="top"><p>Give 3 Marks for no error. Give 0, 1 or 2 marks
otherwise, depending on the error 2 _ </p></td>
</tr>
</table>
<p>2. Are all the concepts given in the original universe of discourse covered
in the ER diagram (Y/N) Y _ </p>
<p>If not, identify what is missing </p>
<table cellspacing="0" cellpadding="0">
<tr>
<td width="568" valign="top"><p>Entities </p>
<p> </p>
<p>Relationships </p>
<p>- The relationship between route, stops and city has become somewhat polluted
and could lead to duplication of stops, and definitely duplication of their
city attributes. </p>
<p>Attributes </p>
<p> </p>
<p>Constraints </p>
<p> </p></td>
</tr>
<tr>
<td width="568" valign="top"><p>Give 3 Marks if there is no missing concept.
Give 0, 1 or 2 marks otherwise, depending on the omission _ 1 </p></td>
</tr>
</table>
<p>3. Is there any part of the ER diagram, which is incorrectly representing
the universe of discourse (Y/N) _ N </p>
<p>If yes, identify and explain the error </p>
<table cellspacing="0" cellpadding="0">
<tr>
<td width="568" valign="top"><p>Given the assumptions provided, I will say
no, however, in hindsight some of those assumptions may not have been the
best assumption in the situation, but I believe they are still technically
correct. </p>
<p> </p></td>
</tr>
<tr>
<td width="568" valign="top"><p>Give 4 Marks for no error. Give 0 - 3 marks
otherwise, depending on the error _ 3 </p></td>
</tr>
</table>
<p> </p>
<h2 id="er"><acronym title="Entity Relationship">ER</acronym> Diagram </h2>
<p><img src="_img/INFS1200-a1p2-5.png" alt="ER Diagram" width="1116" height="785" /></p>
<h2 id="mapping">Relation Mapping</h2>
<h3>First Normal Form</h3>
<p><em>TRANSPORT_MINISTRY_OFFICE [ <u>State</u> ] </em></p>
<p> <em>WORKER [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone, Transport_Ministry_Office_State] </em></p>
<p><em> INSPECTOR [ <u>BTWN</u> , Inspector_No., Section_Name, Name, Address,
Date_Of_Birth, Phone,] </em></p>
<p><em> STATUS_REPORT [ <u>Date, Transport_Ministry_Office_State</u>, Bus_Registration_Number,
Inspector_Number] </em></p>
<p><em> BUS_COMPANY [ <u>ABN</u> , Name, Head_Office_Address, Phone, Fax, Email,
Website_URL,] </em></p>
<p><em> COMPANY_PHONE [ <u>Number, Company_ABN</u> , Dept] </em></p>
<p><em> COMPANY_FAX [ <u>Number, Company_ABN</u> , Dept] </em></p>
<p><em> COMPANY_EMAIL [ <u>Address, Company_ABN</u> , Dept] </em></p>
<p><em> BRANCH [ <span class="dashed">Company_Internal_No</span>. , Manager_Name,
Address, Telephone_No., Fax_No., Email_Address, Company_ABN] </em></p>
<p><em> BRANCH_PHONE [ <u>Number, Branch_Number</u> , Person] </em></p>
<p><em> BRANCH_FAX [ <u>Number, Branch_Number</u> , Person] </em></p>
<p><em> BRANCH_EMAIL [ <u>Address, Branch_Number</u> , Person] </em></p>
<p><em> DRIVER [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone, Licence_No.,
Company_ABN] </em></p>
<p><em> PERMANENT_ ASSISTANT [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone,
State_Of_Birth, Company_ABN,] </em></p>
<p><em> CONTRACT_ ASSISTANT [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone,
Salary, Last_Employment, Company_ABN] </em></p>
<p><em> LICENCE [ <u>Licence_No</u>. , Type, Date_Of_Expiry, Issuing_Officer,
Driver_BTWN] </em></p>
<p><em> BUS [ <u>Registration_No</u>. , Roadworthy_Date, Type, Model_Make, Seating_Capacity,
Weight, Driver_BTWN, Permanent_Assistant_BTWN, Contract_Assistant_BTWN, Inspector_Number,
Company_ABN] </em></p>
<p><em> ROUTE [ <u>Route_Number</u> , Date_of_Approval, Date_of_Introduction,
Origin, Destination, Start_Time, Distance, Begin_City_Postcode, End_City_Postcode,
Bus_Registration_Number] </em></p>
<p><em> CITY [ <u>Post_Code</u> , Name] </em></p>
<p><em> BUS_STOP [ <span class="dashed">Stop_No</span>. , City_Post_Code, Route_Number] </em></p>
<p><em> DEPOT [ <u>Depot_No</u>. , Address, Phone, Bus_Registration_Number] </em></p>
<p><em> ROUTE_APPROVAL [ <u>Route_Number, Company_ABN</u> ] </em></p>
<p><em> SUBCONTRACTS [ <u>Assistant_BTWN, Company_ABN</u>] </em></p>
<h3>Second Normal Form</h3>
<p><em>TRANSPORT_MINISTRY_OFFICE [ <u>State</u> ] <br />
</em><em>Candidate Key: State</em><em> </em></p>
<p><em>WORKER [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone, Transport_Ministry_Office_State] <br />
</em><em>Candidate Key: BTWN, Transport_Ministry_Office_State </em></p>
<p><em>INSPECTOR [ <u>BTWN</u> , Inspector_No., Section_Name, Name, Address,
Date_Of_Birth, Phone,] <br />
</em><em>Candidate Key: BTWN, Inspector No. </em></p>
<p><em>Decompose to:</em><em> </em></p>
<p><em>INSPECTOR_SECTION [Inspector_No., Section_Name]</em></p>
<p><em> </em><em>STATUS_REPORT [ <u>Date, Transport_Ministry_Office_State</u>,
Bus_Registration_Number, Inspector_Number]<br />
</em><em>Candidate Key: Date, Transport_Ministry_Office_State </em></p>
<p><em>BUS_COMPANY [ <u>ABN</u> , Name, Head_Office_Address, Phone, Fax, Email,
Website_URL,]<br />
</em><em>Candidate Key: ABN </em></p>
<p><em>COMPANY_PHONE [ <u>Number, Company_ABN</u> , Dept] <br />
</em><em>Candidate Key: Number, Company_ABN </em></p>
<p><em>COMPANY_FAX [ <u>Number, Company_ABN</u> , Dept] <br />
</em><em>Candidate Key: Number, Company_ABN </em></p>
<p><em>COMPANY_EMAIL [ <u>Address, Company_ABN</u> , Dept] <br />
</em><em>Candidate Key: Address, Company_ABN </em></p>
<p><em>BRANCH [ <span class="dashed">Company_Internal_No</span>. , Manager_Name,
Address, Telephone_No., Fax_No., Email_Address, Company_ABN] <br />
</em><em>Candidate Key: Company_Internal_No., Company_ABN </em></p>
<p><em>BRANCH_PHONE [ <u>Number, Branch_Number</u> , Person] <br />
</em><em>Candidate Key: Number, Branch_Number </em></p>
<p><em>BRANCH_FAX [ <u>Number, Branch_Number</u> , Person] <br />
</em><em>Candidate Key: Number, Branch_Number </em></p>
<p><em>BRANCH_EMAIL [ <u>Address, Branch_Number</u> , Person] <br />
</em><em>Candidate Key: Address, Branch_Number </em></p>
<p><em>DRIVER [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone, Licence_No.,
Company_ABN] <br />
</em><em>Candidate Key: BTWN, Company_ABN </em></p>
<p><em>PERMANENT_ ASSISTANT [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone,
State_Of_Birth, Company_ABN,] <br />
</em><em>Candidate Key: BTWN, Company_ABN </em></p>
<p><em>CONTRACT_ ASSISTANT [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone,
Salary, Last_Employment, Company_ABN] <br />
</em><em>Candidate Key: BTWN, Company_ABN </em></p>
<p><em>LICENCE [ <u>Licence_No</u>. , Type, Date_Of_Expiry, Issuing_Officer,
Driver_BTWN] <br />
</em><em>Candidate Key: Licence_No., Driver_BTWN </em></p>
<p><em>BUS [ <u>Registration_No</u>. , Roadworthy_Date, Type, Model_Make, Seating_Capacity,
Weight, Driver_BTWN, Permanent_Assistant_BTWN, Contract_Assistant_BTWN, Inspector_Number,
Company_ABN] <br />
</em><em>Candidate Key: Registration_No., Company_ABN </em></p>
<p><em>ROUTE [ <u>Route_Number</u> , Date_of_Approval, Date_of_Introduction,
Origin, Destination, Start_Time, Distance, Begin_City_Postcode, End_City_Postcode,
Bus_Registration_Number] <br />
</em><em>Candidate Key: Route Number, Bus_Registration_Number </em></p>
<p><em>CITY [ <u>Post_Code</u> , Name ] <br />
</em><em>Candidate Key: Post_Code </em></p>
<p><em>BUS_STOP [ <span class="dashed">Stop_No</span>. , City_Post_Code, Route_Number] <br />
</em><em>Candidate Key: Stop_No., Route_Number </em></p>
<p><em>DEPOT [ <u>Depot_No</u>. , Address, Phone, Bus_Registration_Number]<br />
</em><em>Candidate Key: Depot_No., Bus_Registration_Number </em></p>
<p><em>ROUTE_APPROVAL [ <u>Route_Number, Company_ABN</u> ] <br />
</em><em>Candidate Key: Route_Number, Company_ABN </em></p>
<p><em>SUBCONTRACTS [ <u>Assistant_BTWN, Company_ABN</u> ] <br />
</em><em>Candidate Key: Assistant_BTWN, Company_ABN </em></p>
<h3>Third Normal Form </h3>
<p><em>TRANSPORT_MINISTRY_OFFICE [ <u>State</u> ] </em></p>
<p><em>WORKER [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone, Transport_Ministry_Office_State] </em></p>
<p><em>INSPECTOR [ <u>BTWN</u> , Inspector_No., Section_Name, Name, Address,
Date_Of_Birth, Phone,] </em></p>
<p><em>INSPECTOR_SECTION [Inspector_No., Section_Name] </em></p>
<p><em>STATUS_REPORT [ <u>Date, Transport_Ministry_Office_State</u>, Bus_Registration_Number,
Inspector_Number] </em></p>
<p><em>BUS_COMPANY [ <u>ABN</u> , Name, Head_Office_Address, Phone, Fax, Email,
Website_URL,] </em></p>
<p><em>COMPANY_PHONE [ <u>Number, Company_ABN</u> , Dept] </em></p>
<p><em>COMPANY_FAX [ <u>Number, Company_ABN</u> , Dept] </em></p>
<p><em>COMPANY_EMAIL [ <u>Address, Company_ABN</u> , Dept] </em></p>
<p><em>BRANCH [ <span class="dashed">Company_Internal_No</span>. , Manager_Name,
Address, Telephone_No., Fax_No., Email_Address, Company_ABN] </em></p>
<p><em>BRANCH_PHONE [ <u>Number, Branch_Number</u> , Person] </em></p>
<p><em>BRANCH_FAX [ <u>Number, Branch_Number</u> , Person] </em></p>
<p><em>BRANCH_EMAIL [ <u>Address, Branch_Number</u> , Person] </em></p>
<p><em>DRIVER [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone, Licence_No.,
Company_ABN] </em></p>
<p><em>PERMANENT_ ASSISTANT [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone,
State_Of_Birth, Company_ABN,] </em></p>
<p><em>CONTRACT_ ASSISTANT [ <u>BTWN</u> , Name, Address, Date_Of_Birth, Phone,
Salary, Last_Employment, Company_ABN] </em></p>
<p><em>LICENCE [ <u>Licence_No</u>. , Type, Date_Of_Expiry, Issuing_Officer,
Driver_BTWN] </em></p>
<p><em>BUS [ <u>Registration_No</u>. , Roadworthy_Date, Type, Model_Make, Seating_Capacity,
Weight, Driver_BTWN, Permanent_Assistant_BTWN, Contract_Assistant_BTWN, Inspector_Number,
Company_ABN] </em></p>
<p><em>ROUTE [ <u>Route_Number</u> , Date_of_Approval, Date_of_Introduction,
Origin, Destination, Start_Time, Distance, Begin_City_Postcode, End_City_Postcode,
Bus_Registration_Number] </em></p>
<p><em>CITY [ <u>Post_Code</u> , Name] </em></p>
<p><em>BUS_STOP [ <span class="dashed">Stop_No</span>. , City_Post_Code, Route_Number] </em></p>
<p><em>DEPOT [ <u>Depot_No</u>. , Address, Phone, Bus_Registration_Number] </em></p>
<p><em>ROUTE_APPROVAL [ <u>Route_Number, Company_ABN</u> ] </em></p>
<p><em>SUBCONTRACTS [ <u>Assistant_BTWN, Company_ABN</u> ] </em></p>
<p> </p>
<p>10-Nov-2003<br />
18-Nov-2004</p>
</body>
</html>