Scribd Logo
Upload

Welcome to Scribd!

  • 25 views

    Presentation of Dbms

    Uploaded by

    Anusha Maharjan
    This document provides an overview of Sipradi Trading Pvt. Ltd. (STPL), a major player in the automotive and allied business in Nepal. STPL aims to reach $5 billion in revenue within five years through diversifying its business portfolio. STPL is committed to meeting customer needs and delighting customers through best products and services. The document also includes an entity relationship diagram of a shipping process and explanations of weak entities, partial entity relationship diagrams, and total entity relationship diagrams.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Presentation of Dbms

    Uploaded by

    Anusha Maharjan
    25 views9 pages
    This document provides an overview of Sipradi Trading Pvt. Ltd. (STPL), a major player in the automotive and allied business in Nepal. STPL aims to reach $5 billion in revenue within five years through diversifying its business portfolio. STPL is committed to meeting customer needs and delighting customers through best products and services. The document also includes an entity relationship diagram of a shipping process and explanations of weak entities, partial entity relationship diagrams, and total entity relationship diagrams.

    Original Title

    Presentation of dbms

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of Sipradi Trading Pvt. Ltd. (STPL), a major player in the automotive and allied business in Nepal. STPL aims to reach $5 billion in revenue within five years through diversifying its business portfolio. STPL is committed to meeting customer needs and delighting customers through best products and services. The document also includes an entity relationship diagram of a shipping process and explanations of weak entities, partial entity relationship diagrams, and total entity relationship diagrams.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    25 views9 pages

    Presentation of Dbms

    Uploaded by

    Anusha Maharjan
    This document provides an overview of Sipradi Trading Pvt. Ltd. (STPL), a major player in the automotive and allied business in Nepal. STPL aims to reach $5 billion in revenue within five years through diversifying its business portfolio. STPL is committed to meeting customer needs and delighting customers through best products and services. The document also includes an entity relationship diagram of a shipping process and explanations of weak entities, partial entity relationship diagrams, and total entity relationship diagrams.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 9

    PRESENTATION OF

    DATABASE
    SIPRADI TRADING
     Sipradi a major player in AUTOMOTIVE &
    ALLIED business and is one of the largest and
    most prestigious brands in Nepal.
     STPL is an ISO 9001:2008 certified company. The
    company has the largest sales and service
    distribution network throughout Nepal. STPL is
    led by highly experienced top level
    management .There is highest level of the
    customers satisfaction.
    OBJECTIVES
     Sipradi has an objective to reach at the revenue level of
    5000 Crore in next five years.
     Sipradi is escalating in very fast pace through the
    diversified business portfolio to achieve targeted revenue.
    Sipradi is expecting 60% contribution from existing
    business portfolio and exploring other business
    opportunities with thrust for remaining 40% revenue.
     Sipradi is committed to meet customers' needs. It strives
    to delight its customers by anticipating and exceeding
    their expectations through best products and services.
    Custome
    Customer r name Customer
    id address

    Customer Deliver

    contact
    Employee id

    Product id
    Employee analysis product

    Order date
    confirm order

    payment
    Order id

    Payment date
    Payment id

    ER Diagram of shipping process


    Schema diagram
    WEAK ENTITY
     Weak entity is an entity that cannot be uniquely
    identify by its attributes alone
     does not have sufficient attributes to form a
    primary key
      depends on the strong entity for its existence
      has total participation in the identifying
    relationship shown by double line
    PARTIAL ER
     each entity in the entity set may not occur in at
    least one relationship in that relationship set
     represented by single line connecting entities in
    relationship
     Example
     For instance, consider the relationship borrower
    between customers and loans. A double line from
    loan to borrower, as shown in figure below
    indicates that each loan must have at least one
    associated customer
    TOTAL ER
      each entity in the entity set occurs in at least one
    relationship in that relationship set
     Example-

    You might also like