Please differentiate between the Relational Database and the Flat Database. Whic
ID: 651371 • Letter: P
Question
Please differentiate between the Relational Database and the Flat Database. Which is most productive for the Information Systems Analysis? We are looking for technical detail in your response. Please relate the general concepts of Database development with the overall Information System Analysis goal.
Please differentiate between the Relational Database and the Flat Database. Which is most productive for the Information Systems Analysis? We are looking for technical detail in your response. Please relate the general concepts of Database development with the overall Information System Analysis goal.
Explanation / Answer
Database is a collection of data that is organized in the form of tables. Tables help in accessing and managing data. A relational database has many tables that relate to each other with the help of key fields. They are flexible than flat files.
Flat files contain only single table of data.
A notepad can be an example for flat file. A text file can be used as a flat file. It is difficult to maintain and manage data in flat files.
To understand the advantages of a relational database, imagine the needs of two small companies that take customer orders for their products. Company A uses a flat file database with a single table named orders to record orders they receive, while Company B uses a relational database with two tables: orders and customers.
When a customer places an order with Company A, a new record (or row) in the table orders is created. Because Company A has only one table of data, all the information pertaining to that order must be put into a single record. This means that the customer's general information, such as name and address, is stored in the same record as the order information, such as product description, quantity, and price. If customers place more than one order, their general information will need to be re-entered and thus duplicated for each order they place.
Whenever there is duplicate data, as in the case above, many inconsistencies may arise when users try to query the database. Additionally, a customer's change of address would require the database manager to find all records in orders that the customer placed, and change the address data for each one.
Company B is much better off with its relational database. Each of its customers has one and only one record of general information stored in the table customers. Each customer's record is identified by a unique customer code which will serve as the relational key. When a customer orders from Company B, the record in orders need contain only a reference to the customer's code, because all of the customer's general information is already stored in customers.
This approach to entering data solves the problems of duplicate data and making changes to customer information. The database manager need change only one record in customers if someone changes addresses.