Design E-R diagram for the database ‘DOCUMENTS’ to show relationship among the tables. Add 15 records in VENDORS table in Data Sheet View. 

Word Count : 1077

---

To design an Entity-Relationship (E-R) diagram for the database ‘DOCUMENTS,’ we need to consider the main entities and their relationships. In a practical scenario, the database is used to store documents, their attributes, vendors, and related details. Below is a step-by-step explanation of how to design the E-R diagram and add records to the "VENDORS" table.

1. Identify Entities:

In the ‘DOCUMENTS’ database, the key entities are:

• Documents
• Vendors
• Categories
• Users
• Document Types

Each of these entities will have attributes, and they will be related to each other through relationships.

2. Entities and Their Attributes:

• Documents:

  • DocumentID (Primary Key)
  • DocumentName
  • VendorID (Foreign Key from Vendors)
  • CategoryID (Foreign Key from Categories)
  • DocumentTypeID (Foreign Key from Document Types)
  • UploadDate
  • ExpiryDate

• Vendors:

  • VendorID (Primary Key)
  • VendorName
  • ContactNumber
  • Email
  • Address

• Categories:

  • CategoryID (Primary Key)
  • CategoryName

• Users:

  • UserID (Primary Key)
  • UserName
  • Email
  • Role

• Document Types:

  • DocumentTypeID (Primary Key)
  • DocumentTypeName

3. Relationships:

• Documents and Vendors: A document is uploaded by a vendor, meaning a one-to-many relationship from Vendors to Documents (one vendor can upload multiple documents).

• Documents and Categories: A document belongs to a particular category, establishing a one-to-many relationship from Categories to Documents (one category can have multiple documents).

• Documents and Document Types: A document is of a particular type, forming a one-to-many relationship from Document Types to Documents (one document type can apply to many documents).

