Relational Databases and Flatfile Databases

387 Words2 Pages
Questions B 1. A luxury car rental firm keeps the detail of the car it rents out in a table the structure and contents of this table are shown on page 48. a) Give the names of the two fields shown in the above table. Make and Model b) Give the name of the field that should be chosen as the key field. The Reg-number field c) Explain why the field you have chosen for your answer to part (b) should be chosen as the key field. Every car has a unique reg-number, which sets apart the car that you are looking from other cars. d) How many records are there in the table? There are 7 records. 2.a) i) Text ii) Text iii) Boolean b) The Age of the Child, the grade of the child’s class, The past report grades c) UniquePupil Number, because every child has a unique number for his recognition d) Data redundancy, often duplicate data in the table, and time is wasted retyping the same data and more data is stored that required. When a record is deleted, a lot of data that is still useful may also be deleted. e) Use relational databases so that the records can be linked. 3. a) Flat File databases are of limited use and are only suitable for very simple databases. b) Relational Database is a database where the data is held in two or more tables with relationships c) Telephone records 4.a) In relational databases you do not store all the data in a single file or table. Instead the data is stored in several tables with links between the tables to enable the data in the separate tables to be combined together if needed. Flat-file databases are of limited use and are only suitable for very simple databases. Flat files contain one table of data. b) A Relational Database because there are multiple tables needed, making the data about the dresses more organized. The In the flat file there would a data redundancy because customer address details are stored many

More about Relational Databases and Flatfile Databases

Open Document