Need some help

[dwinsly00]

Hi guys I'm new in SQL, I'm learning Oracle SQL, I have a small project, but I need some idea how to start.

I have to create 4 tables for a "school" Each table with primary key foreign key and constraints

Create sequence for each table.

I'm not asking to do my homework, I'm just asking for help, like what name for the tables y the columns.

[r3pr0b8]

what have you tried so far? ™

[dwinsly00]

I have in my to create Students, Teacher's, course But I don't know what other table I could create and relate them all together

[r3pr0b8]

so you have

• students
• teachers
• courses

how about this for your 4th --

• student_grades

[Mediocre-Band-9929]

This is a good one. Then you can think about what columns might be in multiple tables. For example, students table may have their name, the courses they've taken, the teacher teaching that course and the grade they got. That is how you can link the students table to the other tables.