Add A Flat File Relational Database



Suppose you are in the business of selling catnip products. You need a database system to keep track of your customers, products and orders.
 The Nip Shopped DBMS

An application that manages a small amount of data could be a candidate for a flat-file relational database (FFRD).Like a traditional database, FFRD data is stored in tables with rows and columns. The tables use primary and foreign keys and are linked through one-to-one, one-to-many, and many-to-many relationships, and records are character-delimited text files.

In this example there are three tables: Customers, Products and Order Items. There is a one-many relationship between both Customers and Order-Items and Products and Order-Items.




***