Exam Details
| Subject | Data Base Management System Lab | |
| Paper | ||
| Exam / Course | Bachelor of Computer Applications / Masters in Computer Applications (PRACTICALS) | |
| Department | School of Computer and Information Sciences (SOCIS) | |
| Organization | indira gandhi national open university | |
| Position | ||
| Exam Date | June, 2016 | |
| City, State | new delhi, |
Question Paper
No. of Printed Pages: 1
IBCSL-034 -Set -21
BACHELOR OF COMPUTER APPLICATIONS (Revised)
00278
Term-End Examination
June, 2016
BCSL-034 -Set DATABASE MANAGEMENT SYSTEMS
LAB
Time: 1 hour Maximum Marks: 50
Note: There are 2 questions in this paper carrying 20 marks each.
Answer them both.
10 marks are for viva-voce.
1. Create the database for the given schema below
ENROLL Section)
TEACH (Prof, Section)
ADVISE (Prof,
PRE_REQ
GRADES Grade, Year)
STUDENT Sname)
is student number, is course number, Prof in this is advisor of Pre_C# is prerequisite course, Sname is student name. Input 10 meaningful records.
2. For the above database given in Q1, answer the following queries using SQL
List all the students taking courses with Prof Rahul.
List all the students taking at least one course that their Advisor (Prof) teaches.
List all the courses offered by Prof. Mathews
List all the professors and their courses.
List the Grades of all students with course number "123" for the year 2016.
IBCSL-034 -Set -21
BACHELOR OF COMPUTER APPLICATIONS (Revised)
00278
Term-End Examination
June, 2016
BCSL-034 -Set DATABASE MANAGEMENT SYSTEMS
LAB
Time: 1 hour Maximum Marks: 50
Note: There are 2 questions in this paper carrying 20 marks each.
Answer them both.
10 marks are for viva-voce.
1. Create the database for the given schema below
ENROLL Section)
TEACH (Prof, Section)
ADVISE (Prof,
PRE_REQ
GRADES Grade, Year)
STUDENT Sname)
is student number, is course number, Prof in this is advisor of Pre_C# is prerequisite course, Sname is student name. Input 10 meaningful records.
2. For the above database given in Q1, answer the following queries using SQL
List all the students taking courses with Prof Rahul.
List all the students taking at least one course that their Advisor (Prof) teaches.
List all the courses offered by Prof. Mathews
List all the professors and their courses.
List the Grades of all students with course number "123" for the year 2016.
Other Question Papers
Departments
- Centre for Corporate Education, Training & Consultancy (CCETC)
- Centre for Corporate Education, Training & Consultancy (CCETC)
- National Centre for Disability Studies (NCDS)
- School of Agriculture (SOA)
- School of Computer and Information Sciences (SOCIS)
- School of Continuing Education (SOCE)
- School of Education (SOE)
- School of Engineering & Technology (SOET)
- School of Extension and Development Studies (SOEDS)
- School of Foreign Languages (SOFL)
- School of Gender Development Studies(SOGDS)
- School of Health Science (SOHS)
- School of Humanities (SOH)
- School of Interdisciplinary and Trans-Disciplinary Studies (SOITDS)
- School of Journalism and New Media Studies (SOJNMS)
- School of Law (SOL)
- School of Management Studies (SOMS)
- School of Performing Arts and Visual Arts (SOPVA)
- School of Performing Arts and Visual Arts(SOPVA)
- School of Sciences (SOS)
- School of Social Sciences (SOSS)
- School of Social Work (SOSW)
- School of Tourism & Hospitality Service Sectoral SOMS (SOTHSM)
- School of Tourism &Hospitality Service Sectoral SOMS (SOTHSSM)
- School of Translation Studies and Training (SOTST)
- School of Vocational Education and Training (SOVET)
- Staff Training & Research in Distance Education (STRIDE)
Subjects
- Advanced database management systems
- Assembly Language Programming Lab
- C and Assembly Language Programming
- C Language Programming
- C' Programming and Data Structure
- C++ Programming Lab
- Computer Basics And PC Software Lab
- Computer Fundamentals and PC Software
- Computer Networks
- COMPUTER ORIENTED NUMERICAL TECHNIQUES LAB
- Data And File Structures Lab
- Data Base Management System Lab
- Internet Concepts and Web Design
- Introduction to algorithm design lab
- Introduction to Internet Programming (Java)
- Introduction to System Software
- Java Programming Lab
- Laboratory Course (For Data and File Structures, Networking, DBMS Lab & Java Programming
- Laboratory Course (For OOAD, Software Engineering and Accountancy and Financial Management
- Laboratory Course in (Advanced Internet Technologies & Computer Graphics and Multimedia)
- Network Programming and Administration Lab
- Operating System Concepts and Network Management Lab
- RDBMS Lab
- Statistical Techniques Lab
- TCP/IP Programming
- UNIX and DBMS Lab
- WEB PROGRAMMING LAB
- Windows Programming