Relational Databases and Flatfile Databases

Questions B 1.A luxury machine letting firm keeps the distributor channelize of the motorcar it rents out in a accede the kindly structure and contents of this table ar shown on foliate 48. a) kick in the call of the two fields shown in the above table. birth and Model b)Give the propose of the field that should be elect as the discover field. The Reg-number field c)Explain why the field you have elect for your answer to part (b) should be chosen as the cay field. E very(prenominal) car has a grotesque reg-number, which sets apart the car that you are looking from different(a) cars. d)How many records are at that place in the table? at that place are 7 records. 2.a) i) Text ii) Text iii) Boolean b) The years of the Child, the grade of the childs class, The past report grades c) UniquePupil Number, beca affair from distributively one(prenominal)(prenominal) child has a unique number for his recognition d) Data verbiage, very much duplicate information in the table, and time is purposeless retyping the aforesaid(prenominal) info and more than data is inventoryd that required. When a record is deleted, a lot of data that is placid useful may as well as be deleted. e)Use comparative databases so that the records give the gate be linked. 3.a) Flat institutionalise databases are of extra use and are unaccompanied worthy for very ingenuous 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 single file or table. Instead the data is stored in several tables with colligate mingled with the tables to enable the data in the separate tables to be yoke together if needed. Flat-file databases are of limited use and are single suitable for very simple databases. Flat files contain sense table of data. b) A relative Database because there are soprano tables needed, making the data approximately the dresses more organized. The In the plain tire file there would a data redundancy because customer address expound are stored many measure for each time they film 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: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper