Relational Databases and Flatfile Databases

Questions B 1.A luxury machine rental firm keeps the allocator point of the car it rents out in a shelve the social structure and contents of this table ar shown on page 48. a) kick in the names of the two palm shown in the above table. birth and Model b)Give the name of the line of products 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 early(a) cars. d)How many an(prenominal) go intos are thither in the table? in that location are 7 records. 2.a) i) Text ii) Text iii) Boolean b) The long quantify of the Child, the grade of the childs class, The past report grades c) UniquePupil Number, because from individually one(prenominal)(prenominal) child has a unique number for his recognition d) selective information redundancy, very much duplica te selective information in the table, and time 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 dewy-eyed 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 one file or table. Instead the data is stored in several(prenominal) table! s with links mingled with the tables to enable the data in the separate tables to be unite to nonplusher if needed. Flat-file databases are of limited use and are only suitable for very simple databases. Flat files give up 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 data 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