How should I create a table that best works well with this information? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

How should I create a table that best works well with this information?

I apologize if this information doesn't end up being enough. I'm new to this, but this is the only information our teacher gave us to use: Students(Sid int, Name string) Teachers(Tidint, Name string) Subjects(Subidint, Name string) Grades(studentIDint, teachersIDint, subjectIDint, grade string)

15th May 2022, 10:06 PM
Here2Be
5 Answers
+ 2
Hello Here2Be Weclome to Sololearn. We would like to help but you must first show some attempt. Please read the community guidelines. https://www.sololearn.com/Discuss/3021159/?ref=app https://code.sololearn.com/W1AxdV4e2H68/?ref=app
15th May 2022, 10:13 PM
Chris Coder
Chris Coder - avatar
+ 2
You can do this using SQL or Python (or many other languages). The implementation depends on the language you're supposed to use. If you're using SQL take a look at CREATE TABLE.
15th May 2022, 10:49 PM
Simon Sauter
Simon Sauter - avatar
+ 2
Your teacher wants you to create four tables. The first three have two columns each: an id column of type integer and a name column of type string. The fourth has three different id columns of type integer and a grade column of type string (which suggests a letter or word grade). Based on how the information is presented my guess is that you're supposed to use SQL. You can take the SQL course here on sololearn to find out how to do it.
16th May 2022, 1:25 AM
Simon Sauter
Simon Sauter - avatar
+ 1
You can use html and set as many tables as u want using <table> tag with other relevant tags But I don't understand the information you gave
15th May 2022, 11:54 PM
Mikeey
Mikeey - avatar
+ 1
Thank you for letting me know Chris. I didn't get shown the guidelines when making the account, so I didn't realize. I apologize. And thank you Simon for giving me a better perspective on exactly how I should go about trying to start this off. And thank you Michael for making me aware about this. I will ask my teacher because they kind of just handed it to us and expected us to know what to do.
16th May 2022, 1:16 AM
Here2Be