COMP8711代做、代写Python，c++程序设计

日期：2023-08-28 10:12

Flinders University

2023 S2 COMP8711

Database Modelling and Information Management

Assignment 1

Due date: 10 September 2023

This assessment is an individual assessment. The assignment is worth 25% of the total assessment. It will be

marked out of 25.

General Specification

You are required to construct an information model and draw an Entity-Relationship Diagram (DRD) for the

following business scenario of a Ute rental firm “Tradie mates”. In the case-study description, the following

notation is used to indicate the type of data items:

(N x) a digit string (integer) of length x

(S x) a character string of length x

($ x) x dollar digits and 2 cent digits

(C) a combination of

family name (S 20)

personal name (S 20)

title (S 4)

(A) a combination of

street address (S 45)

postcode (S 4)

(D) time and date or either

Tradie mates: Ute rental firm

The Ute hire firm “Tradie mates”, requires a database system to manage their fleet of hire Utes. Each Ute

in the fleet has a unique fleet membership number (N 3) and is recorded is the vehicle's registration

number (S 7), colour (S 20), and make (S 8).

The firm records the individual details of any client the first time that the person or the company1 has

business with the company. A client's name (C), address (A) and one contact phone number (S 14) are

recorded along with a generated unique client identifier. This identifier is used for all subsequent

references to that client. A (person) client's driver's license number (S 12) is recorded the first time that

they hire a vehicle or are a nominated driver.

When a ute is hired, the contract is created, and the hire time and date (D) are recorded. The hirer (client)

involved is recorded along with the type (S 2) and number (S 20) of the credit card to be used to pay for

that hire. A vehicle's starting kilometrage (N 5) is recorded when it is hired. At any one time, only one

vehicle is on hire to a customer. When the ute is returned, the ute's kilometrage (N 5) (distance travelled)

is recorded. The payment date (D) and payment amount ($) are recorded.

A booking of a vehicle may also be created for future hiring, in which case, the nominated pick-up

depot, the starting time and date for the booking (D), and the intended number of hire days (N2) are

recorded. An optional preferred colour (S 12) may be recorded. A client may make any number of

bookings.

The assignment requirements:

The assignment requirements are to perform the following tasks:

1) Construct the information model. It is recommended that you use copies of the data dictionary

work-sheets available as part of this specification on FLO.

a. List all entities on the Entity Data Dictionary worksheet. Record the name, a description and

any aliases. In the Occurrence column described how the entity exists in the organisation. List

any dependent entities and indicated in the occurrence which entity it depends on.

b. List all relationships on the Relationship Data Dictionary worksheet. Record the name, a

description and any aliases. The Occurrence column describes how the relationship exists in

the organisation

c. List all relationships and entities on the Relationship-Entity Data Dictionary worksheet. For

each participating entity, give the multiplicity (both the participation and cardinality). If the

relationship is greater than binary then list other entities on subsequent rows

d. For each identified entity and relationship list its name and its attributes on the Attributes

Data Dictionary worksheet. For all attributes, give a description, an indication of the data type,

length and domain, whether it can be NULL (i.e. optional), and if it can be multi-valued. If it

can be multi-valued then list the range of values

2) Use your answer to (a) draw up an Entity-Relationship Diagram (ERD). The diagram can be hand

drawn. It should be at least A4 size. The important criteria are consistency with part (a), clarity

and readability.

Entities in the ERD should fully represent the information contained in the data dictionary. That

is, include all the attributes and any other necessary information. It should also conform to the

Unified Modelling Language specification discussed in lectures and the textbook. Using a different

modelling language will result in a grade of Fail with a mark of 1, which allows for resubmission

with a maximum mark of 50%. Using software that does not use UML is not an excuse. An example

of entities is shown in the figure.

Submission:

You are required to submit the work-sheets and the associated ER diagram electronically on FLO as a single

or set of PDF files. You may also optionally submit a document (a PDF) explaining any assumptions you have

made about the specifications. This may have to do with particular multiplicities you assign to relationships

and entities, different types of attributes, entities, relationships versus entities. Essentially any piece of

information you thought was ambiguous and you think requires additional explanation beyond tasks (1) and

(2).

Assessment:

This assessment is an individual assessment. The assignment is worth 25% of the total assessment. It will be

marked out of 25. A guide to the breakdown of the marks over the parts is:

(1) 10 marks (2.5 marks per answer for (a), (b), (c), (d) )

(2) 15 marks (Marks allocated for entity, relationship, and attribute layout, multiplicities and general

diagrammatic representation)

Academic Integrity, plagiarism and academic misconduct:

Plagiarism, which includes copying from internet resources or from other students, is not acceptable. While

using external sources for reference and inspiration is allowed, all work submitted must be original and

produced by yourself. Any external sources used must be appropriately cited and referenced in the

submission. Any evidence of copying or using identical answers from other students or external sources will

result in a grade of zero for the entire assignment.

For more information about the University policy of Academic Integrity, you can read further at the link:

https://students.flinders.edu.au/my-course/academic-integrity