🔒 Databases | Python | Page 1

lapis raven Oct 22, 2024, 6:10 PM

#

Hello Im in need of help for a homework

zenith mothBOT Oct 22, 2024, 6:10 PM

#

lapis raven Hello Im in need of help for a homework

#

@lapis raven

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.

lapis raven Oct 22, 2024, 6:10 PM

#

#

I have this database

#

tough drum Oct 22, 2024, 6:11 PM

#

that's not a database, that's a csv

lapis raven Oct 22, 2024, 6:11 PM

#

oh

tough drum Oct 22, 2024, 6:11 PM

#

Also we're not going to answer your quiz for you. You're the one being tested, not us

lapis raven Oct 22, 2024, 6:12 PM

#

it aint a quiz lmao

#

there a reason it a retake question

tough drum Oct 22, 2024, 6:12 PM

#

then what are you asking?

lapis raven Oct 22, 2024, 6:14 PM

#

im just a bit confused because i first chose surrogate key candidate and entity because wouldnt b_number be a unique identifier for identities?

tough drum Oct 22, 2024, 6:15 PM

#

I'm actually not too sure 😦

lapis raven Oct 22, 2024, 6:15 PM

#

oh dang

dense coral Oct 22, 2024, 6:16 PM

#

what's b_number

tough drum Oct 22, 2024, 6:16 PM

#

the first column

dense coral Oct 22, 2024, 6:16 PM

#

I know lol

#

but where does the data come from

#

how is it generated

#

A natural key is a key that is derived from the data itself, such as a customer ID, a product code, or a date. A surrogate key is a key that is generated artificially, such as a sequential number, a GUID, or a hash.

#

If it's some value that's not generated in the DB, I'd pick natural

lament zephyr Oct 22, 2024, 6:18 PM

#

Have you looked at the definition of an entity when it comes to a database?

dense coral Oct 22, 2024, 6:19 PM

#

lapis raven im just a bit confused because i first chose surrogate key candidate and entity ...

Being a unique identifier is what allows it to be a key, but you need to decide whether it's natural or surrogate

lament zephyr Oct 22, 2024, 6:21 PM

#

this link is better, talks directly about a database, but same idea as the IBM link https://www.gleek.io/blog/database-entity

lapis raven Oct 22, 2024, 6:26 PM

#

I see

#

I understand it better

#

B number is a number system my school uses

#

so it is most likely a natural key

lapis raven Oct 22, 2024, 6:45 PM

#

one quick question

#

i just realized it now but

#

since the B number always 8 characters char(8) would def be the best option right?

zenith mothBOT Oct 22, 2024, 7:46 PM

#

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.

#🔒 Databases