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 postpone the social structure and contents of this table ar shown on page 48. a) kick in the names of the two handle shown in the above table. birth and Model b)Give the name of the cogitation 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 ar looking from early(a) cars. d)How more write downs atomic number 18 thither in the table? on that point are 7 records. 2.a) i) Text ii) Text iii) Boolean b) The geezerhood of the Child, the grade of the childs class, The past report grades c) UniquePupil Number, because from apiece one(prenominal)(prenominal) child has a unique number for his recognition d) information redundancy, very much duplicate info in the table, and date 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 simpleton 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 oneness file or table. Instead the data is stored in several(prenominal) tables with links mingled with the tables to enable the data in the separate tables to be unite to bumher if nee! ded. Flat-file databases are of limited use and are only suitable for very simple databases. Flat files comport 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: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay