Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Pro Blog
  • Users
  • Groups
  • Unsolved
  • Solved
Collapse
Secnto AI
  1. Secnto AI
  2. Categories
  3. Virtual University
  4. CS403 - Database Management Systems
  5. CS403 Assignment 2 Solution and Discussion
CS403 Assignment 2 Solution and Discussion
M
Re: CS403 Assignment 2 Solution and Discussion Assignment No. 02 SEMESTER Spring 2020 CS403- Database Management System Total Marks: 20 Due Date: 15/06/2020 Instructions Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit if: • The assignment is submitted after due date. • The submitted assignment does not open or file corrupt. • The assignment is fully or partially copied (from other student or ditto copy from handouts or internet). • Student ID is not mentioned in the assignment File or name of file is other than student ID. • The assignment is not submitted in .doc or .docx format. Uploading instructions Your submission must include: • Assignment should be in .doc or .docx format. • Save your assignment with your ID (e.g. bx020200786.doc). • Assignment submission through email is NOT acceptable. Objectives The objectives of this assignment are: • To be able to understand Logical Database Design • To be able to perform different relational algebra operations Note: Your answer must follow the below given specifications. • Font style: “Times New Roman” • Font color: “Black” • Font size: “12” • Bold for heading only. • Font in Italic is not allowed at all. • No formatting or bullets are allowed to use. • Your answer should be precise and to the point, avoid irrelevant detail. Lectures Covered: This assignment covers Lecture # 14 - 17 Deadline Your assignment must be uploaded/submitted on or before 15/06/2020. Question Statement Our second assignment is the continuation of our first assignment. In the first assignment one question is related to entity relationship data model. The entity relationship diagram is given below: Now in second assignment, you are required to perform the following tasks: 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. 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 Find the degree and cardinality of the following tables (given in 2nd question): Table Cardinality Degree Pharmacist Medicine Shelve Perform the following operations on the mentioned table and write the corresponding output: σ Address == ‘Islamabad’ (Pharmacist) ∏ Med_id, Name, Expiry_date (σ Price<= 20 (Medicine)) 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) =====================================Ended======================================= For any query about the assignment, contact at CS403@vu.edu.pk GOOD LUCK Spring 2020_CS403_2.doc
CS403 - Database Management Systems
CS403 GDB1 Solution and discussion
Ramish KhanR
Re: CS403 GDB1 Solution and discussion Total Marks 5 Starting Date Monday, February 15, 2021 Closing Date Tuesday, February 16, 2021 Status Open Question Title GDB Topic Question Description GDB Topic Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously. As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup? Also, what you think that replication of database suitable in the above given scenario? Note: Your GDB answer should not exceed 4 to 5 lines. GDB Instructions: You need to provide precise and to the point answer, avoid irrelevant details. Copied from the internet or another student will get zero marks. You cannot participate in the discussion after the due date via email. The GDB will open and close on specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.
CS403 - Database Management Systems
CS403 Assignment 1 Solution and Discussion
zaasmiZ
Re: CS403 Assignment 1 Solution and Discussion
CS403 - Database Management Systems
CS403 Assignment 1 Solution and Discussion
cyberianC
Re: CS403 Assignment 1 Solution and Discussion
CS403 - Database Management Systems
CS403 GDB1 Solution and discussion
zaasmiZ
GDB Topic: The Virtual University has a multi-disciplinary approach and offers extensive degree programs in numerous academic disciplines. Although undergraduate and post graduate degrees are awarded in many disciplines, the most sought and highly popular degrees offered by the University are in the fields of Computer and IT. BS, MS and PhD program offered under the department of CS and IT. Students get enrolled and study the relevant courses in a particular semester. VU manages the information about students, degree programs, student’s achievements, course credentials and many more. Let’s suppose, you are the database designer and asked to design the database of above given scenario. In order to design the database, you have to choose a data model from the following data models: Hierarchical data model Network data model Relational data model As a database designer which data model will you choose for the database designing? Justify your answer in either case with only very solid points. Note: Answer should not exceed 200 words. GDB Instructions: You need to provide precise and to the point answer, avoid irrelevant details. Copied from the internet or another student will get zero marks. You cannot participate in the discussion after the due date via email. The GDB will open and close on specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.
CS403 - Database Management Systems
CS403 Assignment 2 Solution and Discussion
zareenZ
EDU302 Assignment No. 02 SEMESTER Spring 2019 CS403- Database Management System Total Marks: 20 Due Date: 02/12/2019 Instructions Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit if: • The assignment is submitted after due date. • The submitted assignment does not open or file corrupt. • The assignment is full or partially copied from (other student or ditto copy from handouts or internet). • Student ID is not mentioned in the assignment File or name of file is other than student ID. • The assignment is not submitted in .doc or .docx format. Uploading instructions Your submission must include: • Assignment should be in .doc or .docx format. • Save your assignment with your ID (e.g. bx020200786.doc). • Assignment submission through email is NOT acceptable. Objectives Objectives The objective of this assignment is to able the Students: • To understand the relational database model • To understand the Conversion of ERD into relational data model • To understand the Cartesian product of two relations • To understand the degree and cardinalities of relations Note: Your answer must follow the below given specifications. • Font style: “Times New Roman” • Font color: “Black” • Font size: “12” • Bold for heading only. • Font in Italic is not allowed at all. • No formatting or bullets are allowed to use. • Your answer should be precise and to the point, avoid irrelevant detail. Lectures Covered: This assignment covers Lecture # 10 - 17 Deadline Your assignment must be uploaded/submitted on or before 02/12/2019. Question Statement Our second assignment is the continuation of the first assignment. In the first assignment an ERD was required for the given scenario, which is given below: [image: RN2Q5Ix.png] You’re required to perform the following tasks: Convert the above Entity Relationship Diagram into Relational data model. You have to convert all the components of the ERD into Relational Data model. Consider the following two tables: Order: order_id order_status delivery_date btag_no cust_id sman_id od001 Completed 10/30/2019 bt001 cust001 sm001 od002 Completed 10/30/2019 bt002 cust002 sm001 od003 Completed 10/30/2019 bt003 cust003 sm001 Bill: bill_id cust_id order_id net_amount b001 cust001 od001 500 b002 cust002 od002 550 b003 cust001 od003 600 And write the output of the following relational algebra operations: • ∏ order_id, cust_id, sman_id (Order) • σ net_amount > 500 (Bill) • ∏ order_status, delivery_date (σ btag_no= ‘bt002’ (Order)) Find the degree and cardinality of the relations (Order and Bill) given in the 2nd question. ====================================Ended======================================= For any query about the assignment, contact at CS403@vu.edu.pk GOOD LUCK
CS403 - Database Management Systems
CS403 Assignment 1 Solution and Discussion
zareenZ
Assignment No. 01 SEMESTER Fall 2019 CS403- Database Management System Total Marks: 20 Due Date: 13/11/2019 Instructions Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit if: • The assignment is submitted after due date. • The submitted assignment does not open or file corrupt. • The assignment is full or partially copied from (other student or ditto copy from handouts or internet). • The assignment is not submitted in .doc or .docx format. Uploading instructions Your submission must include: • Assignment should be in .doc or .docx format. • Save your assignment with your ID (e.g. bx020200786.doc). • Assignment submission through email is NOT acceptable Objective The objective of this assignment is • To give basic knowledge and understanding of Database. • To be able to understand Conceptual Database Design. Note: Your answer must follow the below given specifications. • Font style: “Times New Roman” • Font color: “Black” • Font size: “12” • Bold for heading only. • Font in Italic is not allowed at all. • No formatting or bullets are allowed to use. • Your answer should be precise and to the point, avoid irrelevant detail. Lectures Covered: This assignment covers Lecture # 01 - 08 Deadline Your assignment must be uploaded/submitted on or before 13/11/2019. Question Suppose a water filtration company “ABC” wants to develop a database system for his business flow. This database system will manage its customers, employees, stocks and sales area details. Database system will manage the different sales areas for delivery, defined by the company upon customer request. Customers can place the delivery request at least one day before. The Manager can check the customer order request and generate the bill/voucher accordingly. The salesman will deliver the order to the customer. The customer will pay the dues. After delivery, salesman can also update the order status. Customers can give their feedback about water quality and delivery system. Company will give special discounts and water dispensers to their special customers, and these special facilities depend on the usage of water bottles. Company also wants to keep track of their delivered bottles details. • Draw the context level diagram. • Identify Entities, their attributes, relationships among entities in above scenario and draw Entity Relationship Diagram (ERD) for it. Note: You are required to submit Context level diagram and ERD as your solution only. =====================================Ended======================================= For any query about the assignment, contact at CS403@vu.edu.pk GOOD LUCK
CS403 - Database Management Systems

