Defination A transaction is the basic logical unit of execution in an information system. A transaction is an event which occurs on the database. Generally a transaction reads a value from the database or writes values to the database. State of Transaction Active :A transaction enters into an active state when the execution process begins. […]
Continue ReadingFirst Normal Form (1NF) Each column is unique in 1NF. As per the rule of first normal form, an attribute (column) of a table cannot hold multiple values. It should hold only atomic values. Example: 1 Sample Employee table, it displays employees are working with multiple departments. Employee Age Department Melvin 32 Marketing, Sales Edward […]
Continue ReadingWhat is the ER Model? The ER or (Entity Relational Model) is a high-level conceptual data model diagram. Entity-Relation model is based on the notion of real-world entities and the relationship between them. ER modeling helps you to analyze data requirements systematically to produce a well-designed database. So, it is considered a best practice […]
Continue ReadingAsian IMS NCC Orchid Asian What is mean by inconsistency? => Data inconsistency is a condition that occurs between files when similar data is kept in different formats in two different files or when matching of data must be done between files. Define Data independence. => The ability to modify […]
Continue Reading