Different data in my computer

SQL
1

Hi again.
When getting the table from “sql_hr” database, i read different data in “office_id” column,
from the example in lesson .
The value is “10” in all the rows in your lesson but I do Have different values.
Any help to fix that in order to follow the course as well as possible?

sql_hr tables
sql_hr tables824×574 46.1 KB

Thank you.

EnricH

2

Perhaps you created the “sql_hr” database incorrectly? There may be different variants, and I would advise you to consult a specialist in order not to make things worse. As far as I know, service centers or companies do this kind of thing. I know of one. Here it is - salvagedata.com. Once when I had a problem, I asked an acquaintance for help, and it was a mistake. The next day I went to a professional to save my computer. However, your question is really interesting. I’ve never come across anything like this before.

3

I did not take the data structure course.
From the screenshot it seems to be neither SQL Server. Is it correct?

Is sql_hr a database provided in the resources from the course?
Did you create it along from the course instructions?
The best approach would depend on that.

If you did not modify them yourself I’d argue this may not be a big deal. Just the dataset would not be that much interesting to work with because all your employees refer to the same office.

This is in the context of a course so I’d suggest to just update a few entries manually.

SQL SERVER T-SQL statements

BEGIN TRANSACTION

UPDATE sql_hr
SET office_id=1
WHERE employee_id IN (33391, 37851,40448,56274);

UPDATE sql_hr
SET office_id=2
WHERE employee_id IN (63196,67009,67370,68249);

SELECT * from employees;

ROLLBACK TRANSACTION

You get the idea.
If the result satisfies you, repeat without {BEGIN|ROLLBACK} TRANSACTION or replace ROLLBACK TRANSACTION with COMMIT.

4

Perhaps you created the “sql_hr” database incorrectly? There may be different variants, and I would advise you to consult a specialist in order not to make things worse.