Enjoy Upto 30% off on all Your Assignments ORDER NOW
+61480015851 whatsapp white icon +61480015851 info@myassignmentservices.com

COMP1711: Procedural Programming - Wheels-4-U - Relationship-Entity Data Dictionary - Data Modelling Assignment Help

Download Solution Order New Solution

Highlights

Internal Code: 1AFIHC Code: COMP1711

IT Assignment Help

Assignment Task: COMP1711

Wheels-4-U, Relationship-Entity Data Dictionary - COMP1711

  1. 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. COMP1711
  2. List all relationships on the Relationship Data Dictionary worksheet. Record the name, a description, and any aliases. In the Occurrence column described how the relationship exists in the organisation.
  3. 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. COMP1711
  4. 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.
Wheels-4-U - COMP1711 Wheels-4-U The car hire firm Wheels-4-U, requires a database system to manage their fleet of hire vehicles. Each vehicle in the fleet has a unique fleet membership number (N 3). Also recorded is the vehicle's registration number (S 7), colour (S 20), and make (S 8) and model (S 8). Along with the make and model combination, also recorded is the number of doors (N 1), body style (hatch, sedan, SUV, or coupe), and trim level (standard, sport, luxury). Each Wheels-4-U depot has an identification code (N 2). Also recorded is the depot's address (A), 1 to 4 phone numbers (S 14), and a fax number (S 14). The current location (depot) of vehicles available for hire is recorded. Wheels-4-U has several different types of daily hire tariffs, for example, depending on the type of driver (e.g. under 21) or varied driving locations (city or country). For each type, an identification code (S 2) is recorded only with a description of the conditions under which it applies (S 50). For each make/model of car, the daily rental tariff ($ 3) is recorded for each of the tariff types. When a vehicle is hired, the depot from which it is hired, the hire time and date (D) are recorded. The intended drop off depot also 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. (For security reasons neither cash nor cheques are accepted by Wheels-4-U.) There will be one person recorded as being the nominated driver of the hired vehicle (this does not have to be the hirer). A vehicle's kilometreage (N 5) (distance travelled) is recorded when it is hired. At any one time only one vehicle is on hire to a customer. Also recorded is the applicable tariff type and the number of hire days (N 2). Optional insurance maybe taken for each hire. An insurance policy number (N 5), policy type (excess reduction, excess removal, or full cover) and cost ($ 3) is recorded. COMP1711 Make and model of vehicle may also be booked for a 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. Wheels-4-U records the individual details of any client the first time that the person or the company has business with the company. A client's name (C), address (A) and one or two contact phone numbers (S 14) are recorded along with a generated unique client identifier. This identifier is used for all subsequent references to that client. If the client is a company, they must have a (single) nominated person also recorded as their representative. The details of such representatives are recorded as though they were person clients. 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. COMP1711 For each vehicle, a service history is kept. It contains for each past service, (scheduled or repair service), the date (D), the cost ($ 4), a service description (S 50) and the identification of the depot where the servicing was done. A vehicle may have had none or several past services. For all vehicles, the next scheduled service has the associated kilometrage (N 5), date-to-be-done-by (D) and the depot to do the servicing recorded. COMP1711 Only after the vehicle is returned an invoice is generated for the vehicle hired (with a unique invoice ID (N 10) that contains the details or the hirer (and company if applicable), the vehicle hired, the return depot, an indication that the vehicle passed a quality check (a ‘Yes’ or ‘No’) and the final cost ($ 5) based on the number of days and the daily rental tariff. The date paid (D) is also recorded and if it has not been recorded the invoice is considered unpaid. Questions: The “Operations and Questions” are here to help verify/validate you design. You do not need to provide answers to questions for the assignment. COMP1711
  • Add a new hire
  • Add a new vehicle to the fleet
  • List all hires for the last month
  • Which make of vehicle has had the most hires?
  • Which make of car is the most/least popular?
  • Which depot has the most vehicles available for hire?
  • Which depot is the most popular based on hires?
  • List all the hires with a the number of hire days more than X.
  • List all the vehicles that have a scheduled service soon (in the next month).
  • List all vehicles that do not currently have a future hire booked
  • List all invoices that have not been currently paid.
  • What are the different daily rental tariffs for tariff ID “C1” for each of the make/models?
This COMP1711: IT Assessment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.

Find My Solution

© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.