• Users and Documents: Users may be responsible for approving or viewing the documents, establishing a ___________ ____________ ______ ___ __________ ___ _________ _____.
  ____________ ___ _________ ________ _____ ________ ___________ ________ __________ ___ ______ __ __ _______ ____.
  ___________ ___ _________ _____ _____________ ____ ________ _______ _________ ______ _________.
  ______ _______ ___ ____________ ____ _____________ ______ ________.
  ____ ____ _______ ________ ____________ ________.
  ____ ____________ ___________ _____________ _______ _____________ ___________ __________ ________ ________.
  __ _______ _________ _________ ______ ________ __________ ________ __ ______ ____ ________.
  ______ _______ _______ ____ _____ __ _______ _______ ____________ ________ ____ ________ _________ _______ ___.
  ____ ________ __ _____________ ___ ____________ ____________ __________ _____ _______ ___ ______ _______.
  __ ___________ _____________ __________ ________ _________.
  ____________ ____ ___ _____________ _____________ ___ _______ ___________ __________ ____________ __________ ______ _________ __ _____________.
  _____________ _______ _________ ___________ ____________ _____ _____________ _______.
  ___ ____ __________ ____ _________ ____________ ____ ____ ___ __________ ____ _____.
  __ ______ ____________ __ _____ ____________.
  __________ __________ __________ ____ ________ _______.
  ___________ ____ ____ ____ _____________ _____ _______ __________.
  ___ ___ __ _____________ ______ _______ __ ___ _____________ __________ ____________ _____ ___ ________ __.
  _________ _________ _______ __ ______ ______ _____.
  ________ ______ ____ ___________ _____ ___________ _____________ ________ _______ __________ ___ ___ ____________ __.
  _______ ____________ ______ _____ _____________ ________ ____ _____________ _________ ____ ____ ______ __ _____________ _________.
  _________ ____ _____________ _____________ ____________ _____________ ___ _____________ _____ ____ ________ __.
  __ ____________ ________ ________ _________ ____ _____ _________ ____ _______ ________ ____________ _____________ _____ _____________.
  _______ _____ ___ _______ ____________ _________ ______.
  _______ ___ __ ___________ __________ __________ _____ __ ________ ______ ____________ ___ _______ ________ _______.
  _____ ________ ____________ ____ _________ __ ____ ______ ____ _____ ________ __________ ___________ __ _____________.
  ____ _______ ____ ______ ___ _____________ ______ _____________ ________ ____________ __________ _____.
  ___ __________ _____________ __________ _____ ______ ___________ ________ _____________ ________ _____.
  __ _____________ _______ ______ _____________ ______ _____ _____ ______ _______ _____ ____.
  ___________ ____ __________ __________ __ _______ __________ ___ _______ _______ ________ ________ __ _______.
  ___ _____________ ____________ ____________ ____ ____ _____________ ___ __.
  ____ _________ ___________ _______ ___ ____________ __ _____ ____________ _____ ____ ____________.
  __________ _____________ ____________ ___________ __________ ________ __________ _____ __ __ _______ ___________ _____________ _______.
  ________ __ ____________ _____________ ______ _____________ ___________ ____.
  ____________ ____________ _________ ________ _______ ________ __ _________ _______ _________ ________ __________ ____________ _______ __.
  ___ __ __________ ______ ____ ____ _________ __.
  _________ ________ __________ ___ __________ _____________ __ _____ ____________ ___________ _______.
  _____________ ______ ___________ _________ _________ _____ ___.
  ____ ________ _____ _____ _____________ _____ ___ __________.
  _____________ ________ _______ __ ________ __________ ___ ___________.
  ________ ___ __ __________ __ _____ _____ _____ __ _________ __________.
  ______ ______ ___________ _____ _____ _____ ___ __________ ____ _____ _______ ____ _____ ___ _____________.
  ____________ ____________ _____________ ___________ _______ _____ __ ___ ______.
  _______ __ __ ____________ __ ____ _____ _____ _______ _______.
  __ ____________ ______ ________ _________ _______.
  ____ ___________ ________ _________ ____ ____________.
  ____________ ____________ __________ _______ __________ _____ ____________.
  _______ __ ___ _______ __ ______ ____ _____________ ____ ___ _______ ____________ _______ ______.
  ______ _____________ _______ ____ _____ ________ ________ ____________ ____________.
  ____________ __________ _______ ____________ ______ ___ ____ ___________ _________ ____________.
  ______ _______ ___________ _______ ____ _____________ ________ ___________ __ __________ __ _____ __________.
  __ ____________ ____________ _____________ __ ______ _________ ______ _____ ______ __ _______ _________.
  _____ ______ _____ __________ _____ _________ _____ ____ __________ ______ ______.
  _______ ____ _______ ____________ ______ ______ __ ________ _____ __________ ____________.
  ______ _____ _____________ _______ ___________ __ ____________ _______ ____________ __ ____ ___________ ________.
  _______ ____________ ____________ ________ _________ ________ __.
  _____________ ______ ____ _______ ________ ___________ _______ _______ __________ _________ _______ _________.
  ______ ___________ ___ _________ _____ _____________ ____________ ________ ___________ _______ ____________ ____________ ____ _____________ ___.
  _________ _________ _____________ _________ ___ __.
  ___ _____________ _________ __________ __ _________ ___________ ______ ____ ____________ _____________ _____________.
  ____________ ___________ __________ ________ __________ ___________ ___ _________ ___________ _____________ ___ _____.
  ____________ _____________ __________ __ _____________ ________ __ ___ ____________ _____ _____ _____.
  _______ ____________ __________ __________ __________ ____ ______ ____ ________ _______ ____ ____________ ____ _____.
  ____________ ________ ______ _________ __________ _____ ________ _____ _____________ _________ ____________.
  _____________ ______ _____ ______ __ ____________ _________ _______ _________ ______ ___ _________ _____________.
  _________ __________ ______ ___________ ____ __ ___ _____________.
  ____________ ____________ __ ________ ____ __ __________ _____ __________ ______ _______.
  _______ ______ __________ _____________ ____ _____________ ___ __ _______ _____ _____ _____________ _____________.
  ___________ ______ _______ _______ _________ _____________ ______ ___ ___________ ___________ _______ ______.
  _____ _____ _______ ____ ________ __.
  ____________ ___ _______ ______ ____________ ____ _______ ________ ________ __ __________ ___________ ____.
  ________ ____ ____ ___________ ____________ _____________ _____________ _________ _________ ____________ ___________ ____.
  __________ ___ _________ _________ ________ ______ _______ __________ __________ ___________.
  ____________ ______ __________ __ ________ ____________ ____ __.
  _____ ________ __ _____ _____ ___________ ________ _________ ____________ ___ _____________ _______ _____________.
  ____ __________ _________ ____ ___ ________ _____________.
  Click Here to Order Full Assignment on WhatsApp
  

Degree : PG DIPLOMA PROGRAMMES
Course Name : Post Graduate Diploma in Library Automation and Networking
Course Code : PGDLAN
Subject Name : Practical
Subject Code : MLIL 3
Year : 2023