BITS WILP DBMS Assignment (Solutions) 2017-H1

survival8: BITS WILP Menu Content

BITS WILP Menu Content

23 comments:

  1. PrashantFebruary 10, 2018 at 7:02 AM

    Awesome...

    ReplyDelete
    Replies
    1. AnonymousApril 17, 2022 at 10:22 AM

      Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Now

      >>>>> Download Full

      Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download LINK

      >>>>> Download Now

      Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Full

      >>>>> Download LINK Ye

      Delete
  2. UnknownApril 26, 2018 at 10:20 AM

    i tried mailing you , but it is not going through. Can you please share the answers to this question paper if you have.

    Thanks

    ReplyDelete
    Replies
    1. Ashish JainApril 27, 2018 at 5:59 AM

      Mail me at ashishjainblogger@gmail.com
      Mention the subject(s) for which you want help.

      Delete
  3. UnknownAugust 14, 2018 at 12:26 AM

    Thanks for putting up the content in such organized manner.Great Help. Thumbs UP !!

    ReplyDelete
  4. AnonymousJanuary 3, 2020 at 10:25 PM

    Recorded lecture links are not working please help

    ReplyDelete
  5. Sid's CurbJune 18, 2020 at 3:36 PM

    Is there a group/whatsapp group for Mtech in computing systems and Infrastructure?

    ReplyDelete
  6. UnknownAugust 5, 2020 at 10:44 AM

    Very useful .. Thank you very much

    ReplyDelete
  7. quantaedsolutionsNovember 30, 2020 at 7:23 AM

    Are you Looking for Smart Device Development? QuantaEd Solutions is the Best Smart Device Development Company, We design and develop smart devices that suit the healthcare requirements. For any inquiry call us we will provide all kind of assistance. For more details visit- https://quantaedsolutions.com

    ReplyDelete
  8. rithiAugust 7, 2021 at 3:19 AM

    This post is so interactive and informative.keep updating more information...
    Software Testing Courses in Mumbai
    Software Testing Training in Ahmedabad
    Software Testing Courses in Kochi
    Software Testing Courses in Trivandrum
    Software Testing Courses in Kolkata

    ReplyDelete
  9. Keerthi55September 26, 2021 at 11:35 PM

    Thanks for the blog article.Thanks Again. Keep writing.
    java online training hyderabad
    java online training in india

    ReplyDelete
  10. Keerthi55September 26, 2021 at 11:45 PM

    Thanks for the blog article.Much thanks again. Fantastic.
    online training in java
    online training on java

    ReplyDelete
  11. Dandy AdamOctober 15, 2021 at 6:42 PM

    AI & ML in Dubai
    https://www.nsreem.com/ourservices/ai-ml/
    Artificial intelligence is very widespread today. In at least certainly considered one among its various forms has had an impact on all major industries in the world today, NSREEM is #1 AI & ML Service Provider in Dubai
    1634348519669-9

    ReplyDelete
  12. Tejaswini WaldeNovember 21, 2021 at 1:45 AM

    Thank you for giving valuable information about software for portable device, we can also develop custom software from pixabulous design.

    ReplyDelete
  13. bhanuDecember 1, 2021 at 5:42 AM

    Nice Blog!!!
    ServiceNow Training
    ServiceNow Online Training in Hyderabad

    ReplyDelete
  14. williambrittoDecember 14, 2021 at 5:24 AM

    This article explains in a clear manner. Nice way of explaining. Thanks for sharing. cloud engineering services

    ReplyDelete
  15. Keerthi55December 17, 2021 at 11:04 PM

    I really liked your blog post.Much thanks again. Awesome.
    java online training
    java training

    ReplyDelete
  16. APTRONDecember 17, 2021 at 11:06 PM

    Data Science Training In Noida
    Data Science course In Noida

    ReplyDelete
  17. Shri Venkateshwara UniversityJanuary 21, 2022 at 1:05 AM

    WILP is a set of educational programs designed in such a way that they can be easily integrated into your work life. Earlier, only highly developed nations like the US and Europe were indoctrinating WILPs but now the WILP in India have also gained a lot of popularity.

    ReplyDelete
  18. Online Shiksha | Online Tuition Classes and Education TipsApril 11, 2022 at 6:10 AM

    Candidates who wish to take the BITSAT should begin studying as soon as possible. Due to the high level of competition, it is critical to follow the best BITSAT 2022 preparation tips recommended by professionals. This blog post contains BITSAT 2022 study suggestions as well as exam pattern and syllabus information. Continue reading to get answers to all of your questions. To know more information visit @ SSSi Online Tutoring Services.

    ReplyDelete
  19. AnonymousApril 17, 2022 at 10:22 AM

    Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Now

    >>>>> Download Full

    Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download LINK

    >>>>> Download Now

    Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Full

    >>>>> Download LINK bO

    ReplyDelete
  20. SairamrealtekAugust 16, 2022 at 9:55 PM

    "Thanks for sharing this informative blog on Best Software Development company in chennai,Software Development Company in chennai,
    Best Software Development company in india,
    Top software development company in chennai,
    Software Development Company in india"

    ReplyDelete
  21. MasterclassspaceMarch 26, 2025 at 1:26 AM

    The BITS Pilani Admission Process is designed to select the brightest minds for its world-class programs. With its independent entrance exam, BITSAT, and direct admission opportunities for board toppers, the institute ensures that only the most deserving candidates secure a place.

    ReplyDelete

