**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

Similar questions

Student students[3]; for(int i=0;i<3;i++) fillStruct(&students[i], records[i]); for (int i = 0; i < 3; i++) { printf("Student Name: %s, ",students[i].name); printf("Student ID: %s, ",students[i].id); printf("DOB: %s, ",students[i].ddmmyyyy); printf("City of DOB: %s\n",students[i].cityBirth); } %3D } Task3.1: the program above calls the function fillstruct and provides as arguments one record entry of a student and a pointer of a struct. The function must fill the struct with information of the record. However, for the date entry, the date is provided in a format that needs to be changed: instead of YYYY-MM-DD the date should be filled in the struct as DD- MM-ҮҮҮҮ. Define the function that does the above task void fillStruct(struct studentStruct *std, char currentStd[4][5®]);
Member m = new BoardMember(); Is this statement legal or illegal and widening or narrowing conversion.
General Computer Accessory Company: In General Computer Accessory Company (GCAC), each product (described by product number (primary key (PK)), description, and cost) comprises at least one component and can comprise many components (described by component number (PK), description, and unit of measure), and each component is used to make zero to many products. GCAC keeps track of the quantities of products and components in the manufacturing process. In addition, a component can be used to make zero to many other components and a component can consist of zero to many other components. GCAC also keeps track of how many components go into making some other components. Draw an ER diagram using Draw.io Links to an external site.and insert the diagram (as an image file exported from the drawing tool; ensure that the image is a clean ER diagram that does not contain non-relevant details such as tool background and buttons) in a file (enter your full name and assignment number on the first…
p.77, icon at Example 6 #5. Determine whether this argument is valid: Lynn works part time or full time. If Lynn does not play on the team, then she does not work part time. If Lynn plays on the team, she is busy. Lynn does not work full time. Therefore, Lynn is busy.
Operator definition [1 Mark] Give examples to explain the following operator. [2 Marks] I Arithmetic [2 Marks] ii) Relational [2 Marks] iii) Logical
DISCRETE STRUCTURE What is the minimum number of students, each of whom comes from one of the 13states, who must be enrolled in a university to guarantee that are at least100 comefrom the same state
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…
(6) discrete Structure: Please solve it on urgent basis: Question # 6: Use resolution to show that the hypotheses “It is not raining or Yvette has her umbrella,” “Yvette does not haveher umbrella or she does not get wet,” and “It is raining or Yvette does not get wet” imply that “Yvette does notget wet.”
Customer (CID, CName, Street, City, State, Gender)Agent (AgentID, GName, Position, Salary, Gender, BranchNo)Invoice(InvoiceNo, CID, AgentID, Product, Quantity, Total_amt) List the name of agents, position and salary for all agents that begin with ‘Sales’ in their title position and with salary more than the average salary. Example of titles with ‘Sales’ are ‘Sales Executive’, ‘Sales Manager’, ‘Salesman’ and many other titles. Sort the list by name in alphabetical order
Holiday Travel Vehicle (HTV) sells new recreational vehicles and travel trailers. When new vehicles arrive at HTV, a new vehicle record is created. Included in the new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost. When a customer arrives at HTV, he or she works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed upon, a sales invoice is completed by the salesperson. The invoice summarizes the purchase, including full customer information, information on the trade-in vehicle (if any), the trade-in allowance, and information on the purchased vehicle. The invoice also summarizes the final negotiated price, plus any applicable taxes and license fees. If the customer requests dealer-installed options (simply options), they are listed on the invoice as well. A customer may decide to have no options added to the vehicle or may choose to add many options. Dealer-installed options are described by an option code,…
ELECTRICITY МАСHINE EXPENDITURE belong # code * month name cost * kw have Above ERD will be modified according to following information. In order to correctly analyze the cost of electricity of machines, it is requested to know unit price of electricity each month. Make necessary changes on ERD and present only effected structures (entities, attributes and relationships) A- B I