🔒 Uni project please help

[wind ridge]

I have a presentation due in 40 min and i just drew this data structure with a gui design for a scooter rental please tell me if the data structre is made well becuase this is my final exam

[chilly thistle]

@wind ridge

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[opal terrace]

sorry but

[chilly thistle]

Rules

The rules and guidelines that apply to this community can be found on our rules page. We expect all members of the community to have read and understood these.

[hoary gate]

Cutting it kind of close huh?

[wind ridge]

very

havent slept in 3 daus

[opal terrace]

!rule 8

[chilly thistle]

Rules

8. Do not help with ongoing exams. When helping with homework, help people learn how to do the assignment without doing it for them.

[wind ridge]

this is not exam

@opal terrace was a typo personal project

i just got to know pls is the data stracture good ?

[hoary gate]

sleep is to programmers what steroids are to weight lifters

[rigid lodge]

Where do you store the locations of the scooters?

Addresses or coordinates?

[wind ridge]

your right

thank you

got to add that

[rigid lodge]

What is First_Maintenance and Last_Maintenance?

[wind ridge]

its for the service team that should add when they did fixing

[rigid lodge]

what are they adding?

It looks like a number but what?

[wind ridge]

the date of service

[rigid lodge]

Its bigint tho?

[wind ridge]

i set it to date

in e-scooter of last maintenance and for first and last on team

[rigid lodge]

Maybe need the cost from servicing so it can be totalled in Rental table, perhaps?

[wind ridge]

will it be directly connected with renatl and service team ?

[rigid lodge]

The dashboard shows a "Booking" but I don't see a booking table or something that can be part of a full booking screen

[wind ridge]

maybe i just remove the booking part

[rigid lodge]

One or the other. But I would expect that you would breakdown the cost of servicing/maintenance, so you know how much is spent on always fixing a breaking down scooter over a period of time.

[rigid lodge]

Dashboard doesn't show who's currently logged in

[wind ridge]

i have connected the maintanace cost to total cost

the thing im worried about it the order is messed up

[rigid lodge]

Where do you store the status of the scooter? E.g. values I see in the dashboard "Returned", "Charging", "Rented"

[wind ridge]

i was thinking of set it in the rental tab as status

[rigid lodge]

Disconnect it. It doesn't make sense.

Also your connections doesn't make sense either. Is this supposed to show One to Many, Many to Many, One to One?

[wind ridge]

honestly i dont know becuase i was only focusing on the order of the tables

and i used an example of how to connect them with my previous

the order i was trying to make was renter pays for the scooter then the information about payment goes to the rental table in the payment id

[rigid lodge]

you have renter_id and user_id. renter_id is from Renter table. Where is user_id from?

[rigid lodge]

payment should go to the payment table with new payment ID

[wind ridge]

if i add this

[rigid lodge]

So Rental table to Payment table is One to Many

[rigid lodge]

Whats the diff between User table and Renter table?

[wind ridge]

renter and user is same

but i didnt specify it

[rigid lodge]

idk man, its your project. Make it make sense.

[wind ridge]

if i change user id to renter id

will that work better

[rigid lodge]

yeah

[wind ridge]

okey thanks for help

hope it all goes well

presenting in 15 min

[rigid lodge]

good luck 🦾

[chilly thistle]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.