Computers and Technology

Create an ERD using Lucid Chart for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. Don’t forget foreign keys and any specializations. A local library needs your help designing a database to keep track of books and the customers that check the books out. Each book has a unique ISBN, as well as a title and year that the library would like to track. The library keeps track of each customer name and email address. In addition, the library keeps track of book publishers and authors, and the name and address of each. The library also tracks the two types of publishers: academic and fiction. If a publisher is academic, they cannot be fiction and vice versa.
The library adds a customer to the database after they check out a book, and they can check out multiple books at a time. A book can be checked out by multiple customers but might never have been checked out. When a book is added to the database, its author and publisher are added as well. A book must have at least one author and if an author is in the database, he or she must be associated with a book. Each book may be written by multiple authors and each author may have written many books. A single publisher may have published many books, but each book has only one publisher. If a publisher is in the database, they must be associated with a book.

answer
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 09:50, shadow29916
What is a rush associated with alcohol?
Answers: 1
image
Computers and Technology, 22.06.2019 17:40, lazerlemon500
Write a modular program (no classes yet, just from what you learned last year), that allows two players to play a game of tic-tac-toe. use a two-dimensional char array with 3 rows and 3 columns as the game board. each element of the array should be initialized with an asterisk (*). the program should display the initial board configuration and then start a loop that does the following: allow player 1 to select a location on the board for an x by entering a row and column number. then redisplay the board with an x replacing the * in the chosen location. if there is no winner yet and the board is not yet full, allow player 2 to select a location on the board for an o by entering a row and column number. then redisplay the board with an o replacing the * in the chosen location. the loop should continue until a player has won or a tie has occurred, then display a message indicating who won, or reporting that a tie occurred. player 1 wins when there are three xs in a row, a column, or a diagonal on the game board. player 2 wins when there are three ox in a row, a column, or a diagonal on the game board. a tie occurs when all of the locations on the board are full, but there is no winner. input validation: only allow legal moves to be entered. the row must be 1, 2, or 3. the column must be 1, 2 3. the (row, column) position entered must currently be empty (i. e., still have an asterisk in it).
Answers: 1
image
Computers and Technology, 22.06.2019 22:40, ihatemylife0
Least square fit to polynomial write a function leastsquarefit3pol that solves a linear system of equations to find a least squares fit of a third order polynomial to an experimental data set given as two row arrays. the function leastsquarefit3pol must explicitly solve a set of linear equations and cannot use polyfit. there should be no restriction on the size of the problem that can be solved.
Answers: 1
image
Computers and Technology, 23.06.2019 04:20, RandomLollipop
Which network media uses different regions of the electromagnetic spectrum to transmit signals through air? uses different regions of the electromagnetic spectrum to transmit signals through air.
Answers: 2
Do you know the correct answer?
Create an ERD using Lucid Chart for the following description. Be sure to include all necessary enti...

Questions in other subjects:

Konu
Mathematics, 24.11.2020 19:00
Konu
Mathematics, 24.11.2020 19:00
Konu
Mathematics, 24.11.2020 19:00