| Class XII |
Computer Science |
Computer Science |
7 |
a video b) Marking attendance by teacher c) Writing tweets d) Filling an application form online 5. Consider the temperature (in Celsius) of 7 days... |
|
| Class XII |
Computer Science |
Computer Science |
7 |
do following analysis on the basis of food items procured and sold in the canteen: a) Compare the purchase and sale price of fruit juice and biscui... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
a p te r C h 8 Database Concepts “Inconsistencyofyourmind…Can damageyourmemory…Removethe inconsistentdata…Andkeeptheoriginal one!!!” —NisargaJain I... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
based approach. To overcome the hassles faced in manual record keeping, it is desirable to store attendance record and student details on separate ... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
Ashok Vihar, Delhi 2 Daizy Bhutia 2002-02-28 Baichung 7110047139 Flat no. 5, Darjeeling Bhutia Appt., Shimla 3 Taleem Shah 2002-02-28 Himanshu Shah... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
names are maintained in both the files. Besides, in Table 8.1, students with roll numbers 3 and 5 have same guardian name and therefore same guardi... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
data dependency. Hence, updating the structure of a data file requires modification in all the application programs accessing that file. (F) Contro... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
Other database and end users or application programs. database systems Retrieving data from a database through special type of use a command comman... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
for both the siblings. We know this is a redundancy and by using a database we can avoid this. So let us split the STUDENT file into two High Cost ... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
3612967082 Flat no. 5, Darjeeling Appt., Shimla 101010101010 Himanshu Shah 4726309212 26/77, West Patel Nagar, Ahmedabad 333333333333 Danny Dsouza ... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
more constraints on that column(s) while creating the tables. For example, one can define the constraint that the column mobile number can only hav... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
well as in GUARDIAN functionalities like files of the Student Attendance database. This is called security, consistency, Insertion operation on the... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
RollNumber which links it with corresponding student record in relation STUDENT. Similarly, attribute GUID is placed with STUDENT table for extract... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
Vihar, Delhi R 111111111111 Baichung Bhutia 3612967082 Flat no. 5, Darjeeling Appt., Shimla t a 101010101010 Himanshu Shah 4726309212 26/77, West P... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
data model, following three properties are observed with respect to a relation which makes a relation different from a data file or a simple table.... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
NULL. That way,wecanuniquelydistinguisheachtupleofarelation. So, relational data model imposes some restrictions or constraints on the values of th... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
would always have unique value in ATTENDANCE table as on any working day, of a student would be 124 ComputerScienc- ClassXII Reprint 2026-27 marked... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
of data that that can be inserted into the table. DatabaseConcepts 125 Reprint 2026-27 • Database schema and database constraints are stored in dat... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
the table. f) Software that is used to create, manipulate and maintain a relational database. 2. Why foreign keys are allowed to have NULL values? ... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
Sports name column, and column order is also different) DatabaseC oncepts 127 Reprint 2026-27 N otes Table: Sports Preferences Sports Roll_no Badmi... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
the tables and the key which are required to retrieve this detail. 128 C omputerScience- ClassXII Reprint 2026-27 c) What is the degree of EMPLOYEE... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
key. b) Is it correct to assign AudiNo as the primary key in the AUDI relation? If no, then suggest appropriate primary key. c) Is there any foreig... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
ha p te r C Structured Query Language (SQL) “Anyuniqueimagethatyoudesire probablyalreadyexistsontheinternetor insomedatabase...Theproblemtodayisno ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
do much more, besides querying. SQL provides statements for defining the structure of the data, manipulating data in the database, declaring constr... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
of that attribute. other variants of integer and float For example, arithmetic operations can be performed data type? on numeric data but not on ch... |
|