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 | December, 2016 | |
| City, State | new delhi, |
Question Paper
No. of Printed Pages: 1
IBCSL-034(P)/S41
BACHELOR OF COMPUTER APPLICATIONS (Revised) Term-End Practical Examination December, 2016 00748
BCSL-034(P)/S4 DATABASE MANAGEMENT SYSTEMS LAB
Time: 1 Hour Maximum Marks: 50
Note: There are two questions in this paper carrying 20 marks each.
Answer both of them.
Rest 10 marks are for viva-voce.
1. Create the following table with the fields given below for Department of Engineering and Technology
(Programme_Code, Programme_title, No_of_students_Enrolled, Year_of_start, No_of_centres_Activated, No_of_credits, No_of_semesters, Prog_Coordinator)
Select a primary key. Input at least 10 meaningful records. Select appropriate datatypes for all the fields.
2. For the above table designed in Q.1, answer the following queries using SQL 5x4=20
To display all the programme_code along with their programme_title.
To find the highest enrolled programme.
To display the No_of_centres activated for Computer Science and Engineering programme.
To display the No_of_credits of Mechanical Engineering programme.
To display all the programmes whose Year_of_start is 2000.
IBCSL-034(P)/S41
BACHELOR OF COMPUTER APPLICATIONS (Revised) Term-End Practical Examination December, 2016 00748
BCSL-034(P)/S4 DATABASE MANAGEMENT SYSTEMS LAB
Time: 1 Hour Maximum Marks: 50
Note: There are two questions in this paper carrying 20 marks each.
Answer both of them.
Rest 10 marks are for viva-voce.
1. Create the following table with the fields given below for Department of Engineering and Technology
(Programme_Code, Programme_title, No_of_students_Enrolled, Year_of_start, No_of_centres_Activated, No_of_credits, No_of_semesters, Prog_Coordinator)
Select a primary key. Input at least 10 meaningful records. Select appropriate datatypes for all the fields.
2. For the above table designed in Q.1, answer the following queries using SQL 5x4=20
To display all the programme_code along with their programme_title.
To find the highest enrolled programme.
To display the No_of_centres activated for Computer Science and Engineering programme.
To display the No_of_credits of Mechanical Engineering programme.
To display all the programmes whose Year_of_start is 2000.
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