| Chapter 8 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
39 |
|
Delete Content |
| Chapter 8 - Computer Science |
text |
a) Is it correct to assign Movie_ID as the primary key in... |
40 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
1 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
ha p te r C Structured Query 9 Language (SQL) “Anyuniquei... |
2 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
3 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
database management systems such as MySQL, ORACLE, SQL Se... |
4 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
5 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
N otes Table 9.20 DANCE U MUSIC +------+---------+-------... |
80 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
• SQL is case insensitive. For example, the column names ... |
6 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
7 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
9.3.2 Constraints Which two Constraints are the certain t... |
8 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
9 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
mysql> CREATE DATABASE StudentAttendance; Query OK, 1 row... |
10 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
11 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
• Constraint indicates the restrictions imposed on the va... |
12 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
13 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
81 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
Once data types and constraints are identified, let us Wh... |
14 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
15 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
all such cases, we need to change or alter the structure ... |
16 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
17 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
Syntax: N otes ALTER TABLE table_name ADD UNIQUE (attribu... |
18 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
19 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
Syntax: ALTER TABLE table_name MODIFY attribute DATATYPE ... |
20 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
21 |
|
Delete Content |