Relational Databases and Flatfile Databases

Questions B 1.A luxury machine rental firm keeps the distributer point of the car it rents out in a accede the social structure and contents of this table ar shown on page 48. a) kick in the names of the two sketch shown in the above table. birth and Model b)Give the name of the field that should be chosen as the discover 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 be looking from a nonher(prenominal) cars. d)How many a(prenominal) expresss be thither in the table? thither are 7 records. 2.a) i) Text ii) Text iii) Boolean b) The historic period of the Child, the grade of the childs class, The past report grades c) UniquePupil Number, because from all(prenominal) one(prenominal)(prenominal) child has a unique number for his recognition d) data redundancy, very much duplicate data in the ta ble, and magazine is wasted retyping the aforesaid(prenominal) data and more data is stored that required. When a record is deleted, a lot of data that is still useful may as well as be deleted. e)Use relational databases so that the records can be linked. 3.a) Flat File databases are of peculiar(a) use and are unaccompanied suitable for very artless databases. b) Relational Database is a database where the data is held in two or more tables with relationships c) echo records 4.a) In relational databases you do not store all the data in a wholeness file or table. Instead the data is stored in some(prenominal) tables with links mingled with the tables to enable the data in the separate tables to be unite to get inher if needed. Flat-file databases are of limited use and are only suitable for very simple databases. Flat files brook wiz table of data. b) A Relational Database because there are dual tables needed, making the data about the dresses more organized. The In the flat tire file there would a da! ta redundancy because customer address details are stored many times for each time they hire a dress. On the other hand, a relational database is where the data is...If you want to get a complete essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay