| Class XII |
Computer Science |
Computer Science |
8 |
a p te C h r 8 Database Concepts “Inconsistencyofyourmind…Can damageyourmemory…Removethe inconsistentdata…Andkeeptheoriginal one!!!” —NisargaJain I... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
paper based approach. To overcome the hassles faced in manual record keeping, it is desirable to store attendance record and student details on sep... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
G-35, Ashok Vihar, Delhi 2 Daizy Bhutia 2002-02-28 Baichung 7110047139 Flat no. 5, Darjeeling Bhutia Appt., Shimla 3 Taleem Shah 2002-02-28 Himansh... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
student 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 sam... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
This is data dependency. Hence, updating the structure of a data file requires modification in all the application programs accessing that file. (F... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
manage databases. Other database and end users or application programs. database systems Retrieving data from a database through special type of us... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
are maintained 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... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
Baichung Bhutia 3612967082 Flat no. 5, Darjeeling Appt., Shimla 101010101010 Himanshu Shah 4726309212 26/77, West Patel Nagar, Ahmedabad 3333333333... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
one or more constraints on that column(s) while creating the tables. For example, one can define the constraint that the column mobile number can o... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
STUDENT as well as in GUARDIAN functionalities like files of the Student Attendance database. This is called security, consistency, Insertion opera... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
has attribute RollNumber which links it with corresponding student record in relation STUDENT. Similarly, attribute GUID is placed with STUDENT tab... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
G-35, Ashok Vihar, Delhi R 111111111111 Baichung Bhutia 3612967082 Flat no. 5, Darjeeling Appt., Shimla t a 101010101010 Himanshu Shah 4726309212 2... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
relational data model, following three properties are observed with respect to a relation which makes a relation different from a data file or a si... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
not NULL. That way,wecanuniquelydistinguisheachtupleofarelation. So, relational data model imposes some restrictions or constraints on the values o... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
together would always have unique value in ATTENDANCE table as on any working day, of a student would be 124 ComputerSCienC- ClaSSXii Reprint 2026-... |
|
| Class XII |
Computer Science |
Computer Science |
8 |
type of data that that can be inserted into the table. DatabaSeConCeptS 125 Reprint 2026-27 • Database schema and database constraints are stored i... |
|
| 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 t er 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 |
data of that attribute. other variants of For example, arithmetic operations can be performed integer and float on numeric data but not on characte... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
some of the commonly used constraints in SQL. They are used to ensure correctness of data. However, it is Key constraint? not mandatory to define c... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
, we will type following command at mysql prompt. 134 C omputerSCienC- ClaSXii Reprint 2026-27 mysql> CREATE DATABASE StudentAttendance; Query OK, ... |
|