×
Samples Blogs Make Payment About Us Reviews 4.9/5 Order Now

Create a Program to Create Library Management System in SQL Assignment Solution

July 04, 2024
Dr. Heather Richards
Dr. Heather
🇬🇧 United Kingdom
Database
Dr. Heather Richards, a seasoned professional holding a Ph.D. from New York University, possesses over 6 years of extensive experience in SQL assignments. With a meticulous eye for detail and a commitment to excellence, Dr. Heather has successfully completed over 600 SQL assignments, earning praise for her thoroughness and expertise.
Key Topics
  • Instructions
  • Requirements and Specifications
Tip of the day
For HTML assignments, ensure that your code is clean and properly indented. This improves readability and helps identify errors quickly. Use semantic tags (like <header>, <article>, and <footer>) to enhance accessibility.
News
In 2024, the new programming language Mojo is gaining traction among AI-focused programming students, promising Python-like simplicity with speeds closer to C++ for AI and scientific applications​.

Instructions

Objective
Write a SQL assignment program to create library management system.

Requirements and Specifications

program to create library management system in SQL
program to create library management system in SQL 1

Source Code

COLLEGE

import java.util.ArrayList;

import java.util.Random;

public class College {

private ArrayList students;

private Library library;

private Random random;

public College(int n_students, int n_books) {

library = new Library(n_books);

tudents = new ArrayList ();

// now, add n_dtudents

for(int i = 0; i < n_students; i++) {

students.add(new Student("Student " + (i+1), library));

}

random = new Random();

}

// getters and setters

public ArrayList getStudents() {return students;}

public Library getLibrary() {return library;}

public Random getRandom() {return random;}

// methods

public void describe() {

System.out.println("The college currently has " + getStudents().size() + " hard-working students");

getLibrary().describe();

}

private void nextStep() {

if(getStudents().size() == 0) // no students left

{

System.out.println("Everything has gone quiet.");

}

else

{

// Pick a random student

// Pick index

int index = getRandom().nextInt(getStudents().size());

Student student = getStudents().get(index);

if(student.finishedStudies())

{

// Remove student

students.remove(index);

System.out.println("The student has graduated and left the college.");

}

else{

student.study();

}

}

}

public void runCollege(int nSteps) {

for(int i = 1; i <= nSteps; i++)

{

System.out.println("Step " + i);

describe();

nextStep();

}

}

public static void main(String[] args) {

// First of all, create a College

// Define the number of students and books

int n_students = 10;

int n_books = 15;

College college = new College(n_students, n_books);

college.runCollege(100);

}

}

LIBRARY

public class Library

{

private TextBook[] bookShelf;

private int nextBook;

private int borrowers;

public Library(int numOfBooks)

{

bookShelf = new TextBook[numOfBooks];

for (int i = 0; i < bookShelf.length; i++ ) {

String title = "text_" + i;

bookShelf[i] = new TextBook(title,5);

}

nextBook = 0;

borrowers = 0;

}

public LibraryCard issueCard()

{

LibraryCard aCard = new LibraryCard(borrowers, 5);

borrowers++;

return aCard;

}

public TextBook borrowBook(LibraryCard card)

{

TextBook book = null;

if ( (nextBook < bookShelf.length) && !card.expired() ) {

book = bookShelf[ nextBook ];

bookShelf[ nextBook ] = null;

nextBook++;

card.swipe();

}

return book;

}

public void returnBook(TextBook book)

{

bookShelf[ nextBook-1 ] = book;

nextBook--;

}

public void describe()

{

System.out.print("The library has ");

System.out.print((bookShelf.length-nextBook) + " books on the shelf, and ");

System.out.println("has issued " + borrowers + " cards.");

}

}

STUDENT

public class Student {

private String name;

private Library library;

private LibraryCard libraryCard;

private TextBook textBook;

// Constructor

public Student(String name, Library library) {

this.name = name;

this.library = library;

// Initialize library card

this.libraryCard = this.library.issueCard();

this.textBook = null;

}

// getters

public String getName() {return name;}

public Library getLibrary() {return library;}

public LibraryCard getLibraryCard() {return libraryCard;}

public TextBook getTextBook() {return textBook;}

// setters

public void setName(String newname) {name = newname;}

public void setLibrary(Library newlib) {library = newlib;}

public void setLibraryCard(LibraryCard newcard) {libraryCard = newcard;}

public void setTextBook(TextBook book) {textBook = book;}

// methods

public boolean finishedStudies() {

return getTextBook() == null && getLibraryCard().expired();

}

public void study() {

if(getTextBook() == null) { // student does not have a book

// try to borrow one from libraty

setTextBook(getLibrary().borrowBook(getLibraryCard()));

}

else // student has a book

{

if(getTextBook().isFinished()) // book is not finished

{

getTextBook().readNextChapter();

}

else // book is finished

{

getTextBook().closeBook(); // close it

getLibrary().returnBook(getTextBook()); // return to library

setTextBook(null); // now student does not have a book

}

}

}

public void describe() {

if(getTextBook() == null) {

System.out.print("Student " + getName() + " does not have a book and ");

getLibraryCard().describe();

}

else // has a book

{

System.out.print("Student " + getName() + " has a book ");

getTextBook().describe();

if(!getTextBook().isFinished()) {

System.out.println("The student is reading the book.");

}

else {

System.out.println("The book is finished");

}

}

}

}

Related Samples

Dive into our Database Assignments sample section for hands-on learning. Explore SQL queries, database design, normalization techniques, and more. Each assignment is tailored to sharpen your database management skills and deepen your understanding of relational databases. Master database concepts with our expertly crafted assignments and excel in your studies.