-

Implementation of Queue using lists in python


click

Comments

Post a Comment

Popular posts from this blog

Constraints

-
Image
Constraints protect the database from errors. It puts restrictions on database state. Types of Constraints in Relational Model Domain Constraint Key Constraint Entity Integrity Constraint Referential Integrity Constraint  Types of Constraints that cannot be captured in relational model Semantic Constraints (Business Rules)                        eg : Buy one get one free Domain Constraint Value of each attribute in a tuple must be atomic (no repeating values) and consistent with its domain(data type). It could be null if allowed. Key Constraint key constraint specifies that the values in the column declared as a primary key must be unique. Types of keys Candidate Key            A relation has several keys referred to as candidate keys.but one candidate key is unique. it is               called the prima...
Read more

Normalization

-
Image
Normalization is a process for evaluating and correcting table structures to minimize data redundancies, thereby reducing the likelihood of data anomalies. Normalization starts by identifying the dependencies of a given relation and progressively breaking up the relation (table) into a set of new relations (tables) based on the identified dependencies. Normal Forms 0NF            Multi-valued attributes exists 1NF           Any multi-valued attributes (repeating groups) have been removed. 2NF           Any partial functional dependencies have been removed 3NF           Any transitive dependencies have been removed BCNF           Any anomalies resulting from functional dependencies have been removed 4NF           Any multi valued dependencies have been removed 5NF         ...
Read more