Question: MY SQL CODE FOR : A student and faculty can issue books. Different limits for the number of books a student and teacher can issue.

MY SQL CODE FOR : A student and faculty can issue books. Different limits for the number of books a student and teacher can issue. Also, the number of days will be distinct in the case of students and teachers for issue any book. Each book will have different ID. Also, each book of the same name and same author (but the number of copies) will have different ID. Entry of all the book will be done, who issue that book and when and also duration. Detail of Fine(when the book is not returned at a time) is also stored.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Create a library maragement database in C language using files where a student and faculty can issue books. Different limits for number of books a student and teacher can issue. Also, the number of...

Question No.2 (25) Create a library management database in C language using files where a student and faculty can issue books. Different limits for number of books a student and teacher can issue....

Create a library management database in C language using files where a student and faculty can issue books. Different limits for number of books a student and teacher can issue. Also, the number of...

Do is quickly Create a library management database in C language using files where a student and faculty can issue books. Different limits for number of books a student and teacher can issue. Also,...

For the first part of your team project, you suppose to create an ER diagram for a following database system: Library Management System Database A student and faculty can issue books. Different...

Draw ER diagam: This is supposed to develop a database to manage online library management system (A student and faculty can issue books). Your product should contain information about courses,...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Explain People First Language (including several examples of correct terminology) and Describe FERPA. Do Now Activit Vs 1. Get a piece of paper and label 2 columns as below: Not so Nice Reframed 2....

Tallahassee bean counters case solution and all the 5 questions beginning of the case. Also describe about equipment purchased fraud and how it was committed? NOTICE Do not make Teaching Notes...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

Who prevails and why? Discuss.

The common law did not hold parents liable for their childrens unintentional torts unless the parents negligent supervision led directly to the tort. But the common law did hold husbands vicariously...

The most sensille method for budgeting for promotion expenses is to allocate some foxed percentage of net sales. allocate all available funds. allocate money for direct - response promotion first and...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

LO1 Understand human resource management and define human capital.

2. Systematically select workers so that they fit the job, and train them effectively

4. Support workers by carefully planning their work and smoothing the way as they do their jobs.