• Cyberian's Gold


  • Assignment 2 CS403 file Solution Fall 2020
    @zaasmi
    Question: In this technological era manually managing any system is a time-consuming task. A construction company named “Global Construction” wants to computerize their manual system, so that they can easily and efficiently manage their employees, clients, projects and finance. It will be beneficial for both clients and company. Company has different employees who work on different projects. Global Construction database system will store all the information in an organized manner by following the below business rules:
    Client can visit the website, view completed projects details and client’s review/feedback about projects, places an order by filling the order form, give review/feedback.
    Manager can assign projects to employees, view assigned projects. Manger can also view placed orders, can accept or cancel the order. He can also generate receipt; client will be able to view and download the receipt. Employees will be able to view assigned projects, he can also update status of the project as started, partially completed, or completed.
    Required
    • Draw the ER diagram.
    8882cf65-f379-42b4-b1a4-e06b89dd0940-image.png
    • Draw relationship cardinalities in alphabetical notation.
    6da438e1-3b03-4530-90b6-51c5b8d82b1e-image.png

  • Cyberian's

    @cyberian said in CS403 Assignment 2 Solution and Discussion:

    Consider the following relations/tables and perform the following binary operations and write the output:

    CreditCard
    card_number expriy_date
    Cardnumber001 23/5/2025
    Cardnumber002 24/6/2025
    Cardnumber003 25/7/2025
    Shelve
    Shelve_id Number
    Sh001 1
    Sh002 2
    Sh003 3

    (Shelve) U (CreditCard)
    (CreditCard) – (Shelve)

    20200614_131046.jpg

  • Cyberian's

    @cyberian said in CS403 Assignment 2 Solution and Discussion:

    Perform the following operations on the mentioned table and write the corresponding output:
    σ Address == ‘Islamabad’ (Pharmacist)
    ∏ Med_id, Name, Expiry_date (σ Price<= 20 (Medicine))

    20200614_131011.jpg

  • Cyberian's

    @cyberian said in CS403 Assignment 2 Solution and Discussion:

    Find the degree and cardinality of the following tables (given in 2nd question):
    Table Cardinality Degree
    Pharmacist
    Medicine
    Shelve

    20200614_130925.jpg

  • Cyberian's

    @cyberian said in CS403 Assignment 2 Solution and Discussion:

    Consider the following tables and perform cross matrix of Shelve, Medicine and Pharmacist
    (Shelve X Medicine X Pharmacist)

    Pharmacist
    Pharm_id Name Address
    Ph001 Ahmad Lahore
    Ph002 Tahir Islamabad
    Ph003 Ather Karachi
    Medicine
    Med_id Name Price Expiry_date
    Md001 Panadol 20 22/2/2022
    Md002 Disprin 20 22/3/2023
    Md003 Brufen 40 22/4/2024
    Shelve
    Shelve_id Number
    Sh001 1
    Sh002 2
    Sh003 3
    Solution
    20200614_130825.jpg f

  • Cyberian's

    @cyberian said in CS403 Assignment 2 Solution and Discussion:

    Convert the above entity relationship diagram into relational data model. You have to convert all the three important components (entities, attributes and relationships between different entities) of the entity relationship diagram into relational data model.

    SmartSelect_20200614-125825_YouTube.gif

  • Cyberian's

Insaf Sehat Card Live Cricket Streaming
  • 2
  • 1
  • 1
  • 2
  • 6
  • 1
  • 7
  • 5
Quiz 100% Result Quiz 100% Result
| |