Disadvantages Of A Database System

788 Words2 Pages
bulb-icon

Recommended: Difference between management information system and database management system

1. What is database?
A prearranged collection of figures known as data is called database.

2. What is DBMS?
It is a collection of programs that enables user to create and maintain a Database.

3. What is a Database system?
The database and DBMS software together is called as Database system.

4. What is RDBMS ?
RDBMS are database management systems that maintain data records and indices in tables.

5. What are the advantages of DBMS?
Redundancy is controlled.
Unauthorised access is restricted.
Providing multiple user interfaces.
Enforcing integrity constraints.
Providing backup and recovery.

6. What are the disadvantage in File Processing System?
Data redundancy and inconsistency.
Difficult in accessing data.
Data isolation.
Data integrity. …show more content…

1. Data redundancy and inconsistency
2. Difficulty in accessing data
3. Data isolation – multiple files and formats
4. Integrity problems
5. Atomicity of updates
6. Concurrent access by multiple users
7. Security problems

16. Define the "integrity rules"?
There are two Integrity rules.
Entity Integrity: States that "Primary key cannot have NULL value"
Referential Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other relation.

17. What are super, primary, candidate and foreign keys?
A superkey is a set of attributes of a relation schema upon which all attributes of the schema are functionally dependent. No two rows can have the same value of super key attributes.
A Candidate key is minimal superkey, i.e., no proper subset of Candidate key attributes can be a superkey.
A Primary Key is one of the candidate keys. One of the candidate keys is selected as most important and becomes the primary key. There cannot be more that one primary keys in a table.
Foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another

Show More
Related

  • Movie Review: Parental Guidance Film Review

    749 Words  | 2 Pages

    For all individuals in Tables 1 and 2 labeled as a parent or grandparent identify

    Read More

  • Close Relationships Case Study

    1689 Words  | 4 Pages

    - Trait like model represents one factor, meaning that each relationship will display the same attachment

    Read More

  • 4. What Is A Subclass? When Is A Subclass Needed In Data Modeling?

    758 Words  | 2 Pages

    A subclass is needed in data modeling, because it is the easiest way to explain the inheritance relationship between two classes. A subclass is a class that was originated from a new class.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    A database is a structured collection of data. Data refers to the characteristics of people, things, and events. Oracle stores each data item in its own field. For example, a person's first name, date of birth, and their postal code are each stored in separate fields. The name of a field usually reflects...

    Read More

  • The Maya: An Ancient Civilization

    1032 Words  | 3 Pages

    This database entry was one very general but contained a lot of different topics. It was helpful to use this entry while finding the last details to tie everything together.

    Read More

  • Privacy and Security Issues in Data Mining

    1885 Words  | 4 Pages

    [7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.

    Read More

  • Entity Relationship Diagram

    613 Words  | 2 Pages

    Maintaining detailed customer information is a critical function of a video rental store’s relational database. The primary key of the Customer entity class could be a field named Customer ID Number that is a unique number automatically generated when a new customer is entered. The video store could also choose to use a unique number identifying the customer such as driver’s license number, phone nu...

    Read More

  • Familial Love Essay

    1255 Words  | 3 Pages

    distinguishes a tie between people that will provide that interaction as well as keep the interaction consistent on a regular basis.

    Read More

  • Difference Between Database System and Information Retrieval System

    524 Words  | 2 Pages

    Information Retrieval is simply a field concerned with organizing information. In other terms, IR is emphasizing the range of different materials that need to be searched. Others researcher said that IR is the contrast between the strong structure and typing a database system with the lack of structure in the objects typically searched in IR. The actual process in information retrieval systems is it has to deal with incomplete or under specified information in the form of the queries issued by users. IR uses the techniques of storing and recovering and often disseminating recorded data especially through the use of a computerized system.

    Read More

  • Brief History Of Databases

    1727 Words  | 4 Pages

    of multiple types of end users. The data is stored in one location so that they

    Read More

  • Database

    761 Words  | 2 Pages

    Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.

    Read More

  • Hashing and Randomizing

    925 Words  | 2 Pages

    A hash table, or (a hash map), is a data structure that associates keys with values. The primary operation it supports efficiently is a lookup: given a key (e.g. a person's name), find the corresponding value (e.g. that person's telephone number). It works by transforming the key using the hash function into a hash, a number that is used as an index in an array to locate the desired location ("bucket") where the values should be.

    Read More

  • Disadvantages and Problems of Computer Technology

    1648 Words  | 4 Pages

    The coming of the 21st century brought many new advances in technology. Emails began replacing written letters, technology began replacing direct social conversations and computers brought more people indoors. Many viewed this as a good thing, and thought that we should not resist technology’s advancement. However, many others believed that humanity was deteriorating and all good values would come to an end. While both groups of people had great arguments for their side, new technology is without a doubt bringing many negative effects. This even continues today, and those who thought the new technology was only a good thing are turning out to be incorrect. Problems are appearing involving social media, video games, the Internet and hacking. The world remains unsure about whether or not technology is good, one thing is clear: the effects of technology are not all positive. As technology increases, the world becomes a seemingly better place; however, it may not be as great as we think.

    Read More

  • The Database Management System (DBMS)

    1438 Words  | 3 Pages

    The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources.

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 Pages

    In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.

    Read More

More about Disadvantages Of A Database System

Open Document