DBMS

Que 2
Que 3

Popular posts from this blog

SQL & PLSQL

1. DDL Statements: a) Create the table Invoice with fields inv_no (char, Primary key), mv_no(number), cust_id (char), Issue_date(date), return_date(date). Insert data in the table invoice as follows: Inv_no mv_no cust_id issue_date return_date 101 1 a01 21-Dec-06 25-Dec-06 102 3 a02 19-Oct-06 30-Oct-06 ..... b) Modifying Table Structure by adding the new field price (number) and increasing the size of Inv_no. C) Add and Drop Constraints c 1) Add primary key constraint ii) Drop primary key constraint lil) Add Unique key constraint iv) Drop Unique key constraint v) Add check constraint Answer= >create table Invoice (inv_no char (5) primary key, mv_no number (4), cust_id char (3), issue_date date, return_date date); > select * from Invoice; >insert into Invoice values ('101', 1, 'a01', '21-Dec-06', '25-Dec -06'); >alter table Invoice add (price number (7)); >alter table Invoice modify (inv_no char (7)); 1)alter table Invoice add primary key (...
Read more

Data structure

Image
download pdf Que 1 and que 2 Both are same because edit if needed Download PDF Que 3 - program to create c Code - #include<iostream> #include<string> #include<iomanip> #include<conio.h> #include<dos.h> using namespace std; class Customer private: char name [20]; char telephone [12]; Customer *next; public: void createRecord (Customer**); void delete Record (Customer**); void displayRecord (Customer*); }; void Customer::createRecord (Customer **START) {  *new Node, tempNode; char cName [20]; char telNo[12]; cout<<"Enter customer name (Do not add spaces): "; cin>>cName; cout<<< "Enter customer telephone: "; cin>>telNo; new Node = new Customer; if (new Node == NULL) { cout<< "Insufficient Memory!\n"; } { else strcpy (new Node->name, cName); strcpy (new Node->telephone, telNo); new Node->next = NULL; if (*START == NULL) { *START= new Node; else { tempNode = *START;  (tempNode->next!= NU...
Read more