Global Assam Educational Hub

Habit 1 . Cultivate Inner Networks: Entrepreneurs practicing the art of business success know the power of networks. They take the time to identify and build relationships with key peers, mentors, and advisors. This inner network provides support, direction, and an increased number of people to assist. Having an inner network of five people who have a network of five more, grows the network exponentially. Habit 2. Customer Centric: Business success requires an unwavering commitment to the customer. This commitment encompasses a mindset of understanding the customers' world. Understanding the customers wants and needs provides the business with a greater opportunity to earn a loyal customer base. Focus away from business and profits, and toward what you can do to improve the life of your customers.

Describe the three levels of data abstraction? There are three levels of abstraction:  1. Physical level: The lowest level of abstraction describes how data are stored. 2. Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data. 3. View level: The highest level of abstraction describes only part of entire database. Define the "integrity rules" in DBMS (Data Base Management System)? There are two Integrity rules.  1. Entity Integrity: States that "Primary key cannot have NULL value" 2. Referential Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other relation. How is the data structure of System R different from the relational structure? Unlike Relational systems in System R  1. Domains are not supported 2. Enforcement of candidate key uniqueness is optional 3. Enforcement of entity integrity is optional 4. Referential...

 What do you mean by atomicity and aggregation in DBMS ? 1. Atomicity: Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete transactions. DBMS ensures this by undoing the actions of incomplete transactions. 2. Aggregation: A concept which is used to model a relationship between a collection of entities and relationships. It is used when we need to express a relationship among relationships. Inage Courtesy www.blog.paessler.com  What is a Phantom Deadlock? In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to identify deadlocks that do not really exist. Such situations are called phantom deadlocks and they lead to unnecessary aborts.  What is a checkpoint and When does it occur? A Checkpoint is like a snapshot of the DBMS state. By taking checkpoints, the DBMS can reduce the amount of work to be done during restart in the event of subse...

 What is indexing and what are the different kinds of indexing? Indexing is a technique for determining how quickly specific data can be found.  Types:  1. Binary search style indexing 2. B-Tree indexing 3. Inverted list indexing 4. Memory resident table 5. Table indexing Image Courtesy : www.javaassignmenthelp.com What is system catalog or catalog relation? How is better known as? A RDBMS maintains a description of all the data that it contains, information about every relation and index that it contains. This information is stored in a collection of relations maintained by the system called metadata. It is also called data dictionary.