Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

Library Management Information System - Prof. Albano, Lab Reports of Web Programming and Technologies

Isabela State University (ISU)Web Programming and Technologies

A library management information system developed by students at the isabela state university in the philippines. It covers various aspects of the system, including how to retrieve information about the available books, their authors and publishers, as well as the borrowing and return of books. The document also includes several sql queries to manipulate the database and extract specific information, such as the total number of books available, the details of a particular book, the list of borrowers, and the total price of a book. Additionally, the document suggests adding new fields to the database, such as a province field for the publisher and province and region fields for the borrower. Overall, this document provides a comprehensive overview of a library management information system and the sql queries used to manage it.

Typology: Lab Reports

2021/2022

Uploaded on 12/19/2022

ma-jessabel-azurin
ma-jessabel-azurin 🇵🇭

4 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Republic of the Philippines
ISABELA STATE UNIVERSITY
Cabagan, Isabela
COLLEGE OF COMPUTING STUDIES, INFORMATION AND COMMUNICATION
TECHNOLOGY
LIBRARY MANAGEMENT INFOMATION SYSTEM
CHRSITIAN MAEL TALAMAYAN
JONAS BALABBO
BONIFACIO PELO
REYMUN PELO
IAN EZZEKIEL RENEGADO
PANFILO PAGULAYAN
SHARMAINE DARANTAN
GENESIS BACUD
1. How many books on “The Killing Zone” is available? Name the column as
Total_Number_of_Book_Available.
2. Who are the author and publisher of the killing zone book?
HEHERSON B. ALBANO 2
TBLBOOK
bookid
title
author
isbn
price (decimal)
quantity
TBLPUBLISHER
publisherid
publisher
address
cnumber
TBLBORROWE
R
borrowerid
borrower
address
cpnumber
TBLBORROWED_BOOKS
borrowedid
issueddate (date)
returndate (date)
issuedby
pf3
pf4
pf5

Partial preview of the text

Download Library Management Information System - Prof. Albano and more Lab Reports Web Programming and Technologies in PDF only on Docsity!

ISABELA STATE UNIVERSITY

Cabagan, Isabela COLLEGE OF COMPUTING STUDIES, INFORMATION AND COMMUNICATION TECHNOLOGY

LIBRARY MANAGEMENT INFOMATION SYSTEM

CHRSITIAN MAEL TALAMAYAN

JONAS BALABBO

BONIFACIO PELO

REYMUN PELO

IAN EZZEKIEL RENEGADO

PANFILO PAGULAYAN

SHARMAINE DARANTAN

GENESIS BACUD

  1. How many books on “The Killing Zone” is available? Name the column as Total_Number_of_Book_Available.
  2. Who are the author and publisher of the killing zone book? 2

TBLBOOK

 bookid  title  author  isbn  price (decimal)  quantity TBLPUBLISHER  publisherid  publisher  address  cnumber TBLBORROWE R  borrowerid  borrower  address  cpnumber TBLBORROWED_BOOKS  borrowedid  issueddate (date)  returndate (date)  issuedby

ISABELA STATE UNIVERSITY Cabagan, Isabela COLLEGE OF COMPUTING STUDIES, INFORMATION AND COMMUNICATION TECHNOLOGY

  1. ISBN 444 belongs to what publisher?
  2. Display the title of the book and publisher in one column and name as the column in Library.
  3. Who are the borrowers who have the access to the “The Killing Zone” book? 2

ISABELA STATE UNIVERSITY Cabagan, Isabela COLLEGE OF COMPUTING STUDIES, INFORMATION AND COMMUNICATION TECHNOLOGY

  1. Drop the column province in the table publisher.
  2. Create additional province and region for borrower fields. 2

ISABELA STATE UNIVERSITY Cabagan, Isabela COLLEGE OF COMPUTING STUDIES, INFORMATION AND COMMUNICATION TECHNOLOGY 2