Computer Architecture Lab
Computer architecture is the organisation of the components which make up a computer system and the meaning of the operations which guide its function. It defines what is seen on the machine interface, which is targeted by programming languages and their compilers.
Subject: Database Management System Lab
List of Programs
Assignment SQL – I
Table Creation & Data Insertion
Assignment SQL – II
Table Creation, Constraint Add & Data Insertion, Update.
Assignment SQL – III
Table Creation, Constraint Add & Data Insertion, Alter.
Assignment SQL – IV
Simple Query Retrieval using DML.
Assignment SQL – V
Use of Aggregate Function
Assignment SQL – VI
Join & Sub Query
Assignment SQL – VII
Sub Query, Join & View
Assignment PL/SQL- I
1. To find the largest element from three numbers.
2. To find the factorial value of any number.
3. To print the Fibonacci Series of n numbers.
4. To compute the area of the circle with radius 2,4,6………40. And store the data into a table ‘circle’ containing attributes ‘radius’ and ‘area’.
5. To accept the marks for three subjects from a student, calculate its average. If average <50 then print FAIL, average is between 50 to 60 then Second Division, average is between 60 to 75 then First Division, average is in between 75 and above then print Distinction.
Assignment PL/SQL- II
1. To display all Clerks from emp table using CURSOR.
2. To insert the records of all managers from emp table to newemp and also display on the screen using CURSOR.
3. Create a table dupemp with the records those are inserted, updated or deleted from emp table using TRIGGE
File Link :- Data Base Management Systems Lab
Subject: Computer Application in Pharmacy Lab (PHM41210)
List of Program
Design a questionnaire using a word processing package to gather information about a particular database.
Create an HTML web page to show Personal Information.
Retrieve the information about a drug and its adverse effects using online tools.
Creating mailing labels using Label Wizard, generating Labels in MS WORD, and generating Labels in MS WORD.
Create a database in MS Access to store the patient information with the required fields using Access.
Design a form in MS Access to view, add, delete, and modify the patient record in the database.
Generating reports and printing the reports from patient database
Creating invoice table using MS Access
Drug information Storage and Retrieval using MS Access
Creating and working with queries in MS Access. Construction of query can be accomplished by using either query wizard or query design view.
Exporting Tables, Queries, Forms, and Reports to web page.
Exporting Tables, Queries, Forms, and Reports to XML pages