SMARIKA workeducation | Page 98

Class XI
1.
2.
3.
i) Introduction to Databases
• Entity – Relationship Diagram
• Attributes
• Normalization
• Relationship
ii) Keys
• Primary key
• Foreign key
• Candidate key
• Alternate key
• Composite key
iii) Data Integrity
• Entity Integrity
• Domain Integrity
• Referential Integrity
• User-defined Integrity
Microsoft Access
• Creating Database
• Creating Table
• Inserting, modifying and deleting data in the table.
• Relating tables
• Enforcing Referential Integrity
• Degree of Relationships
SQL Server
• Introduction – What is SQL ?
• Querying Database Tables
• Ordering the results of a Query
• Conditional Retrieval of Rows
90