**CSC 235.570 (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- Company-data.sqlIn 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 results.You would need to submit:1. Library-schema.sql2. Library-data.sql3. A SQL text file with the three queries, its English word description and the results.

Actually, database is used to stores the data.

(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:

(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:

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: · Use Cases · Use Case Scenarios (At least 5) · Sequence Diagrams · Activity Diagrams · State…

Q: When someone says "user-defined data types," what exactly do they mean?

A: Answer User-defined data types refer to data types that are created by users or developers of…

Q: PERL programming: sort the data according to the employees salary (the last column). Use the…

A: Certainly! The Schwartzian transform involves a process of decorating, sorting, and undecorating a…

Q: Memory Allocation: Select all of the following statements that are true. The basic idea of…

A: Memory allocation is a crucial aspect of computer systems, ensuring efficient utilization of memory…

Q: Q2) Write a relational algebra expression that returns food items that are sold at "Aldi" and their…

A: The answer is given in the below step

Q: What does the data type defined by union will do? a) It allow one different portion of memory to be…

A: Union is used to define the data type of our choice and it will store the data type in one location…

Q: Programming Assignment III In this assignment you are required to be researching some sorting…

A: Actually, the code has given below:

Q: Software Function Research Direction: The student will complete the matrix by defining each…

A: Since you have posted a question with multiple subparts, we will provide the solution to the first…

Q: Question-related to R code The English Premier League (EPL) is a major soccer league in Great…

A: Actually, given information The csv data files available via the weblink provided above contain a…

Q: Addition Rule Product Rule Log Exponent Rule Log Base Rule Transitivity In the following…

Q: Consider this structure definition: typedef struct movie { char *title; uint8_t rating; uint16_t…

A: Below is the correct answer with explanation:

Q: PROBLEMS and Selection Structures Logical Operators: Find 8.1 A sensor that monitors the temperature…

A: Algorithm: Start Set hot_tub…

Q: Given a MYSQL database with URL "jdbc:mysql://localhost/test" that consists of the following schema:…

A: This step is optional if you already have database in required state i.e. Marks table with some rows…

Q: Suppose you have just opened a file pFile on permit request records with the following data formats…

A: yes it is, The correct option for this question is : fscanf (pFile,"%s %d %s" , course_id, &…

Q: Sorting Project 1/3 (C++ Programming) Data Structures I need to know what are the three function…

A: Define three functions named GenerateRandomInputFiles(), GenerateSortedInputFiles(), and…

Q: Q4) Write a relational algebra expression that returns the items and their price for all items of…

A: Relational algebra which refers to the one it is a procedural query language that is used to work…

Q: b) Implement a stored PL/SQL function that finds a supplier who supplies the cheapest (lowest supply…

A: A stored procedure is SQL code prepared so that the code can be saved for repeated use. So if you…

Q: J 1 Module 1 Assignment Part 1: Analyzing Regional Sales Information for MTSU Auto (MO-1.1, 1.2,…

A: You have several options when you want to enter data manually in Excel. You can enter data in one…

Q: 3. (MS) Consider the relation R6 on P({0,1,2, 3}) such that (A, B) e R6 if and only if A C B. Select…

A: This is of discrete mathematics

Q: Try to answer all the questions based on what you were learned. • please write the RA's…

A: πrecipe(σtype='Meat'(ingredient⋈foodItem=item foodItem)) ⋈ selects a common item from ingredient and…

Concept explainers

Literals

A literal in computer science is used to express a fixed value in source code. They cannot be modified. Almost all programs have these fixed values or literals.

Question

**CSC 235.570 (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
- Company-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 results.

You would need to submit:
1. Library-schema.sql
2. Library-data.sql
3. A SQL text file with the three queries, its English word description and the results.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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

Analyze the problems carefully. Create the programs of the following. 1. Ages and Stages (Fle name: Age_Lastname) Create a program that checks as to which stage an age is. Use the table below. Age 5-12 years Stage Grade-schooler 13-17 years Теen 18-21 years Young adult 2. LRT-2 Single Journey Fare Matrix (File name: LRT_Lastname) Create a program that displays the fare based on the entered destination. The starting station is Araneta-Cubao. Use the table below. Use the code destination to shorten the user's input. Destination Fare Recto (Re) J. Ruiz (Jr) Gilmore (Gi) PHP 20 PHP 15 PHP 10
Q1: Research Groups In response to popular demand, Dan’s established two research groups A and B composed of his n graduate students. Each of these students is a member of exactly one of the two groups at any given time. The students are numbered from 1 to n in some arbitrary order. To measure the success of his research groups, Dan assigns a citation score to each of them. Initially, both groups have citation score 0. Throughout the semester, events of the following two types happen: Student x publishes a paper in which they cite student y’s work (youcan assume all of the students have been around long enough to have prior research that can be cited). As a result, If x and y are in the same group, their group’s citation score increases by 1. If x and y are in different groups, y’s group’s citation score increases by 5. Dan changes student x’s group (from A to B or from B to A) to have them work on different projects. To assess the overall success of the research groups, Dan…
*Data Structures and Algorithm (C Programming) In economics, arbitrage is the practice of taking advantage of a difference in prices in two or more markets; striking a combination of matching deals to capitalize on the difference, the profit being the difference between the market prices at which the unit is traded. Arbitrage can become a source of gain when applied to currency exchanges. Consider the fol- lowing currency exchange ratios as an example: 1 U.S. dollar buys 0.7292 euros, 1 euro buys 105.374 Japanese yen, 1 Japanese yen buys 0.3931 Russian rubles, 1 Russian ruble buys 0.0341 U.S. dollars. Then you could take 1 U.S. dollar and buy 0.7292 euros with it, with which you can buy 76.8387 yen (because 0.7292 * 105.374 = 76.8387). Then take the 76.8387 yen and buy 30.2053 rubles (because 76.8387 * 0.3931 = 30.2053), and finally take the 30.2053 rubles and buy 1.03 dollars (because 30.2053 * 0.0341 = 1.0300). Assume that you are given the pairwise trading ratios among n…
Q2) Recently science students were asked if they had difficulty in obtaining their course books from libraries. The diagram indicates their 55% sometimes responses. Changing the percentage figures to quantity qualifications, describe the information, e.g., 25% often 10% rarely A few students were never able to obtain their course books from 5% 5% always never libraries. (students) %