GitHub - karanheart96/DBMS_BIBLIOBASE: Project details The project is to develop and document a data model for representing the entities and relationships in a bibliographic system, provide DDL for creating the tables, DML for adding entries in the tables, and DQL for making commonly used queries to retrieve data from the database. The project should also provide sample data that can be loaded into the database.This system holds only bibliographic information and not content. The data model for the project is based on the concept of a publisher, collections of publications put out by the publisher, and authors who are responsible for contributing to those publications. Here are details of these entities and their relationships. Publisher is the entity who is responsible for publishing the content. A pubisher may publish multiple types of content. An example of a publisher is National Geographic Society. Unfortunately, there is no unique identifier for a publisher other than the name, and the issue of publisher name is a ridculously complex isse that can safely be ignored for this project. Publication is is any work that is published by a publisher. A publication has a publicaton type that indicates the type of the publication. with some common and some publication specific attributes. For example, National Geographic Society publishes journals, books, book series, as well as DVDs and maps. Here are some details about kinds of publications. Periodical is a serial publication appearing at regular intervals. a periodical contains Articles written by one or more authors. Periodicals include magazines like National Geographic and scholarly journals like the Proceedings of the National Academy of Science. A periodicals is identified by an ISSN (International Standard Serial Number). An article has a title, authors, a range of pages, and often a DOI (Digital Object Identifier). Book is a stand-alone volume that can have one or more authors. It can represent a single work, or a collection of works as chapters by one or more authors (e.g. an anthology). An example of a National Geographic Society book is Apollo on the Moon. A book is identified by an ISBN (International Standard Book Number). Books can sometime have their own DOIs. A book has a title and a year of publication, and the number of pages. New editions of a book have their own ISBN. A book may also include records for its individual chapters, especially if it an an anthology. Book series is a sequence of books with certain characteristics in common that are formally identified together as a group. Book series can be organized in different ways, such as written by the same author, or marketed as a group by their publisher. For example, Bugs!, is port of a book series, National Geographic Kids Readers. Each book in the series has its own title and ISBN and sometimes a DOI. The series itself is also eligible for an ISBN, and books in a series can also be referred to by a volume number in the series. Author is the creator of of content in a publication. For a periodical, one or more authors are associated with an individual article. The default role of one or more authors associated with an issue is editor. The default role of one or more authors associated with a book is as its authors. If the book has individual chapters, the default role of associated chapter authors is as authors, and the role of authors associated with the book is as editors. There are no authors associated with a periodical or a book series. An ORCID ID (Open Researcher and Contributor ID) is recogniaed as an author identifier in the academic community. Otherwise, there is no recognized identifier other than the name.

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
Bibliobase		Bibliobase

About

Project details The project is to develop and document a data model for representing the entities and relationships in a bibliographic system, provide DDL for creating the tables, DML for adding entries in the tables, and DQL for making commonly used queries to retrieve data from the database. The project should also provide sample data that can…