Subscribe to: Posts (Atom) 

SQL> create table student_ashish_12345 (sid int primary key, sname varchar2(10), sbranch char(5), sage int constraint stud_sage_ck check (sage <= 25));

SQL> create table course_ashish_12345 (cid int primary key, cname char(4) unique, units int);

SQL> create table studentcourse_ashish_12345 (stid int, cno int, constraint sc_pk primary key(stid, cno), constraint sc_fk1 foreign key (stid) references bits_student (sid), constraint sc_fk2 foreign key (cno) references bits_course (cid));

SQL> select table_name from tabs where table_name like '%ASHISH_12345';

-------------------------------------------------------
Q1. Get branch name and number of students in each branch.

A1. select sbranch, count(sid) from student_ashish_12345 group by sbranch;

Q2. Get sid and sname for those whose age is > 20 and in CSE branch.

A2. select sid, sname from student_ashish_12345 where sage > 20 and sbranch = 'CSE';

Q3. Get sid and sname for those whose name starts with ‘M’.
A3. select sid, sname from student_ashish_12345 where sname like 'M%';

Q4.  Get sid, sname and number of courses registered for those who have at least one course registration.

select sid, sname, cnt 
from student_ashish_12345 a, 
 (select stid, count(stid) as cnt 
 from studentcourse_ashish_12345 
 group by stid having count(stid) >= 1) b 
where a.sid = b.stid;

Q5. Get sid, sname for those who have not registered for any course.

select sid, sname from student_ashish_12345 a where a.sid not in (select unique stid from studentcourse_ashish_12345);

Q6. Get cid, and name for  courses registered by all students from EEE.

--Give the cid, cname of the course 
 for which there does not exist an 'EEE' student 
  for whom there does not exist an entry in studentcourse table 
 

select cid, cname from course_ashish_12345 a 
where not exists ( 
 select sid from student_ashish_12345 b 
 where b.sbranch = 'EEE' and not exists (
  select stid from studentcourse_ashish_12345 c 
  where c.stid = b.sid and c.cno = a.cid
 )
);


--Course that has not been taken by any of the EEE students.
select cid, cname from course_ashish_12345 a where not exists (
 select stid from student_ashish_12345 b, studentcourse_ashish_12345 c where b.sid = c.stid and sbranch = 'EEE' and a.cid = c.cno
);


Q7. Get sid and sname for those registered for at least 3 courses.
select sid, sname from student_ashish_12345
where sid in (
 select stid from studentcourse_ashish_12345 
 group by stid having count(cno) >= 3
);

Q8. Get sid and sname for those whose name has 6 characters.

A8. select sid, sname from student_ashish_12345 where length(sname) = 6;

Q9. Get sid and sname for those who have not registered for any 5 credit course.

A9. 

select sid, sname from student_ashish_12345 a
where a.sid not in (
 select stid from studentcourse_ashish_12345 b, course_ashish_12345 c
 where b.cno = c.cid and c.units = 5
);

Q10. Get sid, sname  for those registered for all 3 credit courses.
--Give the student sid, name 
 for whom there does not exist a three-credit-course
  for whom and which there does not exist an entry in the studentcourse table.

select a.sid, a.sname from student_ashish_12345 a 
where not exists (
 select b.cid from course_ashish_12345 b 
 where b.units = 3 and not exists (
  select c.stid, c.cno from studentcourse_ashish_12345 c 
  where c.stid = a.sid and c.cno = b.cid
 )
);

select a.sid, a.sname from student_ashish_12345 a where not exists (select b.cid from course_ashish_12345 b where b.units = 3 and not exists (select c.stid, c.cno from studentcourse_ashish_12345 c where c.stid = a.sid and c.cno = b.cid));
  
Q11. Get sid and sname for those registered for the course ‘OS’.

select a.sid, a.sname from student_ashish_12345 a 
where sid in (
 select b.stid from studentcourse_ashish_12345 b 
 where b.cno in (
  select c.cid from course_ashish_12345 c 
  where c.cname = 'OS'
 )
);  

Q12. Get cid and cname for thoses not registered by any CSE student.

select cid, cname from course_ashish_12345 
where cid not in (
 select distinct cno from studentcourse_ashish_12345 
 where stid in (
  select sid from student_ashish_12345 
  where sbranch = 'CSE'
 )
);

No comments:

Post a Comment

Subscribe to: Posts (Atom)