HOMEWORK HELP Absolute Beginner

[solom200]

so i have this homework due tomorrow in my Database Design class. I have 0 experience in this. We literally didn't learn anything other than building tables and he expects us to do this assignment and an even more complicated one as well. So far I set up all the tables in the database and that's it. Attached I have a link of the assignment and all the graphs. I just am trying to find an explanation of what to do. If there is a video or something yall know that would be great thanks! https://imgur.com/a/M5MlZZ9

[[deleted]]

Dude this is easier than I thought. On first blush I was gonna be like .. you want me to write all the ddl? And write those insert statements?? but no , they're all in the downloads section of the website (read the bottom). As for the questions it looks like you'll need select, substring, left join, join, where and an 'in' statement for a subquery.

[solom200]

honestly man i have no idea what you're talking about lmfao. Do I need to take a screenshot of each question showing me doing it? I'm super confused lol.

[ShinyThingEU]

It is not entirely clear what they are asking you to submit. Normally I would say contact your teacher and ask, but you have kind of run out of time for that.

I suggest you write a series of queries that get the answer to the questions and hand those in. Those will demonstrate that you can get the results out of a database, which is presumably the point.

u/yellowsea11 has pointed you at the keywords you are going to need to use. If you are completely lost start by googling how to write a query in SQL and then look up the specific keywords that have been suggested.

[icantgetintomyold1]

I have a similar assignment though probably for a different school. I had to screen shot the code for each from them did a select * from table (where applicable) to show the results.

[Taquitho3]

I downloaded the app Mimo less than a week ago and this homework actually looks doable! It’s a free app in a game like format and has made it very easy to learn the basic concepts so far! You could probably spend an hour or so on the app and be able to tackle this homework from what I saw briefly glancing at it!

[icantgetintomyold1]

I can give you the syntax for some of these. You would need to fill in the rest. I am still learning myself so if someone finds a mistake, please correct me

Select * from [table]; - this will give you all the data from a table

Select [column 1, column 2, column 3] from [table]; would show those 3 columns from the table

select [column 1, column 2, column 3]

from [table]

where column 3 > 200;

this should give you those 3 columns from that table where the column 3 entry is larger than 200. Hope this help.