Nested Sub Query

Guess your table structure according to the questions given below. Find necessary Entities and Attributes after analyzing the questions stated below:

1. Get the result of all the students who are admitted in the same program as like "CSE" as the student with ID_NO 201810225.

2. Find out the names of all the students who appeared in more than three papers of their opted course.

3. Find the names of all of the managers in the Employees table. Remember that a manager is also an Employee.
Schema:
Employees (emp_id, Emp_name, ManagerID)

4. Find the sales of all stores in the “Rajshahi” Division.
Schema:
Store_Info (store_name, sales, date)
Location (Divsion_names, store_name)

15 comments:

  1. ID: 201710081
    Name : Eusha Chowdhury
    problem 3
    https://drive.google.com/open?id=18XIiZok8VuFmzVx0uAc-B_RvAWE6autK

    ReplyDelete
  2. ID: 201710081
    Name: Eusha Chowdhury
    problem 4
    https://drive.google.com/open?id=1SeeVVfH0iWFDf1paGLhaFyy8tgo3w1Fs

    ReplyDelete
  3. ID: 201710404
    problem 3: https://drive.google.com/open?id=1bqwifvN_u13KwBWP46xRRi2XxkE6aSAY
    Problem 4: https://drive.google.com/open?id=1lNpgKL-q_bftTb1tdBQftzipNd327EsM

    ReplyDelete
  4. ID:201710950
    NUSRAT SUMAYA
    https://drive.google.com/open?id=1G2IN-nKmjwQIccPH5hJdRFNrS0MIryQn

    ReplyDelete
  5. ID:201710950
    IBRAHIM QUAYUM

    https://drive.google.com/open?id=1ZmGqTnlqltSchdRWa7f-E3eK5slkC2zJ

    https://drive.google.com/open?id=1fb0tO-Xj8M4SdJk7pI0lwYYDOBWtsahv

    ReplyDelete
  6. Name:Sumsunnahar Nawa
    ID:201710090
    Sir,All Questions are solved this link....
    Update link:https://drive.google.com/open?id=1mputYsj91VRSfRYPTFtxL5pajxlM-9FK

    ReplyDelete
  7. ID: 201710404
    Problem 1: https://drive.google.com/open?id=1QuGJ4z_XVeAiNS3ssZ5PeUiN9YI3Ijt9
    Problem 2: https://drive.google.com/open?id=1NaBEYmJuvUfH6fpmyQfSbgaxyIjyhytf

    ReplyDelete
  8. Md Rakibul Hasan
    201720620
    answer to the question of 1 and 3
    https://www.dropbox.com/s/n4tc8uk74zk63zt/h3q1q3..pdf?dl=0

    ReplyDelete
  9. Md Aminul Islam Tushar
    ID#201710063
    Solved problem : 1,3,4

    Link : https://drive.google.com/open?id=1-8ygnZO49LWs3H8PN1MM603AZFPZ6T26

    ReplyDelete
  10. Name: Yeasmin Sultana
    ID#201710251
    Link: https://drive.google.com/open?id=1pZOxqWRdFRpHhJdSNXlCN60QhSLT8Lc_

    ReplyDelete
  11. ID : 201620195
    1. https://www.dropbox.com/s/bw0gpokjg294n31/01.sql
    2. https://www.dropbox.com/s/bfd5ydlmffcugzl/02.sql
    3. https://www.dropbox.com/s/fzotyssnpd5nvss/03.sql
    4. https://www.dropbox.com/s/7mba8k3a7ms708h/04.sql

    ReplyDelete
  12. Md Aminul Islam Tushar
    ID#201710063

    Solved Problem : 1,2,3,4

    Link : https://drive.google.com/open?id=1-8ygnZO49LWs3H8PN1MM603AZFPZ6T26

    ReplyDelete
  13. Md Rakibul Hasan
    201720620
    Answer to the question 2 and 4.
    https://docs.google.com/document/d/1iKmILrwWDqN12FMfsFAZX6md2GPHfTJngCUJAFzN_KY/edit?usp=sharing

    ReplyDelete

Popular Posts

Total Pageviews

Followers