Must Know-Database Design Models & Terminology

1. Conceptual Data Model
2. Logical Data Model
3. Physical Data Model

Conceptual- Involves entity relationship model at high level. Involves relationship defination w.r.t entity. This may constitutes high level entity boxes with rough relationship and missing cardinality and modality.

Logical Model- This contains ER diagram with details of cardinality and modality. Logical relationship with key entities member defined. Can layout normalization and denormalization as per business and application style specifications.

Physical - It replicates logical and it is phyical table and overall database defination in implementation mode.

Some Key Technology Jargaons

• Soft Delete
• Hard Delete
• Back Door Enteries
• Audit Trail
• Master Table
• Transaction Table
• DDL
• DML
• SandBox
• Table Lock
• Primary Key
• Refrencial Integrity
• Foreign Key
• Secondary Key
• Cardinality
• Modality
• Commit RollBack
• Transactions
• Records
• Fields
• Indexing
• Clustered vs Non clustered
• Execution plan
• Db Advisor
• Db Examiner
• SQL Lint
• Database Schema
• Replication
• Cursor
• Transaction Log
• Transaction File System
• Temp DB Shrink
• Partision Table
• Scalar Function
• Aggregate Function
• Joins-Set based query
• ACID
• Atomicity
• Link Server
• RDMS-Relational DB Management System
• Blob- Binary Large object