Scribd
Upload
8 views1 page

Document SQL

Uploaded by

giftkunuba
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views1 page

Document SQL

Uploaded by

giftkunuba
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

 Here is the updated SQL code with the provided information:

```

 Insert data into Students table

INSERT INTO Students (Student_ID, Name, Email, Date_of_Birth, Gender)

VALUES (‘fos/20/21/272586’, ‘Gift Kunuba’, ‘[email protected]’, ‘2002-


02-14’, ‘Male’);

 Insert data into Courses_Enrolled table

INSERT INTO Courses_Enrolled (Course_ID, Student_ID, Course_Name, Grade,


Semester)

VALUES (‘CSC 212’, ‘fos/20/21/272586’, ‘Database Management’, ‘A’, ‘First


Semester’);

```

Note: I assumed that the `Grade` and `Semester` columns can be updated
later, so I provided placeholder values (‘A’ and ‘First Semester’). Also, the
`Student_ID` in the `Courses_Enrolled` table matches the `Student_ID` in
the `Students` table to establish the relationship.

Please let me know if you need further assistance!

You might also like