RELATIONAL DATABASE Archives | School Portal NG

There are various forms or ways by which database can be set up. They include: Flat file database Relational database Hierarchical database Network database Operational database Distributed database End user database FLAT FILE DATABASE This is the traditional data file storage system ideal for storing small amounts of data that needs to be humanly readable or edited by hand. They are called flat because they contain only one table. The disadvantage is that flat files can be corrupted easily. RELATIONAL DATABASE This is the most common of all the different types of database, files are organized in tables called relations. Each table has a key filed which is used to connect to other tables. Hence the tables are connected through several key fields. HIERARCHICAL DATABASE This form of database has a tree-like structure. In this database, a single table acts as the root of the database from which other tables are connected. All windows operating system operate tree like database. NETWORK DATABASE This database was designed to solve some of the more serious problems with hierarchical database model. Visually network database looks like hierarchical database. DISTRIBUTED DATABASE This form of database is stored on different location connected by client/server network. Data that is been stored are transmitted through network. Each work group may have their own database and are connected through network. EXAMPLES OF DATABASE Microsoft Access Microsoft SQL server Sybase FoxBASE Oracle GENERAL EVALUATION Write short notes on distributed database and flat file database What is database? What is relational database? What differentiate relational database other forms of database? Mention the forms of database. Explain relational database WEEKEND ASSIGNMENT Which of the database connects several tables? A. network database B. flat file database C. relational database D distributed database Which of the databases is like tree structure? A. network database B. flat file database C. relational database D. distributed database One of these applications is not a database application. A. oracle B. foxBASE C. spreadsheet D. MS Access Which of the databases was designed to solve more problem? A. network database B. flat file database C. relational database D. distributed database All but one is not among the types of database. A. network database B. flat file database C. digital database D. distributed database THEORY Why is relational database mostly used? Explain network database See also DATABASE DIGITAL LITERCAY DIGITAL LITERACY DIGITAL DIVIDE DIGITAL DIVIDE

FORMS OF DATABASE