CS403 Assignment 2 Solution and Discussion

Scheduled Pinned Locked Moved CS403 - Database Management Systems
assignment 2cs403discussionsolutionspring 2020
9 Posts 4 Posters 6.0k Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    Mahnoor
    wrote on last edited by cyberian
    #1

    Re: CS403 Assignment 2 Solution and Discussion

    Assignment No. 02

    SEMESTER Spring 2020
    CS403- Database Management System
    Total Marks: 20

    Due Date: 15/06/2020
    Instructions
    Please read the following instructions carefully before solving & submitting assignment:
    It should be clear that your assignment will not get any credit if:
    • The assignment is submitted after due date.
    • The submitted assignment does not open or file corrupt.
    • The assignment is fully or partially copied (from other student or ditto copy from handouts or internet).
    • Student ID is not mentioned in the assignment File or name of file is other than student ID.
    • The assignment is not submitted in .doc or .docx format.
    Uploading instructions
    Your submission must include:

    • Assignment should be in .doc or .docx format.
    • Save your assignment with your ID (e.g. bx020200786.doc).
    • Assignment submission through email is NOT acceptable.
    Objectives
    The objectives of this assignment are:
    • To be able to understand Logical Database Design
    • To be able to perform different relational algebra operations

    Note:
    Your answer must follow the below given specifications.
    • Font style: “Times New Roman”
    • Font color: “Black”
    • Font size: “12”
    • Bold for heading only.
    • Font in Italic is not allowed at all.
    • No formatting or bullets are allowed to use.
    • Your answer should be precise and to the point, avoid irrelevant detail.

    Lectures Covered: This assignment covers Lecture # 14 - 17
    Deadline
    Your assignment must be uploaded/submitted on or before 15/06/2020.

    Question Statement

    Our second assignment is the continuation of our first assignment.
    In the first assignment one question is related to entity relationship data model.
    The entity relationship diagram is given below:

    Now in second assignment, you are required to perform the following tasks:

    1. 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.
    2. 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

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

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

    3. 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

    1. (Shelve) U (CreditCard)
    2. (CreditCard) – (Shelve)
      =====================================Ended=======================================

    For any query about the assignment, contact at CS403@vu.edu.pk

    GOOD LUCK

    Spring 2020_CS403_2.doc

    cyberianC 5 Replies Last reply
    0
    • cyberianC Offline
      cyberianC Offline
      cyberian
      Cyberian's Cyberian's Gold
      wrote on last edited by
      #2

      https://youtu.be/fiUeRUORWRU

      Discussion is right way to get Solution of the every assignment, Quiz and GDB.
      We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
      Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
      [NOTE: Don't copy or replicating idea solutions.]
      Quiz Copy Solution
      Mid and Final Past Papers
      WhatsApp Channel
      Mobile Tax Calculator

      1 Reply Last reply
      0
      • M Mahnoor

        Re: CS403 Assignment 2 Solution and Discussion

        Assignment No. 02

        SEMESTER Spring 2020
        CS403- Database Management System
        Total Marks: 20

        Due Date: 15/06/2020
        Instructions
        Please read the following instructions carefully before solving & submitting assignment:
        It should be clear that your assignment will not get any credit if:
        • The assignment is submitted after due date.
        • The submitted assignment does not open or file corrupt.
        • The assignment is fully or partially copied (from other student or ditto copy from handouts or internet).
        • Student ID is not mentioned in the assignment File or name of file is other than student ID.
        • The assignment is not submitted in .doc or .docx format.
        Uploading instructions
        Your submission must include:

        • Assignment should be in .doc or .docx format.
        • Save your assignment with your ID (e.g. bx020200786.doc).
        • Assignment submission through email is NOT acceptable.
        Objectives
        The objectives of this assignment are:
        • To be able to understand Logical Database Design
        • To be able to perform different relational algebra operations

        Note:
        Your answer must follow the below given specifications.
        • Font style: “Times New Roman”
        • Font color: “Black”
        • Font size: “12”
        • Bold for heading only.
        • Font in Italic is not allowed at all.
        • No formatting or bullets are allowed to use.
        • Your answer should be precise and to the point, avoid irrelevant detail.

        Lectures Covered: This assignment covers Lecture # 14 - 17
        Deadline
        Your assignment must be uploaded/submitted on or before 15/06/2020.

        Question Statement

        Our second assignment is the continuation of our first assignment.
        In the first assignment one question is related to entity relationship data model.
        The entity relationship diagram is given below:

        Now in second assignment, you are required to perform the following tasks:

        1. 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.
        2. 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

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

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

        3. 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

        1. (Shelve) U (CreditCard)
        2. (CreditCard) – (Shelve)
          =====================================Ended=======================================

        For any query about the assignment, contact at CS403@vu.edu.pk

        GOOD LUCK

        Spring 2020_CS403_2.doc

        cyberianC Offline
        cyberianC Offline
        cyberian
        Cyberian's Cyberian's Gold
        wrote on last edited by
        #3

        @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

        Discussion is right way to get Solution of the every assignment, Quiz and GDB.
        We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
        Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
        [NOTE: Don't copy or replicating idea solutions.]
        Quiz Copy Solution
        Mid and Final Past Papers
        WhatsApp Channel
        Mobile Tax Calculator

        1 Reply Last reply
        0
        • M Mahnoor

          Re: CS403 Assignment 2 Solution and Discussion

          Assignment No. 02

          SEMESTER Spring 2020
          CS403- Database Management System
          Total Marks: 20

          Due Date: 15/06/2020
          Instructions
          Please read the following instructions carefully before solving & submitting assignment:
          It should be clear that your assignment will not get any credit if:
          • The assignment is submitted after due date.
          • The submitted assignment does not open or file corrupt.
          • The assignment is fully or partially copied (from other student or ditto copy from handouts or internet).
          • Student ID is not mentioned in the assignment File or name of file is other than student ID.
          • The assignment is not submitted in .doc or .docx format.
          Uploading instructions
          Your submission must include:

          • Assignment should be in .doc or .docx format.
          • Save your assignment with your ID (e.g. bx020200786.doc).
          • Assignment submission through email is NOT acceptable.
          Objectives
          The objectives of this assignment are:
          • To be able to understand Logical Database Design
          • To be able to perform different relational algebra operations

          Note:
          Your answer must follow the below given specifications.
          • Font style: “Times New Roman”
          • Font color: “Black”
          • Font size: “12”
          • Bold for heading only.
          • Font in Italic is not allowed at all.
          • No formatting or bullets are allowed to use.
          • Your answer should be precise and to the point, avoid irrelevant detail.

          Lectures Covered: This assignment covers Lecture # 14 - 17
          Deadline
          Your assignment must be uploaded/submitted on or before 15/06/2020.

          Question Statement

          Our second assignment is the continuation of our first assignment.
          In the first assignment one question is related to entity relationship data model.
          The entity relationship diagram is given below:

          Now in second assignment, you are required to perform the following tasks:

          1. 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.
          2. 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

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

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

          3. 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

          1. (Shelve) U (CreditCard)
          2. (CreditCard) – (Shelve)
            =====================================Ended=======================================

          For any query about the assignment, contact at CS403@vu.edu.pk

          GOOD LUCK

          Spring 2020_CS403_2.doc

          cyberianC Offline
          cyberianC Offline
          cyberian
          Cyberian's Cyberian's Gold
          wrote on last edited by
          #4

          @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

          Discussion is right way to get Solution of the every assignment, Quiz and GDB.
          We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
          Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
          [NOTE: Don't copy or replicating idea solutions.]
          Quiz Copy Solution
          Mid and Final Past Papers
          WhatsApp Channel
          Mobile Tax Calculator

          1 Reply Last reply
          0
          • M Mahnoor

            Re: CS403 Assignment 2 Solution and Discussion

            Assignment No. 02

            SEMESTER Spring 2020
            CS403- Database Management System
            Total Marks: 20

            Due Date: 15/06/2020
            Instructions
            Please read the following instructions carefully before solving & submitting assignment:
            It should be clear that your assignment will not get any credit if:
            • The assignment is submitted after due date.
            • The submitted assignment does not open or file corrupt.
            • The assignment is fully or partially copied (from other student or ditto copy from handouts or internet).
            • Student ID is not mentioned in the assignment File or name of file is other than student ID.
            • The assignment is not submitted in .doc or .docx format.
            Uploading instructions
            Your submission must include:

            • Assignment should be in .doc or .docx format.
            • Save your assignment with your ID (e.g. bx020200786.doc).
            • Assignment submission through email is NOT acceptable.
            Objectives
            The objectives of this assignment are:
            • To be able to understand Logical Database Design
            • To be able to perform different relational algebra operations

            Note:
            Your answer must follow the below given specifications.
            • Font style: “Times New Roman”
            • Font color: “Black”
            • Font size: “12”
            • Bold for heading only.
            • Font in Italic is not allowed at all.
            • No formatting or bullets are allowed to use.
            • Your answer should be precise and to the point, avoid irrelevant detail.

            Lectures Covered: This assignment covers Lecture # 14 - 17
            Deadline
            Your assignment must be uploaded/submitted on or before 15/06/2020.

            Question Statement

            Our second assignment is the continuation of our first assignment.
            In the first assignment one question is related to entity relationship data model.
            The entity relationship diagram is given below:

            Now in second assignment, you are required to perform the following tasks:

            1. 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.
            2. 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

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

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

            3. 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

            1. (Shelve) U (CreditCard)
            2. (CreditCard) – (Shelve)
              =====================================Ended=======================================

            For any query about the assignment, contact at CS403@vu.edu.pk

            GOOD LUCK

            Spring 2020_CS403_2.doc

            cyberianC Offline
            cyberianC Offline
            cyberian
            Cyberian's Cyberian's Gold
            wrote on last edited by
            #5

            @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

            Discussion is right way to get Solution of the every assignment, Quiz and GDB.
            We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
            Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
            [NOTE: Don't copy or replicating idea solutions.]
            Quiz Copy Solution
            Mid and Final Past Papers
            WhatsApp Channel
            Mobile Tax Calculator

            1 Reply Last reply
            0
            • M Mahnoor

              Re: CS403 Assignment 2 Solution and Discussion

              Assignment No. 02

              SEMESTER Spring 2020
              CS403- Database Management System
              Total Marks: 20

              Due Date: 15/06/2020
              Instructions
              Please read the following instructions carefully before solving & submitting assignment:
              It should be clear that your assignment will not get any credit if:
              • The assignment is submitted after due date.
              • The submitted assignment does not open or file corrupt.
              • The assignment is fully or partially copied (from other student or ditto copy from handouts or internet).
              • Student ID is not mentioned in the assignment File or name of file is other than student ID.
              • The assignment is not submitted in .doc or .docx format.
              Uploading instructions
              Your submission must include:

              • Assignment should be in .doc or .docx format.
              • Save your assignment with your ID (e.g. bx020200786.doc).
              • Assignment submission through email is NOT acceptable.
              Objectives
              The objectives of this assignment are:
              • To be able to understand Logical Database Design
              • To be able to perform different relational algebra operations

              Note:
              Your answer must follow the below given specifications.
              • Font style: “Times New Roman”
              • Font color: “Black”
              • Font size: “12”
              • Bold for heading only.
              • Font in Italic is not allowed at all.
              • No formatting or bullets are allowed to use.
              • Your answer should be precise and to the point, avoid irrelevant detail.

              Lectures Covered: This assignment covers Lecture # 14 - 17
              Deadline
              Your assignment must be uploaded/submitted on or before 15/06/2020.

              Question Statement

              Our second assignment is the continuation of our first assignment.
              In the first assignment one question is related to entity relationship data model.
              The entity relationship diagram is given below:

              Now in second assignment, you are required to perform the following tasks:

              1. 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.
              2. 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

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

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

              3. 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

              1. (Shelve) U (CreditCard)
              2. (CreditCard) – (Shelve)
                =====================================Ended=======================================

              For any query about the assignment, contact at CS403@vu.edu.pk

              GOOD LUCK

              Spring 2020_CS403_2.doc

              cyberianC Offline
              cyberianC Offline
              cyberian
              Cyberian's Cyberian's Gold
              wrote on last edited by
              #6

              @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

              Discussion is right way to get Solution of the every assignment, Quiz and GDB.
              We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
              Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
              [NOTE: Don't copy or replicating idea solutions.]
              Quiz Copy Solution
              Mid and Final Past Papers
              WhatsApp Channel
              Mobile Tax Calculator

              1 Reply Last reply
              0
              • M Mahnoor

                Re: CS403 Assignment 2 Solution and Discussion

                Assignment No. 02

                SEMESTER Spring 2020
                CS403- Database Management System
                Total Marks: 20

                Due Date: 15/06/2020
                Instructions
                Please read the following instructions carefully before solving & submitting assignment:
                It should be clear that your assignment will not get any credit if:
                • The assignment is submitted after due date.
                • The submitted assignment does not open or file corrupt.
                • The assignment is fully or partially copied (from other student or ditto copy from handouts or internet).
                • Student ID is not mentioned in the assignment File or name of file is other than student ID.
                • The assignment is not submitted in .doc or .docx format.
                Uploading instructions
                Your submission must include:

                • Assignment should be in .doc or .docx format.
                • Save your assignment with your ID (e.g. bx020200786.doc).
                • Assignment submission through email is NOT acceptable.
                Objectives
                The objectives of this assignment are:
                • To be able to understand Logical Database Design
                • To be able to perform different relational algebra operations

                Note:
                Your answer must follow the below given specifications.
                • Font style: “Times New Roman”
                • Font color: “Black”
                • Font size: “12”
                • Bold for heading only.
                • Font in Italic is not allowed at all.
                • No formatting or bullets are allowed to use.
                • Your answer should be precise and to the point, avoid irrelevant detail.

                Lectures Covered: This assignment covers Lecture # 14 - 17
                Deadline
                Your assignment must be uploaded/submitted on or before 15/06/2020.

                Question Statement

                Our second assignment is the continuation of our first assignment.
                In the first assignment one question is related to entity relationship data model.
                The entity relationship diagram is given below:

                Now in second assignment, you are required to perform the following tasks:

                1. 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.
                2. 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

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

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

                3. 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

                1. (Shelve) U (CreditCard)
                2. (CreditCard) – (Shelve)
                  =====================================Ended=======================================

                For any query about the assignment, contact at CS403@vu.edu.pk

                GOOD LUCK

                Spring 2020_CS403_2.doc

                cyberianC Offline
                cyberianC Offline
                cyberian
                Cyberian's Cyberian's Gold
                wrote on last edited by
                #7

                @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

                Discussion is right way to get Solution of the every assignment, Quiz and GDB.
                We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
                Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
                [NOTE: Don't copy or replicating idea solutions.]
                Quiz Copy Solution
                Mid and Final Past Papers
                WhatsApp Channel
                Mobile Tax Calculator

                1 Reply Last reply
                0
                • zaasmiZ zaasmi

                  Re: CS403 Assignment 1 Solution and Discussion

                  Raza NaqviR Offline
                  Raza NaqviR Offline
                  Raza Naqvi
                  wrote on last edited by zaasmi
                  #8

                  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

                  1 Reply Last reply
                  0
                  • zaasmiZ Offline
                    zaasmiZ Offline
                    zaasmi
                    Cyberian's Gold
                    wrote on last edited by
                    #9

                    Cs403 Assignment 2 Solution.docx

                    Discussion is right way to get Solution of the every assignment, Quiz and GDB.
                    We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
                    Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
                    [NOTE: Don't copy or replicating idea solutions.]
                    VU Handouts
                    Quiz Copy Solution
                    Mid and Final Past Papers
                    Live Chat

                    1 Reply Last reply
                    0
                    Reply
                    • Reply as topic
                    Log in to reply
                    • Oldest to Newest
                    • Newest to Oldest
                    • Most Votes

                    How to Build a $1,000/Month PAK VS BAN Live Live Cricket Streaming
                    File Sharing
                    Earn with File Sharing

                    1

                    Online

                    3.0k

                    Users

                    2.8k

                    Topics

                    8.2k

                    Posts
                    solution
                    1235
                    discussion
                    1195
                    fall 2019
                    813
                    assignment 1
                    428
                    assignment 2
                    294
                    spring 2020
                    265
                    gdb 1
                    238
                    assignment 3
                    79
                    • PM. IMRAN KHAN
                      undefined
                      4
                      1
                      4.0k
                    • Are the vaccines halal or not?
                      undefined
                      4
                      1
                      3.8k
                    • All Subjects MidTerm and Final Term Solved Paper Links Attached Please check moaaz past papers
                      zaasmiZ
                      zaasmi
                      3
                      26
                      75.1k
                    • CS614 GDB Solution and Discussion
                      M
                      moaaz
                      3
                      3
                      8.1k
                    • How can I receive Reputation earning from Cyberian? 100% Discount on Fee
                      Y
                      ygytyh
                      3
                      28
                      23.9k
                    | |
                    Copyright © 2010-26 RUP Technologies LLC. USA | Contributors
                    • Login
                    • Don't have an account? Register
                    • Login or register to search.
                    • First post
                      Last post
                    0
                    • Categories
                    • Recent
                    • Tags
                    • Popular
                    • Pro Blog
                    • Users
                    • Groups
                    • Unsolved
                    • Solved