IDBS-Spring20-Fudan/assignment3/readme/

[utterances-bot]

Instruction - IDBS-Spring20-Fudan

Course website for introduction to database systems at Fudan University

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

[HatsuneHan]

Whether it means that we can add more properties to book/student such as a bookid to identify each book as long as we meet all the requirements.
And whether the administrator's and students' accounts means that we should use some codes to create the accounts and give them some permissions or just use common strategies to simulate them (maybe parameters of a func ) without creating them actually.

[HatsuneHan]

I think I solve the second problem I have asked before, but I want to make sure something

Who "query the borrow history of a student account" and
"query the books a student has borrowed and not returned yet"(also,check deadline, extend deadline)?
A student query his/her own or the administrator?

(Of course, these two situations are similar,I just want to make sure)

[ichn-hu]

Yes you can add mote properties. You are actually not restricted to do any thing. The requirements are kind of loose, you could make any reasonable modification and handle the vagueness in the requirements by your own design choices, just make sure you document and explain well in the report, and please justify your design choice whenever possible.

As said, for your second commemt, which way do you think is more proper? (I think both the student and the administer should be able to query.)

Actually, the difference in characters of users is up to you to design, and you are free to make any design decisions as long as your design is sound and the requirements are met (as long as you could explain the requirements are met, meaning you could somehow argue about it)

[riteme]

Should we write Go tests on a real MySQL database or just a mock database (e.g. go-sqlmock)? Is it better to include table creation procedure in Go sources?

In my view, actual database setup is supposed to be separated from the library system, and the system is merely responsible for the specification of tables it relies on.

[ichn-hu]

I would suggest test it on actual database, and try to import some actual data in to the database.

I wouldn't say better, but it is okay.

The database is indeed part of the system, and you should make sure it works.

[Tan-YiFan]

If I've implemented a simple command line interface, should I write tests on back-end (using test functions) or on front-end (e.g. using .sh scripts), or both?