Structures for Tables in SQL, please A library database contains the following i
ID: 3599107 • Letter: S
Question
Structures for Tables in SQL, please
A library database contains the following information: Library is organized into sections, like Arts, Children, Sciences, and so on. Each section has a name, a number, description and is headed by a librarian. Each book belongs to a section, has a title, authors, ISBN, call number, year and publisher. Each book has several copies. For each copy of the book, keep track of the current borrower, the due date and the librarian who charged it out. An author has id, full name, and gender. An author could have written many books. Members of the library have membership number, a driver's license number, an address, a phone number and a birthday. Members could borrow books and hold books. Librarian has a name, number, phone, ssn, and address. using SQL to cresate tables in your database under your mysal account. 3) structures of tables in a script file. (You could run "describe tableName" after you create these tables in your database).Explanation / Answer
Below are the sql statements to create tables in the database.