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

How to became a junior Engineer

How to become a junior Engineer. We know that about a junior Engineer. We and all have only a question  How I Became? I want to explain you. Every Central and state Government has Organized exam for preparing junior Engineeringlike (polytechnic , Diploma cources etc) Step 1 . Junior Engineer course exam  is organized every year on the month of April,may,and June. Fill the registration appearing form . Step 2. prepare the examination for the junior engineering. Step 3. Appear the examination on the junior engineering Step 4.   If you will pass out the exam then you will appear on the counselling .this time counselling is organized on online so you will fill your choice  branch like(civile engineering,electrical engineering, mechanical engineering, computer science and engineering, mining engineering etc)and choice your college . Step 4.  After fill your choice and college you will allotted a particular branch and college if you like the branch and colle...
Read more

Shape Tweening

 Shape Tweening Create a new movie and draw a red circle in frame 1 using the Oval tool. 1. Click on frame 15 and create a new keyframe by pressing F6. 2. In keyframe 15, draw a large filled square on top of the circle. 3. In the timeline click anywhere between 1 to 15, and select Insert > Create Shape Tween. See Note (4). 4. Test the movie to see the circle tween to the square. 5. To tween the square smoothly back to the circle, click on frame 1, and copy to clipboard by choosing Edit > Copy. 6. Click on frame 30 and press F6 to insert a keyframe. 7. Press DEL to delete the square. 8. Choose Edit > Paste in Place, to put the copied circle in exactly the same place in frame 30 as it was in frame 1. 9. Apply a shape tween between 15 and 30. 10. Test the movie. Save as Ex2.FLA and Ex2.SWF. Note : (4) Shape tweens are reflected in the Timeline by a solid arrow over olive colored frames
Read more

Diabetes pandas(Python)

 import pandas as pd # Read the dataset df = pd.read_csv('pima-indians-diabetes.csv') # Set column names df.columns = ['preg', 'plas', 'pres', 'skin', 'test', 'mass', 'pedi', 'age', 'class'] # Identify and remove duplicate consecutive rows with the same class df = df.drop_duplicates(subset='class', keep='first') # Calculate the averages of the features averages = df.groupby('class').mean().reset_index() # Calculate the percentage reduction original_rows = len(df) reduced_rows = len(averages) percentage_reduction = ((original_rows - reduced_rows) / original_rows) * 100 # Print the new dataframe print(averages) print(f"Percentage reduction: {percentage_reduction:.2f}%")
Read more