Please describe how to implement a SQL database that tracks branches, books, and customers for a lending library? What if we want to keep track of multiple authors for each book? What if we want to keep track of DVDs, as well?

Question

Please describe how to implement a SQL database that tracks branches, books, and customers for a lending library?  What if we want to keep track of multiple authors for each book?  What if we want to keep track of DVDs, as well?

Sigiloso · Accepted Answer

I followed the principles of database normalization to design this ficticious database.

@hand

Pergunta de entrevista da empresa @hand

Resposta da entrevista

Empresas seguidas

Buscas de vagas