Report E-Catalog Database

Question: Describe about the eCatlog database? Answer: Introduction This is a report for the eCatalog database. In this report different phases of building the database will be discussed. For this database, Microsoft Visio, Excel, Access has been used. Requirement Analysis To understand the entities, relationships and attributes of the database are needed to be understood before designing or developing the database itself. For that purpose, some eCatalogs available online, have been studies thoroughly. After understanding how data is stored, what attributes are there, what real world entities are present etc. It then moves to the next phase of designing the logical data model for the eCatalog database. Data Modeling Data modeling is the first stage of database design and development. The business rules identified from the requirement analysis are, There may be two types of documents Books and Journal articles. Each should be uniquely identifiable. A book may have more than one edition from same or different publishers. However, this is not true for journal articles. A journal article will be published on a specific journal by a journal publisher once. There are authors who can write journal article or book. Each book will have one or more chapters. A chapter will belong to one book only. There are two types of publishers, journal publishers and book publishers. A book or journal article may be written by one or more authors. ER diagram for the eCatalog database having entities like Author, Book, Journal, Journal Publisher, Book Publisher, Chapter etc. , relationships among the entities and attributes of the same, is, There are one to one relationship between Chapter and Book, Journal Publisher and Journal etc. These are represented using foreign keys from one side to many side. There are many to many relationships, both binary and ternary. For example, binary many to many relationship Journal Publication, ternary many to many relationship Book Publication. These information about entities, relationships etc. will be transformed into implementation of the database in Microsoft Access. Relational Database Design in Microsoft Access In this phase there will be a table for each many to many relationship and entities from the ER diagram. The attributes of each will be also there. Using Create table option these tables will be created. Then the attributes and data types will be set. The primary key and foreign keys will also be set. After building the database in Access and saving it, each table will be exported into HTML web pages. The Structures of the tables will be shown in HTML web pages. The Access Database contains different tables, like Author It describes the details of each author. Including their unique ID, name, and contact details. Book It describes the details of each book, like unique ID, title, publication details, number of pages, edition etc. the composite primary key is BookID and Edition. BookPublication It describes the publication of an edition of a book by a publisher. BookPublisher It describes the details of book publisher. There are fields like unique identification for each book publisher, name, contact address etc. Chapter Each book will have one or more chapters. So there is a composite key including BookId and chapter no. Chapter no will uniquely identify each chapter in a book. There are other fields like name of the chapter, additional details etc. Journal A journal will be identified by journal ID. There are other fields like name, year of publication etc. JournalPublication There will be publication details of each journal in this table. There will be detailed date of publication, city etc. along with the unique ID. JournalPublisher There will be details about each journal publisher. Each publisher will have their name, website, email, contact details etc. The Access database is, Data Dictionary A data dictionary provides information about the data in the database. That is, it will provide information about the tables, attributes, primary keys, foreign keys etc. For that purpose an Excel based data dictionary has been developed. Where description from each attribute of each table has been described. The data dictionary descriptions are, Author Attribute Name Description Comment AuthorID This is the primary key field and uniquely identifies each record in the Author table. Name Author It represents the name of the author. Email ID It represents the email id of the author. Contact Number It represents the contact number of the author. Book Attribute Name Description Comment Book ID This is one of the key field and unique for each book. The composite primary key BookID and Edition uniquely identifies a Book Edition This is one of the key field. Book Name This is the name of a book. Date Publication This is the date of publication of an edition of a book. Number Pages This is the number of pages in an edition of a book Book Publication Attribute Name Description Comment Book ID This is a key field and a foreign key to the Book Table. The composite primary key contains all these four attributes. It uniquely identifies each record in Book Publication Table Author ID This is a key field and a foreign key to the Author Table. Edition This is a key field and a foreign key to the Book Table. Book Publisher ID This is a key field and a foreign key to the BookPublisher Table. BookPublisher Attribute Name Description Comment Book Publisher ID This is the primary key and uniquely identifies each record in the BookPublisher table. Name This is the name of a book publication company. Address This is the contact address of a book publishing company. Chapter Attribute Name Description Comment Chapter No This is a key field. It represents the chapter in some Book These three fields constitute the primary key of the table Chapter Book ID This is a key field. It represents the book to which the chapter belongs to. This is also a foreign key to Book table. Edition This is a key field and foreign key to Book table. Name This is the title of a chapter. Details This is an optional field for describing some details associated with a chapter. Journal Attribute Name Description Comment Journal ID This is the primary key field for Journal table. Journal Name This is the name of a journal. Volume This is the volume of a journal. Issue This is the issue number of a journal. Year Of Publication This is the year of publication of a journal. Journal Publisher This is a foreign key to the table Journal Publisher. It represents the reference to the publisher of a journal. Journal Publisher Attribute Name Description Comment Journal Publisher ID This is a key field. It is also a foreign key referencing to the Journal Publisher table. Name This is the name of the Journal Publishing organisation. Email This is the email of the Journal Publishing organisation. Website This is the website (URL) of the Journal Publishing organisation. Address This is the address of the Journal Publishing organisation. Journal Publication Attribute Name Description Comment Author ID This is a key field in the Journal Publication table. This is also a foreign key referencing to the Author table. These two fields constitute the primary key of the table. Journal ID This is a key field in the Journal Publication table. This is also a foreign key referencing to the Journal table. Date Publication This field gives the Date of the publication of some journal. City This is the publication city of a journal. Conclusion In this report, the phases of designing and developing the eCatalog database have been described. There are discussions on designing the logical schema, building the database and creating the data dictionary. References Garcia-Molina, H., Ullman, J. D., Widom, J. (2011). Database Systems: The Complete Book. Pearson. Lambert, J., Cox, J. (2013). Microsoft Access 2013 Step by Step. Pearson Education. Silberschatz, A., Korth, H., Sudarshan, S. (2010). Database System Concepts (6th ed.). McGraw-Hill Education.