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 prorogue 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 line of business that should be chosen as the discover field. The Reg-number field c)Explain wherefore 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 other cars. d)How more cross-files are thither in the table? in that respect are 7 records. 2.a) i) Text ii) Text iii) Boolean b) The long metre of the Child, the grade of the childs class, The past report grades c) UniquePupil Number, because from distributively one(prenominal)(prenominal) child has a unique number for his recognition d) entropy redundancy, very much duplicate data 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 whitethorn as well as be deleted. e)Use relational databases so that the records can be linked. 3.a) Flat File databases are of special(a) use and are unaccompanied suitable for very frank 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 individual file or table. Instead the data is stored in several(prenominal) tables wi th links mingled with the tables to enable ! the data in the separate tables to be unite to discombobulateher if needed. Flat-file databases are of limited use and are only suitable for very simple databases. Flat files hold on 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