photographypana.blogg.se

Comparison b/w E/R model and Relational model.

Relational databases and relational database schemes, Entity integrity, referential integrity and foreign key. Relational constraints and relational database schemes Domain constraints, Key constraints and constraints on Null. Relational Model Concepts: Domain, Attributes, Tuples cardinlity, keys(Primary, Secondary, foreign, alternative keys) and Relations. Entities and Attributes, Entity types and Entity sets, Key attribute and domain of attributes, Relationship among entities, Database design with E/R model. Model (Entity Relationship Model)ĭata Models Classification File based or primitive models, traditional data models, semantic data models. Classification of Database Management Systems- Centralized, Distributed, parallel and object based.ģ. Database Languages and Interfaces DBMS Language, DBMS Interfaces. Data Independence Logical data Independence, Physical data Independence. DBMS Architecture The External level, The conceptual level, The internal level, Mappings. Database System Concepts and Architectureĭata models, schemas, instances, data base state.