DBMS Lab detailed syllabus for Plastic Technology (Plastic) for 2021-22 regulation curriculum has been taken from the Rajasthan Technical University official website and presented for the plastic technology students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Plastic Technology 3rd Sem scheme and its subjects, do visit Plastic 3rd Sem 2021-22 regulation scheme. The detailed syllabus of dbms lab is as follows.
Course Objectives:
At the end of the semester, the students should have clearly understood and implemented the following:
List of Experiments:
- Stating a database design & application problem.
- Preparing ER diagram
- Finding the data fields to be used in the database.
- Selecting fields for keys.
- Normalizing the database including analysis of functional dependencies.
- Installing and configuring the database server and the front end tools.
- Designing database and writing applications for manipulation of data for a standalone and shared data base including concepts like concurrency control, transaction roll back, logging, report generation etc. 8. Get acquainted with SQL.
In order to achieve the above objectives, it is expected that each students will chose one problem. The implementation shall being with the statement of the objectives to be achieved, preparing ER diagram, designing of database, normalization and finally manipulation of the database including generation of reports, views etc. The problem may first be implemented for a standalone system to be used by a single user. All the above steps may then be followed for development of a database application to be used by multiple users in a client server environment with access control. The application shall NOT use web techniques. One exercise may be assigned on creation of table, manipulation of data and report generation using SQL.
Suggested Tools:
For standalone environment, Visual FoxPro or any similar database having both the database and manipulation language may be used.
For multi-user application, MYSql is suggested. However, any other database may also be used. For front end, VB.Net, Java, VB Script or any other convenient but currently used by industry may be chosen.
Indicative List of Exercises:
- Student information system for your college.
- Student grievance registration and redressal system.
- A video library management system for a shop.
- Inventory management system for a hardware/ sanitary item shop.
- Inventory management system for your college.
- Guarantee management system for the equipments in your college
For detailed syllabus of all other subjects of Plastic Technology, 2021-22 regulation curriculum do visit Plastic 3rd Sem subject syllabuses for 2021-22 regulation.
For all Plastic Technology results, visit Rajasthan Technical University plastic technology all semester results direct link.