IDBS-Spring20-Fudan/assignment1/readme/

[utterances-bot]

Instruction - IDBS-Spring20-Fudan

Course website for introduction to database systems at Fudan University

https://zfhu.ac.cn/IDBS-Spring20-Fudan/assignment1/readme/

[ichn-hu]

You could also ask questions here~

[Tan-YiFan]

What about the DDL?

[mirackk]

“Once you've cloned the project in your local environment, get to IDBS-Spring20-Fudan/assignments/submission and create a directory and name it by your student id, for example IDBS-Spring20-Fudan/assignments/submission/16307130177, and this directory will be your working directory. You are ONLY allowed to modify files under this directory, any other modifications outside this directory will make your submission invalid.”
请问这个提交目录是建在我自己fork下还是助教您的页面？以及找不到IDBS-Spring20-Fudan/assignments/submission，应该是IDBS-Spring20-Fudan/assignments/ass1/submission吗

[ichn-hu]

“Once you've cloned the project in your local environment, get to IDBS-Spring20-Fudan/assignments/submission and create a directory and name it by your student id, for example IDBS-Spring20-Fudan/assignments/submission/16307130177, and this directory will be your working directory. You are ONLY allowed to modify files under this directory, any other modifications outside this directory will make your submission invalid.”
请问这个提交目录是建在我自己fork下还是助教您的页面？以及找不到IDBS-Spring20-Fudan/assignments/submission，应该是IDBS-Spring20-Fudan/assignments/ass1/submission吗

在你自己 fork 的仓库下，clone 之后去新建。你说的对……路径是我打错了，马上改。

[TwistsOfFate]

6. Query the names of all publishers, if one publisher has more than two books in the database, output the name of the publisher only once (ordered by name, ascii order)

"(ordered by name, ascii order)": Which does name refer to, book.name or book.publisher?

[ichn-hu]

1. Query the names of all publishers, if one publisher has more than two books in the database, output the name of the publisher only once (ordered by name, ascii order)

"(ordered by name, ascii order)": Which does name refer to, book.name or book.publisher?

Of course it is the publisher's name, since I only asked you to output the names of the publishers.

[mirackk]

请问一下在workbench写sql的时候，大小写有区别吗？书上的语句全是大写，但是好像小写也能用？

[Tan-YiFan]

The name of the third table should be 'loan' or 'record'?

[ichn-hu]

请问一下在workbench写sql的时候，大小写有区别吗？书上的语句全是大写，但是好像小写也能用？

MySQL 不区分大小写的，都可以

[ichn-hu]

The name of the third table should be 'loan' or 'record'?

record

[Tan-YiFan]

Will the test script be provided for us?

[ichn-hu]

Will the test script be provided for us?

Yes, just be patient, I am working on it.

[Tan-YiFan]

Will the test script be provided for us?

Yes, just be patient, I am working on it.

'''
Query the names of all publishers, if one publisher has more than two books in the database, output the name of the publisher only once (ordered by name, ascii order)
'''

Does it mean "Query the names of publishers having more than 2 books, without repetition" or "Query the names of all publishers having published books without repetition. Deal with publishers who has exactly two books in a different way. (You wrote MORE THAN TWO, not including two)" ?

And can I get the test script before ddl? I'm very afraid that I wouldn't pass the tests in the first assignment which seems not very complex. Or can you offer me some teaching notes about how to debug sql? Very Thanks!

[ichn-hu]

Will the test script be provided for us?
Yes, just be patient, I am working on it.

'''
Query the names of all publishers, if one publisher has more than two books in the database, output the name of the publisher only once (ordered by name, ascii order)
'''

Does it mean "Query the names of publishers having more than 2 books, without repetition" or "Query the names of all publishers having published books without repetition. Deal with publishers who has exactly two books in a different way. (You wrote MORE THAN TWO, not including two)" ?

And can I get the test script before ddl? I'm very afraid that I wouldn't pass the tests in the first assignment which seems not very complex. Or can you offer me some teaching notes about how to debug sql? Very Thanks!

The latter.

The test script is actually the second assignment. Do not worry if you made any mistakes in assignment 1, you are allowed to argue.

As for debugging SQL, just send the SQL to MySQL, and MySQL will tell you the result. You'll understand how to debugging SQL in assginment 2.