Functional Dependency
A Functional dependency is a relationship between attributes. In functional dependency we can obtain the value of another attribute from given attribute. For example,If we know … Read more
A Functional dependency is a relationship between attributes. In functional dependency we can obtain the value of another attribute from given attribute. For example,If we know … Read more
Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller … Read more
There are twelve rules formulated by E.F. Codd for RDBMS in 1970. If an RDBMS satisfies all these twelve rules, then only full benefits of the … Read more
A database relation is a predefined row/column format for storing information in a relational database. Relations are equivalent to tables.Also Known As: Table Characterstics of relation: … Read more
Relationship A relationship is represented by diamond shape in ER diagram, it shows the relationship among entities. There are four types of relationships: One to … Read more
Entity An entity is an object or component of data. An entity is represented as rectangle in an ER diagram. For example: Let we have … Read more