Popular Posts
Design resources for developers
Document Table of Contents UI Graphics Fonts Colors Icons Logos Favicons Icon Fonts Stock Photos Stock Videos Stock Music & Sound Effects Vectors & Clipart Product & Image Mockups HTML & CSS Templates CSS Frameworks CSS Methodologies CSS Animations Javascript Animations UI Components & Kits React UI Libraries Vue UI Libraries Angular UI Libraries Svelte UI Libraries R...
Operator in SQL?
Download PDF Google Drive Overview : What is an Operator in SQL? 1. Arithmetic operator Binary Operators Unary Operators 2. Comparison operators 3. Logical operators 4. Operators used to negate conditions
Database Model ( DBMS )
Database Models · A data model is a collection of logical constructs used to represent data structure and relationship within the database. · A database model is used to represent the data into the database. · Database models are given as below: (1) Hierarchical Model · It organizes data in an upside-down tree structure. · There is a hierarchy of parent and child data segments. · It uses Parent Child Relationships. · Here root node is called parent node and root segment is called child node. · The parent can have none, one or more child nodes but child nodes can not have the multiple parent node. · That’s why it represents data into one-to-many relationship between two entities. Advantages : (1) Provide data sharing, data security and data integrity. (2) Parent/child relationship provides data simplicity. (3) Provide efficient 1-M relationship. Dis...
Comments
Post a Comment