LABORATORY WORK № 1

THE TASK. The result of the laboratory work should be a description file of the subject area, containing the following main parts:
	•	Brief formulation of the task of developing an information system with a database of the chosen subject area
	•	Extended description of the subject area.
One topic can’t be accepted over TWO times (maximal 2).
Work as a team, should declare team member when topic is chosen.
Access to Write Topic Name: Лаб счет - 2024-2025.xlsx
Deadline 16.09.2024

Example of a description of the subject area "Electronic Library" for designing a database of the corresponding automated information system

Prepare a database object, to accomplish library book borrow and return auto management. Library database will include books’ information, such us, which bookshelf, total numbers, book introduction, borrow status and which reader borrowed it. For reader, they can view book information and after created a reader account and sign in they can view whether borrow this book, and their historical of borrowing. And to maintain this database we need a few accounts as manager. At the same time, database can storage reader’s evaluation for the book which they were borrowed or give out some suggestions to reader when they inputted a book name that not available or have been borrowed in the system and so on.
In this object we can define the book information, system account, borrow information etc.
For books, can set these attributes:
	•	Book name
	•	Book introduction (intraduct book’s content)
	•	Bookshelf (book’s location in this library)
	•	Book type (mathematics, informatics, philosophy, geography etc.)
	•	Publish information (so many books were published many years ago but printed many times)
	•	Numbers in library (this will decide how many readers can borrow this book)
Also, can added other fields likes “internet links” used to help reader find out where they can download its eBook or buy it.
For account information, can set these attributes:
	•	Account name and password (these will be the signal and authority for users sign in the system)
	•	Account type (can use this filed differentiate between reader and manager, also can use it distinguish user level)
	•	Account owner’s information (record reader’s contact information used to urge them return books)
	•	Account status (pint out this account is banded or not)
For borrow information, when reader return a book can collect their evaluation for this book and show his evaluation for this book to other readers. So, we can definite the attributes like this:
	•	Book information (which book was borrowed)
	•	Reader information (who borrowed this book)
	•	Borrow date (when reader borrows this book)
	•	Days for borrow (How long reader will borrow this book. Usually within 30 days)
	•	Return date (when reader returned this book)
	•	Evaluation (reader’s evaluation/opinion for this book)
Of course, most libraries will charge a small amount of money as a borrowing fee. 
When manager sign in the system, they can operate the database, do so many things, likes to create a new account, manage book information (insert, update, or delete), change borrow status (after they received the book which returned by reader) and change account status (if reader published illegal information when the return book or borrowed book but not returned a long time manager can banded this account, and decide whether to enable after reader returns).
When reader using this system without sign in, the reader can only search books and read books’ information. When they borrow a book their account & password will be their authority, manager can create a borrow record after reader shows which book will be borrow and sign in his account. If library using machine to record books borrow and return, reader can input their account name & password complete borrow and return operation by themselves.
So that the goal of creating an «electronic library» database is meet the requirements of above, and choose suitable DBMS and software accomplish it. Of course, different software customers have different requirements, the above information is not all requirements of «electronic library».
List of subject areas for database design: (Following information just a suggestion)
	•	Air transportation.
	•	Automated system "auction".
	•	Automated system "students". Which includes information about students, academic performance in subjects, their attendance, etc.
	•	Carpark.
	•	Car service.
	•	Pharmacy warehouse.
	•	Gallery.
	•	City archive.
	•	Club "racer.”
	•	Club of computer games. 
	•	Bookstores.
	•	Meteorological center.
	•	Modeling agency.
	•	Youth leisure center.
	•	Pedigree
	•	Sports club.
	•	Trading warehouse.
	•	Shopping center.
	•	Transport agency.
	•	Film library.
	•	Electronic library. 
	•	Task distribution system.
	•	Employee application processing



переведи на русский