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

                  0

                  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 | Privacy | Terms
                  • 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