Navigation

    Cyberian
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Pro Blog
    • Users
    • Groups
    • Unsolved
    • Solved
    1. Home
    2. Mahnoor
    M
    • Profile
    • Following 0
    • Followers 0
    • Topics 1
    • Posts 3
    • Best 0
    • Groups 0

    Mahnoor

    @Mahnoor

    0
    Reputation
    1
    Profile views
    3
    Posts
    0
    Followers
    0
    Following
    Joined Last Online

    Mahnoor Unfollow Follow

    Latest posts made by Mahnoor

    • CS403 Assignment 2 Solution and Discussion

      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 [email protected]

      GOOD LUCK

      Spring 2020_CS403_2.doc

      posted in CS403 - Database Management Systems
      M
      Mahnoor
    • RE: CS315 Assignment 3 Solution and Discussion

      @zareen ans 5th point of first question please as soon as posible

      posted in CS315 - Network Security
      M
      Mahnoor
    • RE: CS315 Assignment 3 Solution and Discussion

      @zareen i need help today is extend date please provide sol

      posted in CS315 - Network Security
      M
      Mahnoor