(Fall 2020) (Given 11/24/20 Homework #4 Due: 12/10/20) Following is a data description of a library: The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is | available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan. Implement the database using mySQL server. Use company sol files as templates:

C++ for Engineers and Scientists
4th Edition
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Bronson, Gary J.
Chapter8: I/o Streams And Data Files
Section: Chapter Questions
Problem 2PP: (Data processing) a. Store the following data in a file, or use the numbers.dat file provided on...
icon
Related questions
Question
CSC 235.S70 (Fall 2020)
Homework #4
(Given 11/24/20
Due: 12/10/20)
Following is a data description of a library:
The library provides books to borrowers. Each book is described by title, edition,
and year of publication, and is uniquely identified using the ISBN. Each borrower
is described by his or her name and address and is uniquely identified using a
borrower number. The library provides one or more copies of each book and each
copy is uniquely identified using a copy number, status indicating if the book is |
available for loan, and the allowable loan period for a given copy. A borrower may
loan one or many books, and the date each book is loaned out and is returned is
recorded. Loan number uniquely identifies each book loan.
Implement the database using mySQL server.
Use company sql files as templates:
• Company-schema.sql
• Comapy-data.sql
In your schema make sure you do:
(1) Identify all relations of the library database. (relations are tables; relation can
be an entity (a rectangle) or a relationship (a diamond))
(2) Identify the attributes of each relation. (table columns)
(3) Identify the primary key of each relation. (underline)
(4) Identify the foreign key of each relation if any. (arrows to primary keys)
Generate some data to populate and test your database.
Once the database is implemented (mySQL) create three queries, report the
English equivalent of the queries, and report the queries result.
You would need to submit:
1. Library-schema.sql
2. Library-data.sql
3. A sql text tile with the three queries, its English word description and the
results.
Transcribed Image Text:CSC 235.S70 (Fall 2020) Homework #4 (Given 11/24/20 Due: 12/10/20) Following is a data description of a library: The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is | available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan. Implement the database using mySQL server. Use company sql files as templates: • Company-schema.sql • Comapy-data.sql In your schema make sure you do: (1) Identify all relations of the library database. (relations are tables; relation can be an entity (a rectangle) or a relationship (a diamond)) (2) Identify the attributes of each relation. (table columns) (3) Identify the primary key of each relation. (underline) (4) Identify the foreign key of each relation if any. (arrows to primary keys) Generate some data to populate and test your database. Once the database is implemented (mySQL) create three queries, report the English equivalent of the queries, and report the queries result. You would need to submit: 1. Library-schema.sql 2. Library-data.sql 3. A sql text tile with the three queries, its English word description and the results.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Literals
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning