Database (Queries)
Database Database is collection of entity(table). college- database student- (roll,name,city) faculty- (name,designation,experiance) Types of database 1.local database 2. global database (web database) Database terminology: 1. Field (Representing the records) roll name 1 mohan 2 soham Types of field 1. Single value field(roll no) 2. Multi value field(first name,last name,middle name) 3. Null value field(No compulsory data field Database Tupple (imp): Complete information in a table called tupple Database Management: With the help of key manage complete database key key is a special type of field or managing complete information types of key 1. Primary key 2. Unique key 3. Foreign key Primary key There are two properties 1. No blank 2. No repeat eg. Roll no syntax: create table primary1 (...