CBSE : INFORMATICS PRACTICES/CS & AI

  RDBMS CONCEPT REFERENTIAL INTEGRITY  Referential Integrity is a system of rules that a DBMS uses to ensure that relationships between records in related table are valid, and that users don't accidentally delete or change related data. Conditions to set Referential Integrity: ✓ The matching field from the primary table is a primary key or has a unique index ✓ The related fields have the same data type ✓ Both tables belong to the same database When referential integrity is enforced, given rules should be followed: ✓ One can't enter a value in the foreign key field of the related table that doesn't exist in the primary key of the primary table. ✓ One can't delete a record from a primary table, if matching records exist in related table. ✓ One can't change a primary key value in the primary table, if that record has related records. For example, suppose Table B has a foreign key that points to a field in Table A.  Referential integrity would prevent you from adding a ...

  MySQL DATABASE QUESTIONS GRADE XII 1.      What is a database? Name any two RDBMS softwares. 2.      Discuss features of SQL. 3.      Differentiate between ALTER and UPDATE statements. 4.      Elucidate the terms degree and cardinality of a relation. 5.      Answer the following questions on the basis of the given table: Admno             Name               Subject            Gender             Average 1001                 Amit                 Math         ...

  Society Law and Ethics 1. Digital Footprints A digital footprint refers to the traces of online activity left by users when they browse, interact, and engage on the internet. Types of Digital Footprints Active Digital Footprint Information intentionally shared online, such as social media posts, comments, emails, and uploaded files. Passive Digital Footprint Data collected without the user's explicit knowledge, such as browsing history, cookies, IP addresses, and location tracking. Importance of Managing Digital Footprints Protects personal privacy and security. Affects online reputation and digital identity. Employers, universities, and organizations often check digital footprints before hiring or admissions. Cybercriminals can misuse digital footprints for identity theft and fraud. Ways to Manage Digital Footprints Regularly review and update privacy settings on social med...

  VIVA QUESTIONS GRADE XII CS Dear All Be thorough with your project and practical files, as the viva can be asked from anywhere. Stay calm, don’t get nervous, and be confident in front of the examiner. 1. Tell me about your project. 2. Which concepts you have used for your project? 3. What do you mean by front end and back end? How they are important in developing any such projects? 4  Mention the modules and built-in functions you have used in your project. 5. Which real world problems are solved by your project? 6. Explain the most important feature of your project. 7. Name a few mutable data types of python. Lists, Sets, and Dictionaries 8. Name a few immutable data types of python. Strings, Tuples, Numeric 9. Name ordered and unordered data type of python. Ordered – String, List, Tuples Unordred – Set, Dictionaries 10. What is the significance of a pass statement in python? pass is no operation python statement. This is used where python requires syntax but logic requires...

  TUPLES PRACTICE QUESTIONS 1.#  Find the output: tuple1 = (15, 25, 35, 45, 55, 65)  # Given tuple list1 = list(tuple1)  # Convert tuple to list new_list = [] for i in list1:     if i % 5 == 0:            new_list.append(i) new_tuple = tuple(new_list) print(new_tuple) 2.#Give Output of the following code: Tuple1 = (5,6,-1,3) Tuple2 = (7,8,4,-9) Tuple3=() i=0 while i<4:     if(Tuple1[i]–Tuple2[i])%2==0:         Tuple3+=(Tuple1[i] + 2 * Tuple2[i],)     else:         Tuple3+=(2*Tuple1[i] –Tuple2[i],)     i+=1 print(Tuple3) 3.#Give Output of the following code: t=(3.5,1.2,2.6,4.8) L=list(t) count=0 for x in L:     L[count]+=int(x)+count     count+=1 print(L) 4.#Give Output of the following code: t1=(3.5,8,"computer","SCIENCE",False) t2=() for c in t1:     if type(c) == int:         t2+=(3*c,)     elif...

                                                                                     CLASS TEST 1. Write a Python program that asks the user for their age, gender, and current fitness level (beginner, intermediate, or advanced). Based on this information, suggest a suitable fitness plan using if-else statements. Requirements: Inputs : Age (integer) Gender (male/female) Fitness level (beginner/intermediate/advanced) Outputs : Recommend a fitness plan that includes: Suggested workout duration. Type of exercises (e.g., cardio, strength, flexibility). Rest days. Logic : Use if-else to determine the plan based on conditions such as: Age group (e.g., <18, 18–40, >40). Fitness leve...

REVISION NUMBER SYSTEM CONVERSION 1.     Convert the Decimal number(125) 10 into its binary equivalent. 2.     Convert (95) 10 =( ) 2 3.     Convert Decimal fraction into binary fraction : (105.15) 10 4.     Convert (0.14) 10   to binary. 5.     Convert Decimal to Octal : i) (125) 10 ii)(0.21875) 10 6.     Convert the decimal (300) 10 into its Hexadecimal. 7.     Convert (0.03125) 10 into hexadecimal fraction. 8.     Convert (0.675) 10 into hexadecimal form. 9.     Convert (2C9) 16 into decimal. 10. Convert (423) 10 into hexadecimal. 11.   Do the following conversion: i.(ABCD) 16 to ( ?) 2 ii.(3567) 10 to (? ) 8 12. Write Binary equivalent of the following octal numbers. i.2306     ii.743      iii.65.203 13. Write Binary representation of the following hexadec...