Assignment - 02

 

  1. Assignment - 02



  5. -- Create Project table
  6. CREATE TABLE Project (
  7.     pno NUMBER PRIMARY KEY,
  8.     pname VARCHAR2(50) NOT NULL,
  9.     manager_no NUMBER,
  10.     CONSTRAINT FK_Manager FOREIGN KEY (manager_no) REFERENCES Manager_details(manager_no)
  11. );
  12.  
  13. -- Create Manager_details table
  14. CREATE TABLE Manager_details (
  15.     manager_no NUMBER PRIMARY KEY,
  16.     manager_name VARCHAR2(50)
  17. );
  18.  
  19. INSERT INTO Manager_details (manager_no, manager_name) VALUES (101, 'John Manager');
  20. INSERT INTO Manager_details (manager_no, manager_name) VALUES (102, 'Jane Manager');
  21.  
  22. -- Ensure that the manager_no in Project references existing manager_no in Manager_details
  23. INSERT INTO Project (pno, pname, manager_no) VALUES (1, 'Project A', 101);
  24. INSERT INTO Project (pno, pname, manager_no) VALUES (2, 'Project B', 102);
  25. -- Try to insert a record with a non-existent manager_no, which will be restricted
  26. INSERT INTO Project (pno, pname, manager_no) VALUES (3, 'Project C', 103); -- This should fail
  27.  
  28. -- Alter the EMP table to add 'commission' attribute and modify 'sal' datatype
  29. ALTER TABLE EMP ADD commission NUMBER(7, 2);
  30.  
  31. -- Modify the datatype of 'sal'
  32. ALTER TABLE EMP MODIFY sal NUMBER(7, 2);
  33.  
  34. -- Insert a new record with all attributes
  35. INSERT INTO EMP (empid, name, date_of_birth, city, salary, commission, dob, designation, dependence)
  36. VALUES (201, 'New Employee', TO_DATE('1990-01-01', 'YYYY-MM-DD'), 'City X', 80000.00, 1000.00, TO_DATE('2022-01-01', 'YYYY-MM-DD'), 'Analyst', 1);
  37.  
  38. -- Add 'designation' attribute to EMP table
  39. ALTER TABLE EMP ADD designation VARCHAR2(50);
  40.  
  41. -- Update designation for existing records
  42. UPDATE EMP SET designation = 'Programmer' WHERE empid IN (101, 102, 103);
  43.  
  44. -- Add 'manager_no' attribute to EMP table
  45. ALTER TABLE EMP ADD manager_no NUMBER(10);
  46.  
  47. -- Update 'manager_no' for existing records
  48. UPDATE EMP SET manager_no = 1001 WHERE empid = 101;
  49. UPDATE EMP SET manager_no = 1002 WHERE empid = 102;

Comments

Post a Comment

Popular posts from this blog

what is Machenical Engineering

We are also Know that about the Engineering. I am explain you about Meachenical Engineering  So, Meachenical Engineering is a branch of engineering which deals the study of machines, machines,and many types of instruments and tools ralated works. How I became a Mechanical engineer The National and state government is organized a Enterence Exam like (JEE Mains, Advance,and other state level and college level exams) Course:- BE/ B.tech in Meachenical Engineering Diploma in Meachenical Engineering ME/M.tech in Meachenical Engineering Ph.D in Meachenical Engineering Other type of other courses Job opportunities:- All Government sectors All private sectors All factories There were more career opportunity in this branch Eligibility:- Student should be pass in 12th examination with physics Chemistry and math 10 yh pass for Diploma only After the Bsc and Msc. I hope this Information is helpful for you.
Read more

PHOTO ( CHINESE LADKA)

 Lab 7 Adding point type Horizontal or vertical type can be created anywhere in an image. One can enter point type (a single letter, word, or line) or paragraph type. 1. In the Layers panel, select the Background layer. 2. Select the Horizontal Type tool (T), and, in the options bar, do the following: • Choose a serif typeface, such as Minion Pro Regular, from the Font Family popup menu. • Type 144 pt for the Size, and press Enter or Return. • Click the Center Text button. 3. In the Character panel, change the Tracking value to 100. 4. Click on the center guide you added to set an insertion point, and type DIGITAL in all capital letters. Then click the Commit Any Current Edits button ( ) in the options bar. 5. Select the Horizontal Type tool (T), and select the “DIGITAL” text. 6. Open the Font Family pop-up menu in the options bar. Move the cursor over the fonts, either with the mouse or using arrow keys. When the cursor is over a font name, Photoshop applies that font to the selected
Read more

Arithmatic operations, factorial of a number, while loop, prime number, etc

      EX.NO:4.aARITHMETIC OPERATIONS USING CASE Aim: To write a shell program to perform the arithmetic operations using case Algorithm :   Step 1 : Read the input variables and assign the value Step 2 : Print the various arithmetic operations which we are going to perform Step 3 : Using the case operator assign the various functions for the arithmetic operators. Step 4 : Check the values for all the corresponding operations. Step 5 : Print the result and stop the execution. . Program code :   echo 1.Addition echo 2.Subraction echo 3.Multiplication echo 4.Division echo Enter your choice read a echo Enter the value of b read b echo Enter the value of c read c echo b is $b c is $c case $a in 1)d=`expr $b + $c` echo the sum is $d ;; 2)d=`expr $b - $c` echo the difference is $d ;; 3)d=`expr $b \* $c` echo the product is $d ;; 4)d=`expr $b / $c` echo the quotient is $d ;; esac
Read more